Dynamic Report

Comments

• AlexTZ

  October 2009 edited 6:44AM

  Hello,
  
  You need to change the query before generating a report:
  
  report.Load(...);
  TableDataSource query = report.GetDataSource("YourQuery") as TableDataSource;
  query.SelectCommand = "select * from ....";
  report.Show();
• Ramya cbe

  October 2009 edited 6:44AM

  AlexTZ wrote: »

  Hello,
  
  You need to change the query before generating a report:
  
  report.Load(...);
  TableDataSource query = report.GetDataSource("YourQuery") as TableDataSource;
  query.SelectCommand = "select * from ....";
  report.Show();

  
  
  Hello AlexTZ,
  
  Am using fast report in asp.net with C#.
  As am new to fast report, please explain me in detail what we give in the .frx file and in the asp.net code side.
  
  My requirement is, I want to generate a report in which the number of columns and the actual column will be fixed dynamically by the user.
  
  Please help me.
  
  Thanks in advance.
  
  Ramya
  
• AlexTZ

  October 2009 edited 6:44AM

  You can change the sql text in the WebReport.StartReport event handler (i.e. in your asp.net code), or use the report script to do this. In the latter case, go the report designer, select the "Report" item in the Properties window, click the "Events" button and create an event handler for the StartReport event. The code would be:
  

  TableDataSource query = Report.GetDataSource("YourQuery") as TableDataSource;
  query.SelectCommand = "select * from ....";
  

  
  You may use report parameters to pass a query text. To do this, define a parameter and use it in the script:
  

  TableDataSource query = Report.GetDataSource("YourQuery") as TableDataSource;
  query.SelectCommand = (string)Report.GetParameterValue("SQLText");
  

  
  To pass a parameter value, use the WebReport.StartReport event handler:
  

  WebReport.Report.SetParameterValue("SQLText", your_text);