Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Help needed on Report..


Help needed on Report..

Author
Message
s-sql
s-sql
SSC Veteran
SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)SSC Veteran (265 reputation)

Group: General Forum Members
Points: 265 Visits: 422
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...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search