Report from stored procedure

Ramya

Hi,

Am using asp.net with C#.

I have a requirement to generate the report for the table which is generated dynamically. That is the select query for the table will only be generated dynamically at the time of report generation.

During the creation of the frx file, I don't know the structure of the data source. When a end user request for the report, the only thing it gives is the "Sql Query" from which a table can be generated.

How to design the frx file? I am struck up with this.

Please help me.

Thanks a lot.

Ramya

AlexTZ

Hello,

Since the sql query may return completely different column set, you have to create your report in code. You may find the info about such report creation in the Demos\C#\ReportFromCode demo.

Ramya

AlexTZ wrote: »

Hello,

Since the sql query may return completely different column set, you have to create your report in code. You may find the info about such report creation in the Demos\C#\ReportFromCode demo.

Hi,

Thank you for your reply.
I tried with the help of the demo.
In this, the designer file is opening. But I dont want to open the designer. Insteed the real report has to generated and opened.

What should I do for getting the report directly?

Thank you.

Ramya

AlexTZ

Just call report.Show() instead of report.Design().

Ramya

AlexTZ wrote: »

Just call report.Show() instead of report.Design().

Thanks for your kind support.