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

Help needed on Report.. Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 10:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 12:33 PM
Points: 171, Visits: 343
I have developed a letter report for customer, which displays data based on a parameter.

Example: When CustomerID = 1
---------------------------------------------------------------------------
Page 1:
<<<<Header Logo>>>>>----This is not placed in the header, as only 1st page needs the image.

CustomerID 1
Customer Name XYZ

Letter content...

Page 2:

Letter content Continued...

------------------------------------------------------------------------------

For a given customer, the letter contecnt always spans across two pages.
The Logo on the header is needed only on the first page, and footer displaying the page x of Y.
Have used a image as header, and the Customer details and letter content, are rendered through a Store Procedure, which takes customer ID as parameter.
For single customer, the report is working as desired.

Have a requirement to handle multiple customers.
The Procedure parameter is modified to accept comma sperated values, and the returning resultset is also grouped by customer ID.
Tablix was used to consume the procedure resultset. CustomerID is added in the Row Groups.
The report displayes the letter content for each customer, but the header logo is not repeated for each customer. Also the page numbers shows the overall page totals instead of grouping by customer ID.
Need the report in the following format.


Example: When CustomerID in (1,2)
--------------------------------------------------------------------------------------------
Page 1:
<<<<Header Logo>>>>>----Only 1st page of the customer letter needs the image.

CustomerID 1
Customer Name XYZ

Letter content...

<<Footer>>Page 1 of 2

Page 2:

Letter content Continued...
<<Footer>>Page 2 of 2

Page 3:

<<<<Header Logo>>>>>

CustomerID 2
Customer Name ABC

Letter content...

<<Footer>>Page 1 of 2

Page 4:

Letter content Continued...

<<Footer>>Page 2 of 2
----------------------------------------------------------------------

Any Help is appreciated...
Post #1436013
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse