Help needed on Report..

  • 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 NameXYZ

    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 NameXYZ

    Letter content...

    <<Footer>>Page 1 of 2

    Page 2:

    Letter content Continued...

    <<Footer>>Page 2 of 2

    Page 3:

    <<<<Header Logo>>>>>

    CustomerID 2

    Customer NameABC

    Letter content...

    <<Footer>>Page 1 of 2

    Page 4:

    Letter content Continued...

    <<Footer>>Page 2 of 2

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

    Any Help is appreciated...

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply