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.
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
FROM Users
ravi.aspx
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
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
ravi.aspx
Member
30 Points
79 Posts
fyi reporting basics (FYIreporting)
Jan 11, 2011 11:54 AM|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.
Thanks
Ravi
sansan
All-Star
53942 Points
8147 Posts
Re: fyi reporting basics (FYIreporting)
Jan 11, 2011 04:19 PM|LINK
You just need to write a single query
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
ravi.aspx
Member
30 Points
79 Posts
Re: fyi reporting basics (FYIreporting)
Jan 12, 2011 01:23 AM|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
ravi.aspx
Member
30 Points
79 Posts
Re: fyi reporting basics (FYIreporting)
Jan 12, 2011 01:32 AM|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..
Thanks
Ravi
ravi.aspx
Member
30 Points
79 Posts
Re: fyi reporting basics (FYIreporting)
Jan 12, 2011 01:57 AM|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
Thanks
Ravi