I want to display sample information, user chromatogram peak table and usergraphics on a single sheet and have a sheetbreak for every sample (multidatafile report). My first attempt is displayed in the following picture:
It didnt work as expected as the ItemID for the sample information (surprisingly to me) differs from the ItemIDs of the peak table and the graphicfile (the latter are identical). I then realized that the AnalysisID in the sample information table seems to be [ItemID] (peak table or graphicfile) - 2. So I built a workaround and referred the repeating CMD to a CustomID. This ID is established via formula columns in the tables and is defined as [AnalysisID] + 2 in the sample information table and as [ItemID] in the peak table / graphicsfile.
My question now is: Is the AnalysisID in general defined as [ItemID] peak table or graphicfile + 2 or is this just coincidence? I only tested this on a few samples and it worked fine.
Are there perhaps more elegant ways to achieve my goal?
Kind regards
EDIT: I probably should emphasize the following: There is no "SampleID" or "AnalysisID" in the XML Report maps for peak tables or graphic files in Qualitative Analysis templates. I can only refer to the ItemIDs
Hi mhuegel,
Unfortunately the ItemID is not an easy thing to determine by simple rules like add this offset to one item to reach another but linked. A Sample can have multiple chromatograms each with a unique ItemID and there will be a cluster of Chromatogram Peak List rows related to that ItemID and having the same ItemID. So you have to understand the hierarchy and follow the ItemIds as you go.
I know that you are on B.07.00 but you may want to consider an upgrade to Qual 10, which will be available in the VERY near future, because it now has PDF Report Builder which will produce better quality report (without Excel) and I think you'll find a little easier to work with.