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.
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.