Databand only accessing first instance of data
Posted: Tue Oct 26, 2021 5:01 pm
Hello,
I am having issues getting an additional parameter added to my report. I made a new data source by linking a SQL database by batchID and I'm trying to get the sample description to be added to the table.
When I put the sample description in the current databand that contains the count data, it only accesses the first sample description and prints that one repeated.
When I add a second databand with the source as the SQL database, then it prints out each sample description as expected. But this information is stuck in a completely separate databand.
How do I get the sample description from the SQL database to iterate through each sample and print in the same table as my count data?
I've attached the .mrt template.
I am having issues getting an additional parameter added to my report. I made a new data source by linking a SQL database by batchID and I'm trying to get the sample description to be added to the table.
When I put the sample description in the current databand that contains the count data, it only accesses the first sample description and prints that one repeated.
When I add a second databand with the source as the SQL database, then it prints out each sample description as expected. But this information is stuck in a completely separate databand.
How do I get the sample description from the SQL database to iterate through each sample and print in the same table as my count data?
I've attached the .mrt template.