Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
millaine
Starting Member
6 Posts |
 Posted - 2009-06-23 : 04:09:19
|
| Good day everyone,I'd like to know how to go about generating a report(RDL) dynamically. The data from the report is gotten from a dynamic SQL so there is no way of me knowing the number of columns I will be getting.Is there an API or model to do this? Or do I just generate the good old XML file definitions fo an RDL in code?Is there also a way to programmatically deploy the report on an SQL server. Am thinking that after the user runs his report, the RDL is created and replaces the existing one on the server.I'd really appreciate any help at all on this.Thanks in anticipation.Millaine. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 04:16:14
|
I think the grid component automatically can sense how many columns there are, if you set the stored procedure as datasource.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
millaine
Starting Member
6 Posts |
Posted - 2009-06-23 : 04:19:45
|
| Thanks peso. However, the grid component is too strict a structure.I want to have a bette control over how the report looks so i cant just bind a grid component to the datasource... |
|
|
|
|
|
|
Dynamic generation of RDL