Cutomize Report Presentation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • akmaRudiliyn
    New Member
    • Jun 2008
    • 12

    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.

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