Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Display Custom values to group header. Expand / Collapse
Author
Message
Posted Monday, February 4, 2013 10:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 4:28 AM
Points: 21, Visits: 98
Hi All,
Am trying to create a report like. Here i user two groups. On the group2 i given a page break. The problem is suppose i view the second page if the values is under group1 the group1 has to display the G1name-Continued.



Post #1415566
Posted Tuesday, February 5, 2013 12:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 4:28 AM
Points: 21, Visits: 98
This the formula they have written in crystal reports.How to implement this one in SSRS2008R2?

Formula:


Shared StringVar sNewBranch;
StringVar sPrintMe := "yy";

if sNewBranch = {@BName-BID} then
(
sPrintMe := totext({salesrepgensummary.branch_name}) + " - " + totext({salesrepgensummary.branch_code}) & " -continued ";
)
ELSE
(
//sNewBranch:= {@BName-BID};
sPrintMe := totext({salesrepgensummary.branch_name}) + " - " + totext({salesrepgensummary.branch_code});
)
;
Post #1415591
Posted Tuesday, February 5, 2013 12:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 4:28 AM
Points: 21, Visits: 98
This the formula they have written in crystal reports.How to implement this one in SSRS2008R2?

Formula:


Shared StringVar sNewBranch;
StringVar sPrintMe := "yy";

if sNewBranch = {@BName-BID} then
(
sPrintMe := totext({salesrepgensummary.branch_name}) + " - " + totext({salesrepgensummary.branch_code}) & " -continued ";
)
ELSE
(
//sNewBranch:= {@BName-BID};
sPrintMe := totext({salesrepgensummary.branch_name}) + " - " + totext({salesrepgensummary.branch_code});
)
;
Post #1415592
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse