Creating textboxes for reports on the fly

[argsemapp]

I am working on a form that allows the user to select several alloys to display chemical compositions for a report. I am able to successfully get the alloys I need onto a (global) recordset.



The 'Chemical Composition' recordset itself has over 30 fields (one for each element on the periodic table, ie Iron, Zinc, Gold, etc.), each field is either a '0' or has some value (bc it's an element in the formula of the alloy). Every alloy can have a drastically different chemical composition.

Basically I need to find a programmatic way to get my report to "go through the recordset display a 2xN grid for each alloy ('N' being the number of elements in the alloy), with each 'column' that prints to have the Element on top then the value for that element below it. I.E.:

REPORT

          [Fe]  [Cr]
Alloy 1   50%   50%

          [Ag]  [Cr]  [Co]
Alloy 2   25%   50%   25%

...

Alloy N

Thank you for any tips/hints/previous examples you may be able to throw my way

[June7]

I do something like that by saving data to a temp table. Review http://forums.aspfree.com/microsoft-...ry-322123.html

Yours would be structured like:

Alloy	E1Name	E1Pct	E2Name	E2Pct	E3Name	E3Pct
1	Fe	50	Cr	50
2	Ag	25	Cr	50	Co	25
3
4

How many maximum elements could there possibly be for each alloy?


Another option might be to concatenate the data to a single string for each alloy.
Review http://allenbrowne.com/func-concat.html

[argsemapp]

June7-

GREAT suggestion! this takes care of my main issue which was trying to format my report around my recordset.

I think the 'wost' alloy we have has 9 separate elements. But alloys can have anywhere from 3-9 so you can see my problem of how to format this report..

I think I should be able to set up a blank 2x9 grid made of textboxes in my report, and then loop my (transposed) recordset for each element until it reaches the end.... then would it be possible to somehow get rid of the unwanted blank entries? Is there a setting in Access to SetXthColumnLineThickness = 0?

[June7]

What do you mean by 'get rid of'? The empty fields in table will be blank textboxes on report. I wouldn't bother with trying to adjust the report structure.