Subreports/Groups

[roboninja]

I have a DB with the follwoing structure:
valLow
valHigh
valAvg
SectionName
ID
ID and SectionName are a compound primary key. I need to show the 3 values for each section separately, for the ID selected when the user opens the report (from a pick list). Any info on this would be greatly appreciated.
Thanks.

 

[MalcolmW]

Your report consists of one record, or more than one record?
How are the records sorted/grouped?
The ID values would not be dynamic (only current as of the date the pick list was created). Is that a problem? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?

 

[roboninja]

The report will only be for one record (or ID). I realize that the pick list is static, and that should be fine. Hope that helps.

 

[MalcolmW]

valLow
valHigh
valAvg
I presume these are the 3 values you need to show seperately for a single record in the report.
What do you mean by seperate? On different pages, lines, columns, etc ? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?

 

[roboninja]

Separately by SectionName Ex:
Taxes Sales
--------------------------
valLow valLow
valHigh valHigh
valAvg valAvg

Section Names are stored in the DB

 

[MalcolmW]

Taxes and Sales examples of two Section Names?
Would the following be for one ID?

Taxes Sales
--------------------------
valLow valLow
valHigh valHigh
valAvg valAvg

Would it work if the section names values were not dynamic?
If yes to all the above, then it is mainly a grouping issue with some special formulas (simulating a cross tab report), and I can help with that.

Malcolm
wynden@telus.net

 

[roboninja]

That is for one ID, and the Section Names are not dynamic (there are only 4 possibilities, set via a separate front end). I will need to show all the values for each of the 4 sections, for a specific ID (along with info from other tables).

 

[MalcolmW]

Robo,
Group by ID, Section Name.
Suppress Section Name sections.
Create 4 detail sections, each three lines high. Format the first three of these to Underlay Following Sections.
In the ID Group header, put the Section names as four column headers.
In the first detail section, under the Taxes column, put in the three lines
{valLow}
{valHigh}
{valAvg}
format the section to Suppress using the formula {SectionName} <> 'Taxes'
In the second detail section, under the Sales column, well, you get the idea. Repeat for all of your columns. That should get you started...
Malcolm
wynden@telus.net