470,850 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,850 developers. It's quick & easy.

Cutomize Report Presentation

Hi..i am newbie and student in programming,so need help from expert.

Here is what i want to do.
1-I want to create Report System/Reporting System.
2-User must choose database and enter username and password.
3-Go to report form.
4-Click report type.

It has has 4 types of report.
Report A=Query 1
Report B=Query 2
Report C=Query 3
Report D=Query4

5-User click <date from> and <date to> from datetimepicker,to filter data by date.
6-User click button generate report.
7-Then, the report automatically generate following the format based on date and type of report that user choose .

My Question:
a)How can i make the report auto generate same as user choose.
Let say when user choose report type A,so the report is auto generate report as type A format.


Report A = Query 1
Select * from Student;

ReportB = Query 2
SELECT Language,
Sum(IIf(State='New Zealand',1,0)) AS State1,
Sum(IIf(State='India',1,0)) AS State2,
Sum(IIf(State='Malaysia',1,0)) AS State3,
Sum(IIf(State='Singapore',1,0)) AS State4,
Sum(IIf(State='India',1,0)) AS State5,
Sum(IIf(State='Indonesia',1,0)) AS State6,
Sum(IIf(State='Paris',1,0)) AS State7,
Sum(IIf(State='Rusia',1,0)) AS State8,
Count State AS Total
FROM Student
WHERE Language Is Not Null
GROUP BY Language;

Above is sample the type of report or format report that i want to display.
So how can i customize the report presentation as same as user select?

I hope i can get any idea or solution from expert in this case.
Now im in learning process.
Thank you very much.

Additional Information:
It is normal report only use by list view or else, not a crystal report.
Aug 8 '08 #1
0 997

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Mir Nazim | last post: by
5 posts views Thread by Peter Chant | last post: by
6 posts views Thread by Takeadoe | last post: by
10 posts views Thread by John Dann | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.