Report Builder assistance

Thank you very much for your reply. I checked out the Gen_LIMs template, and I agree that's a bit closer, but it doesn't have the data wrapping (??) that I'm trying to do.  I've include a table below showing the start of what I'm hoping to build. Data file is in the first column, and the columns 2-4 refer to the responses (peak areas) of the internal standards. Each row 2-6 gives the internal standard response of each internal standard for each file.

I realize I could probably just make simple two-column reports with data file and one internal standard response, and then join them back together in excel, but I want to see if there was a way to generate the report already in this format, so then we could simply cut and paste the entire table. 

Hello karah ,

Reports like that are not easy to make in Report Builder because of how the data tables are stored and how the reporting works. It is possible with some careful bindings and a bit of repetition and hard coding. There are some examples in the Community where customers have done similar reports and have multiple qualifiers on the same row. You would need to make two bindings for each ISTD you want to report. It may be possible to simplify this with some clever work, but for an example I just hard coded the compound names and in limited testing this works.  

You can modify the existing bindings in the LIMS template and filter for the ISTD name in the SelectedCompound binding and then reference that binding in the Peak binding for each ISTD.

Then change the column headers to be Text and just put the name of the ISTD in that column. Then in the value cell reference the appropriate ISTD binding, ISTD_1_Info, ISTD_2_Info, etc.

Hello karah ,

Reports like that are not easy to make in Report Builder because of how the data tables are stored and how the reporting works. It is possible with some careful bindings and a bit of repetition and hard coding. There are some examples in the Community where customers have done similar reports and have multiple qualifiers on the same row. You would need to make two bindings for each ISTD you want to report. It may be possible to simplify this with some clever work, but for an example I just hard coded the compound names and in limited testing this works.  

You can modify the existing bindings in the LIMS template and filter for the ISTD name in the SelectedCompound binding and then reference that binding in the Peak binding for each ISTD.

Then change the column headers to be Text and just put the name of the ISTD in that column. Then in the value cell reference the appropriate ISTD binding, ISTD_1_Info, ISTD_2_Info, etc.