I have a report that I am trying to create a cross tab for.
I can get it to creat the report fine but for some reasons the pages will repeat for the toalt number of records I have.
So when I print a report for 65 records it formats and creats the record and the first page is correct, but it creates 65 pagas all of them exaclty the same. What am I missing?
my seltect is as follows
SELECT m.FGID, GroupName, CategoryDescription, GroupDescription, TickerAbv, SecurityMasterDescription, SUM(MarketValue) AS Total, e.FamilyMemberName , percentage, (SUM(MarketValue) * percentage) AS eTotal
what I would like is to group on CategoryDescription and GroupDescription
then display SecutirityMasterDescription and Total
then pivot so the FamilyMemberName becomes the dynamic headers with the eTotal as the detail under the FamilyMemberName
The report formats to this design, but it displays it 65 times.
Also one other issue, there are time where there are no matching FamilyMembers so iti si getting a null value and printing an empty column, is their a way to suppres the blank column.