Need help with formula " whilereadingrecords" 1

[DanijelaS]

Hi,

I need help with formula whilereadingrecords

I want to insert the formula to display information from detail section in the report header. For example, a project number will be displayed at the header. For now I have only showing the first project number as oppose to the list of all projects within the client number selection.

How would I use the "whilereadingrecords" formula to be able to read information from the detail section?

Here is the sample of how the report should look like:
(header Information)
Client ABC
Project 01, 02, 03

(Detail Section)
Associate Hours
Rob 1
Dave 2
Sean 1
Total Project 01 4

Jen 1
Mark 3
Total Project 02 4

Total Client 8


Thank you!

 

[lbass]

You can't use whilereadingrecords to do this. You could insert a crosstab in the group header that uses project # as the row or column field, or you could insert a subreport that collects the projects numbers in a variable placed in the project group section and then displays the result in the sub report footer.

-LB

 

[DanijelaS]

Thank you lbass!

I try using crosstab option and placed project # under column and also had to put something under 'summarized fields' so I used the same project # field. Is there a way to avoid filling summarized field. If not how can I supress the information whithout loosing the column field that displays all project numbers for the client?

Thanks agian!

 

[lbass]

You should be able to right click on the summary->format field->suppress. You can do the same with unwanted labels. Then go to the customize style tab ->format grid and uncheck "show grid lines" or uncheck draw for selected lines. You can also then resize the summary line to minimize the height.

-LB

 

[DanijelaS]

Okay, I'll try to do that to see how it looks like with the crosstab option and if data would be affected since Project # is one of my parameter values.

But also I was able to get the first and last record but nothing in between by using “whileprintingrecords” formula
From the example above I would get Project 01,03 (but nothing in between which would be 02)

The formula would be something like this:

whileprintingrecords;
Totext(minimum {Project.Number}) & ”,” &Totext(maximum {Project.Number})

Do you think it is possible to get the middle section somehow?

Thanks!

 

[lbass]

Cannot be done that way. If the project numbers are being selected by parameter then all you need is a formula like this to place in the header:

join({?ProjNo},", ")

-LB