Last post Jan 12, 2011 02:57 AM by ravi.aspx
Jan 11, 2011 12:54 PM|ravi.aspx|LINK
Hi I am new to fyireporting.. I have few basic questions..
Q1) my data in the table is as mentioned below
Name Contact Address Group
A 1245 HYD G1
B 343 CHN G2
C 123 DEL G2
D 980 BNGL G1
E 654 KOL G2
This shud be displayed in report as below
Group : G1
A 1245 HYD
D 980 BNGL
Group : G2
B 343 CHN
C 123 DEL
E 654 KOL
I am quite tired of searching how to display it like groups.. :(
Q2) The table in Question1, I need to get that data by using 2 sql queries .. How can i use 2 sql queries 2 generate a single report?
Q3) I need to give numbering to the records in the report.
Consider the report in Question1 , I need to give no 1 to Group 1, and two records in that group will hv numbers 1 and 2.
Similarly, Group 2 shud hv number 2, and the record ll hv the numbers 1,2 and 3.
Q4) I need to display the current date in the report. How can i get the current date. The built-in function Date() in sql server is not working for me. . :(
Any response to these basic questions is highly appreciated. If you are not familiar with fyireporting, please answer the above questions relating to any other reporting tool that u r using. so tht i can get the basic idea.
Jan 11, 2011 05:19 PM|sansan|LINK
How can i use 2 sql queries 2 generate a single report?
You just need to write a single query
SELECT Name, Contact, Address, Group
If you are not familiar with fyireporting, please answer the above questions relating to any other reporting tool that u r using. so tht i can get the basic idea.
If you were using Crystal reports, you can create a group using GroupExpert and drag the Group Field onto Group Header. Then, Drag other key fields onto details section. That should display the records in the layout that you mentioned. It might be similar
to the tool that you are using
Jan 12, 2011 02:23 AM|ravi.aspx|LINK
Hi santosh.. thnks for d reply..
grouping is fine but still hv smtng to do.. i wanna display 3 columns in group header
lets say,according to my table... i wanna display. group(G1), group name(ABCD),Contact person(Ravi)
..how can i do this??...
and, i hv created a table report and unable to move the fields werever i want.. pls let me know if u find how to drag the fields..tq
Jan 12, 2011 02:32 AM|ravi.aspx|LINK
Hii.. draggin and grouping I did finally on my own.. tq.. please do not care abt the previous reply..
can u pls help me on how to get current date and numbering..
Jan 12, 2011 02:57 AM|ravi.aspx|LINK
Hi.. date is also fine... sorry for hurry posting.... :)... anyway thnks a lot for gvng basic ideas... I ll get back to u if i get any doubts on my way