Report from stored procedure
Ramya
cbe
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
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
Comments
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
Thanks for your kind support.