By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,864 Members | 1,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,864 IT Pros & Developers. It's quick & easy.

Cutomize Report Presentation

P: 12
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.

Eg:

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
Share this question for a faster answer!
Share on Google+

Post your reply

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