Eric Klein
Top achievements
Rank 1
Rank 1
Eric Klein
asked on 27 Apr 2012, 05:41 PM
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
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.
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 eTotalwhat 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.
1 Answer, 1 is accepted
0
Kapil
Top achievements
Rank 1
Rank 1
answered on 10 Aug 2012, 07:14 AM
hi Eric Klein
The duplicates usually appear when you bind the report to a data source and at the same time have another data item (such as Table/List/CrossTab) that is bound to the same data source as well.
You can set data source directly to the report that you use as SubReport, or use the NeedDataSource event handler of the SubReport item to provide data.
hope this helps u,
Cheers,
kapil
The duplicates usually appear when you bind the report to a data source and at the same time have another data item (such as Table/List/CrossTab) that is bound to the same data source as well.
You can set data source directly to the report that you use as SubReport, or use the NeedDataSource event handler of the SubReport item to provide data.
hope this helps u,
Cheers,
kapil