Hi,
I am creating reports using a dataset which is being created at runtime.I have a vb.net form to which crystalreportviewer control and a button are added. When I click on the button the reportviewer should show the report.
The code for button as follows
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cr As New CrystalReport1
        Dim ds As New Data.DataSet("MyTable")
        Dim rds As Data.DataSet
        Dim dt As New Data.DataTable("MyTable")
        dt.Columns.Add("Age1", System.Type.GetType("System.Int32"))
        dt.Columns.Add("Age2", System.Type.GetType("System.Int32"))
        dt.Columns.Add("Age3", System.Type.GetType("System.Int32"))
        Dim dr As Data.DataRow
        dr = dt.NewRow
        dr(0) = 1
        dr(1) = 2
        dr(2) = 3
        dt.Rows.Add(dr)
        dr = dt.NewRow
        dr(0) = 1
        dr(1) = 2
        dr(2) = 3
        dt.Rows.Add(dr)
        dr = dt.NewRow
        dr(0) = 1
        dr(1) = 2
        dr(2) = 3
        dt.Rows.Add(dr)
        dr = dt.NewRow
        dr(0) = 1
        dr(1) = 2
        dr(2) = 3
        dt.Rows.Add(dr)
        ds.Tables.Add(dt)
        cr.SetDataSource(ds)
        cr.SetParameterValue(0, 1)
        CrystalReportViewer1.ReportSource = cr
    End Sub

But when I try to run, it says no tables in the dataset. I am quite pissed with this problem. :( Any one can help me out. Is there any alternatives for this method.
Thanks
Dhiman

Hi Dhimak:
I am trying to achieve the same thing though I have absolutely no information as to how to even start off with passing parameters from my aspx page, which will act input parameters for the sql query on which the report will be based on.
Can you please guide with that or tell the source where i can look for this specific information.
that is, after a user selects specific options from the aspx page I wish to view the report based on the user choices presented by the aspx page.

It seems that you creates your dataset dynamically. Such kind of dataset cannot be bind to a report, I guess. I've accomplished your task in the follow steps in C#:

1. Creates a typed dataset.
2. Binds the typed dataset to a report in the report designer.
3. Creates the typed dataset and a datatable dynamically.
4. Sets the data source and report source.

That works in C#. I guess your problem is that you haven't bound your dataset to the report yet.

Good luck!

Try converting your dynamic dataset into the typed dataset usign the merge() method.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================