Chromatography Forum

I am trying to go from using separate reports (one for the calibration curve, a different one for controls, one for samples, etc, etc) to putting everything in a single report that can be populated using a result set. I have used the correct functions for "label" and "label reference" and have had a lot of success getting everything in to one report using table data filters.

However, i am having some formatting problems. The empower help menus are not incredibly useful and I can not find any articles pertaining to these problems exactly. So here they are, hopefully someone has the answers and maybe others can benefit.

1) The portion of the report for the calibration curve plot and points table lists all of peaks integrated even though I am only calibrating for one peak in particular. I get the error message "Calibration Plot group for xxx contains no data" for every secondary component and a similar error for the calibration points table. This takes up about half a page and is not pretty.

2) I would like to create summary tables that contain information about multiple peaks in an injection. I might need to report the concentration of one peak, the purity of a second, and then the concentration of the third peak for instance. If I do not divide this in to three separate tables I will get a 3 lines for each injection, each line only having one of the columns filled out.

3) I need to set up my reports to handle n number of samples. If i set the tables to U* it will include all the injections from all samples in the same table. Is there a way to have empower create additional tables as needed by how far the U01, U02,.... labels go in the sample set? The only other way I can see to do it is to make a different table for each unknown. U01* U02* and so on an so forth. This would be cumbersome and still not able to handle infinite numbers of samples. Also, I have 3-4 tables for each sample as is...See problem 2

Leaving the data in 7-8 separate reports is not an option. I have spoken to people who have taken the "Advanced Empower Class" through waters and still do not know the answers to these questions. Thanks in advance for your help.

I have solved problem #3 by using the "Group By" table filter and setting it to "Label" or "Sample Name" as needed. Still no luck with the first two problems though...

1) The portion of the report for the calibration curve plot and points table lists all of peaks integrated even though I am only calibrating for one peak in particular. I get the error message "Calibration Plot group for xxx contains no data" for every secondary component and a similar error for the calibration points table. This takes up about half a page and is not pretty.

2) I would like to create summary tables that contain information about multiple peaks in an injection. I might need to report the concentration of one peak, the purity of a second, and then the concentration of the third peak for instance. If I do not divide this in to three separate tables I will get a 3 lines for each injection, each line only having one of the columns filled out.

1) You maybe can overcome this by using the order by > filtering to filter out everything you don't want in your report.

2) Maybe you can create sample custom fields, which extract the wanted information per sample (like 3 custom fields per sample).
Then you can make a table with your sample name, and your custom fields as columns.

3) you found out that one by yourself!


Good luck

Ace

1) The portion of the report for the calibration curve plot and points table lists all of peaks integrated even though I am only calibrating for one peak in particular. I get the error message "Calibration Plot group for xxx contains no data" for every secondary component and a similar error for the calibration points table. This takes up about half a page and is not pretty.

2) I would like to create summary tables that contain information about multiple peaks in an injection. I might need to report the concentration of one peak, the purity of a second, and then the concentration of the third peak for instance. If I do not divide this in to three separate tables I will get a 3 lines for each injection, each line only having one of the columns filled out.

1) You maybe can overcome this by using the order by > filtering to filter out everything you don't want in your report.

2) Maybe you can create sample custom fields, which extract the wanted information per sample (like 3 custom fields per sample).
Then you can make a table with your sample name, and your custom fields as columns.

3) you found out that one by yourself!


Good luck

Ace

Hi ryant8762,

I have just read your dilemma...

You could also create one custom field that will report a different specified field for each component (such as concentration for xyz, purity for abc, ...). This custom field can then be displayed in one table or formatted as you require in the report.
This done by creating an enumerated custom field. Enumerate by Name (component names), for example ENUM(EQI(Name, "xyz"), (EQI(Name, "abc"), ... being sure to spell the component names (xyz and abc in this example) correctly. Then use the translation table to specify the field you would like to be displayed for that component using the fc syntax -> FieldName (fc) . Finally, set the custom field Calculation Criteria to Use As "Field".

Hope this helps; update with how you get on with this,
Ben

Thank you for all of your input! I should have some downtime this weekend to try to fixes.

1) For the calibration component names I have alreeady tried using the filtering method. I set the calibration plot and table to "calibration ID > 1" on basis that only the components being calibrated would have any result ID at all. I will try using a different filter, maybe that will get rid of all the extra error statements.

2) I will work on enumerated custom fields to see if I can make any progress. This is a little more complicated than other custom fields I have created in the past. I might end up back here with questions

Thanks again Aceto and Ben!

Hi Ryant8762,

If I get time, I will help where I can.

Just read your problem number 1... this should not really be a problem.

I quick work around from just the information here, is to use the data filtering for the Calibration Plot and the Points table. I know this has been suggested already and you have tried using calibration ID, but calibration ID is not quite as simple as it seems.

Have you tried filtering against peak names using the field "Name"? I think Name is found under Calibration Curve (and also Peaks amongst others). Filter using Name not equal to; then insert the name of the components you do not wish to show (once again the spelling must be correct and so does the capitalisation here).

Once again, update how this works.
Cheers,
Ben

I am having a similar issure with bracketing standards. I have a report set up that will only work properly with the first set of bracketing standards. Any more and they are all including in an overlay chromatogram and one table. I am trying to display the two bracket injections in one overlay with averaged result on a table, next will be the sample those brackets apply to, and then the NEXT bracket injections and so on. Is there any filter that will allow only 2 injections into a table/chromatogram? Without specifying every single set?