Crosstab question

[bdjb]

I have a report, the records shown in the detail section are being limited by the selection formulas, but the crosstab seems to pull in all data, there are records in the crosstab that aren't in the details area. Any ideas of why this might be?

 

[lbass]

I'm going to guess that you have a group selection formula that is limiting the display of records in the detail section. Crosstabs are processed in an earlier phase, so will show all records limited only by the record selection formula, not the group selection formula. If you want help with making them match, please identify the fields you are using for row, column, and summary in the crosstab, and type of summary, and then also show the content of the group selection formula.

-LB

 

[bdjb]

Hi LB,
Yes, you are right, I do have a group selection formuls. I didn't realize the crosstab processed earlier.
Row = Client Name
Column = Office.FirstName
Summary = Count of Entities.EntityID

Group Selction = Maximum ({@Investor_Type}, {Entities.EntityID}) in ["FHLMC"]

Thank you very much

 

[lbass]

Please show the content of the {@investor type} formula. Also, what is the logic for limiting groups to those with a maximum of FHLMC? Please also identify the groups in the main report and say where the crosstab is located.

-LB

 

[bdjb]

Hello,
The {@investor type} formula just identifies a particular field from the DB. We're pulling data based upon a particular investor (FHLMC). Fileds in the main report are the CLient, Office Name, and file numbers that the crosstab should be counting. The crosstab is located in the group footer