pdf Report Builder decimal places and multiple chromatograms per page

Question

Dear all,

I am trying to customize an existing template in the pdf report builder version 10.1.

I have two unsovled problems.

1. How can I define the number of decimal places for eg. RT, Calc. Conc., Area...?

I was able to change it for 'Accuracy': I am not sure if it was correct but it worked (see appendix: Format: #.#), but this procedure did not work for the other columns.

2. I would like to show multiple chromatorgams on one page (eg. 4 in a row and 6 in a column, comparable to the "compounds-at-a-glance" function on the MH Quant software).

In best case: one row compound chromatrograms and the next row the respective internal standard chrom.

or alternating (e.g. compound sample 1, ISDT sample 1, compound sample 2, ISDT sample 2 etc). .

At the moment I get only one sample per page (commpound and ISTD chrom. side by side). How can I change this?

Could someone help me?

howard_sanford · Accepted Answer

simse , I do not observe that behavior with the fixed point (f) formatter. I have tested on the injection volume and without that specifier I get 5 and with it I get 5.00. This also agrees with the examples in the Microsoft documentation. Are you certain that what you are trying to format is a number and not text? Did you make certain to remove the format binding and field name? As for the reporting for your chromatograms, I have attached a modification of the summary template Gen_ResultsSummary_ISTD.template.xml. I have not done extensive testing and I'm not 100% certain on the bindings/list/table settings I used, but for the DOA data it will produce the following.

howard_sanford · Answer

Hi simse , Number formatting in Report Builder follows the standard formatting for Microsoft .NET. You can find all available options here for numbers. They give examples for specific programming languages, but all you need is the syntax of the format specifier to make something work in report builder. So if you wanted to follow their fixed point example (f) you would simply specify the format of the desired field to be f2 for 2 decimal places. Select the cell you want to change the formatting on. If there is anything in the Binding Name/Field Name under Field Format blank those out, and then enter the formatting you want to use in the Format field. As for the chromatograms that may be possible in Report Builder but it would require some very elegant and carefully made bindings in order to extract more than one result row at a time for one table/list row. You may be able to get some ideas from this discussion , though I don't think you can apply what they have done directly to your issue. I have attached a report template made by one of our Application Engineers that shows how to get a target and its ISTD on one row. Again I'm not certain you can use this to do exactly what you want, but it may give you some ideas of things to try.

pdf Report Builder decimal places and multiple chromatograms per page

Top Replies