Data sources and Parameters problem!

Comments

• AlexTZ

  July 2009 edited 2:33AM

  Hello,
  
  1) Do you mean "Text" object? Just put a text object on the Data band and set databand's source to your datasource.
  2) You can do it in your application's code.
  
  report1.SetParameterValue("MyParam", 10)
  will create a parameter with "MyParam" name if it does not exist.
  
  3) If you want to adjust page size/orientation/margins, use "File|Page Setup..." menu.
• jain

  July 2009 edited 2:33AM

  Sorry!
  
  For 1's problem, i mean when i set DATA SOURCE alredy , but i want to show the DATA with CODE-like FOR() recursion to get each DATA onto textbox, how can i do this function?
  
  For 3's problem, i want to adjust design page when i design report, not set page size when print.
  
  Thank you!
• AlexTZ

  July 2009 edited 2:33AM

  1) Use the following code:
  

        // get the data source by its name
        DataSourceBase rowData = Report.GetDataSource("Products");
        // init the data source
        rowData.Init();
        
        // now enumerate the data source
        while (rowData.HasMoreRows)
        {
          textBox1.Text += ((String)Report.GetColumnValue("Products.ProductName"));
          // go next data source row
          rowData.Next();
        }
  

  
  the "((String)Report.GetColumnValue("Products.ProductName"))" part can be added by dragging a data column from the "Data" window to the script.
  
  3) To adjust a page zoom, use the zoom controls in the right-bottom edge of the designer.
• jain

  July 2009 edited 2:33AM

  Thank You!