nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to loop through data set values for a yesterday hourly report?

Robsen

Hello. 
I have a Web Service data source which allows me to provide a timestamp and a name parameter. 
It then returns a number for that 2 parameters. 
E.g. 2015.06.15 12:00:00 Value1 => Result: 42
 
Goal: 
Is to create an automated report with yesterdays numbers, one for each hour and for several name parameters.

Find more posts tagged with

Comments

Clement Wong

You can use nested tables. The outer table would return the last 24 hours. For each row, it would return the timestamp and the name parameter. The inner table would run against your web service data source, and the input values to the web services call would come from the results of outer table row.
 
Examples:
<a data-ipb='nomediaparse' href='https://wiki.eclipse.org/Nested_Tables_using_two_Scripted_data_sets_(BIRT)'>https://wiki.eclipse.org/Nested_Tables_using_two_Scripted_data_sets_(BIRT)</a>
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1103-nested-data-sets-with-input-parameters/'>http://developer.actuate.com/community/forum/index.php?/files/file/1103-nested-data-sets-with-input-parameters/</a>
 
 
BTW, I wasn't able to get much out of your attached design example. There wasn't a data source or data set. Just one data report item with formatted date/time.

Robsen

Hallo.
 
Thank your for your quick reply. 
Sorry for the bad design file, i attached the finished rptdesign file now.

Clement Wong

The attached example illustrates using a scripted data set in the outer table. Now, I didn't have a web service available that used date/time so I used a web service that returned location and timezone information for a given zip code. The outer scripted data set would increment the zip code by 1, and stops after 2 records.
 
I left comments in the attached report design pointing out that you'll need to increment the scripted data counter until 23 to cycle through the last 24 hourly timestamps. This part of the code will generate the date/time starting with yesterday at midnight and increment hourly until the 24 hourly times have been generated.
 
row["Time"]= BirtDateTime.addHour(BirtDateTime.addDay(BirtDateTime.today(),-1),currentrow)
 
To create this report, I have an outer table (bound to the scripted data set). In the detail row, I dropped in the web service data set. You will now have an inner table. For the inner table, I changed the Binding > Data Set Parameter Binding... to the outer table zip code column. In your case, it would be the date / time.

Robsen

Hello Clement,
 
thank you very much for the excellent example. 
Especially the comments in the file are very helpful.
 
Best regards