Need to generate .rdlc at runtime for dynamic report processing in a web form.

Need to generate .rdlc at runtime for dynamic report processing in a web form.

• Vighnesh Prabhudesai

  I have a similar need as you. Were you able to come up with a feasible solution for your problem

  Thanks in advance

  
  

• jason duncan

  hi GlennL,

  SQLBuilder and RDLGenerator are both build in house.

  We first tried to look, if we could get product that could help us in building

  an application, but could not find any in the Market, so we end up building

  our in house solution.

  RDLGenerator takes business objects as input and emits RDL(XML) as

  output. Initial idea was actully based on Microsoft RDL Generator that they

  have it on their web site in Report Viewer section.

  Thanks,

  Anthony Desa

  
  

• P.H.

  I too have a need for this functionality using SQL Server. I do not want the users to "manage" their own reports. Nor do I want to "manage" particular instances of reports for every customer database. You see, we have potentially hundreds of customer databases, all hosting the same schema but not the same data (federated you might say). The same set of report stored procedures exist in every database. If I use Report Manager/Visual Studio, I must bind the data columns to the RDL. If my schema changes, I have to re-bind every RDL again. I also cannot dynamically select the server and database used by the RDL based on the user's login plus additional information in a master database.

  From what I can deduce in the literature, a local processing mode ReportViewer control on a Web Form may give me some better formatting control and Dudas Chart capabilities. Saving the output to a PDF or Excel before printing is not too bad to gain the superior pagination capabilities.

  
  

• DanglingChap

  Anthony:

  I'm working on a similar app for my company. What "SQL Builder" are you using...a google search shows several products with that name Also, I asume the "RDLGenerator" is the one on MSDN

  Thanks!

  GlennL

  
  

• Raguvind

  Thanks Anthony!!!

  GlennL

  
  

• levsha

  We are working on support for Oracle in Report Builder and hope to release it in a future update.
  

• JohnHadj

  I discuss this strategy in my new book.

  While it would be possible to create an RDLC file on the fly I've seen little call for that aapproach--it's just XML and there are tools aplenty to manage an XML file in code. Are you saying that you don't know what columns the user wants in the report ahead of time--that the user is to define the report If this is the case, then you need to look at the Report Builder product (from Microsoft). It might be better suited for your needs. If, however you can choose from a standard set of reports, then it's just a matter of laying out each report in the designer and saving these RDLC files somewhere. These can be called up at runtime (hopefully after they have been tested) and you can fill in the report parameters on the fly.

  hth

  
  
  

• riemerg

  My understanding is that Report Builder is a product used with SQL Server. We are using Oracle.

  Yes, I want the user to select which fields to view as well as selecting certain values from those fields. There will be certain standard reports but some users want to create custom reports as well.

  
  

• mxmissile

  Hi,

  We have build an application using this concept. Its called Query Tool.

  It lets uses select the field that they wanted to see in the report. It also can permit

  them to arrange the order of the field in the report. It let user define different filtering

  criteria for report such as Greater Then, Less Then, Is Between. Once user has defined

  criteria then you we use SQL Builder to build the SQL and RDLGenerator to generate the

  RDL. We Generate the RDL on fly and feed it to Report Viewer Control, The performance

  of the application is amazing. We are planning to sell the tool in market as it is a generic tool

  so you will be able to use it for your applicaiton. Please contract The Marketing Store for

  details.

  Thanks,

  Anthony Desa

  
  
• Need to generate .rdlc at runtime for dynamic report processing in a web form.