in the template report, is it possible to pull data from the different tables with syntax instead of a subreport?

Permanently deleted user

11 Augusti 2016 22:10

i have a dataset with 4 tables within.  i need to place data from each of the four tables in multiple textbox locations on an output report.  is it possible to poplulate textbox values with data from my tables without a subreport?

 

 

0

• 

  Permanently deleted user

  12 Augusti 2016 14:33

  Jeff,

   

  I'm not sure what data is in the datatables in your dataset, but this might help you get started.  I have a table named 'Current_Year_Sales' which is the second datatable in my dataset.  In report designer I am getting the value of the attribute 'terms' from the first row and place it in a text box within my report.  To do this I use the following in my script:

   

  

   

  I'm assuming if there are mutliple rows you can loop through the rows and concatenate the string to place it in the textbox as well.

   

  Hope this helps,

   

  Marshall

  0
• 

  Permanently deleted user

  15 Augusti 2016 18:28

  Marshall, 

   

  this works!!!

   

  I have an additional question.

   

  Do I need to iterate the Rows[0] as i loop through the table, (there is a one to one with the main table) so when i go to record 5 on the main do i need to look at rows[5]?

   

  or should i just leave well enough alone.

   

  Jeff

  0

Du måste logga in om du vill lämna en kommentar.