none
ssrs 2008/2010 create 2 reports based upon 1 dropdown list box

    Question

  • I need to make a change to an ssrs 2008/2010 report based upon how may days delinquent a particular customer is. The information for each letter (report) is obtained from a string field called strLetter. The string field called strLetter contains the information in html format.

    When the existing ssrs reports are running the users are able to select parameter values to run the report. One of the parameters is to select how may days delinquent a customer is (5 days, 15 days, 20 days, 30 days, and 90 days).

    Right now there are letters for 5 days, 15 days, 20 days, 30 days, and 90 days that go directly to the customer. Now I need to create an additional 20 day letter that goes to my company's attorney. This means that I have 2 letters that need to be generated at the 20 day mark (1 for the customer and 1 for the attorney).

    To solve this situation, I have the following questions:
    1. Is there a way to create the 2 20 day letters by using the existing 20 day drop down list? In other words, in the ssrs report can I create a page break between the 2 20 reports (letters)? Can I have something like:
    strstrLetter value
    page break,
    strLetter value2.
    If so how would I accomplish this goal?
    2. If the above is not a possibility can tell me how you would solve the issue to create 2 reports at the 20 day delinquent mark?



    Sunday, August 03, 2014 6:29 PM

Answers

  • Hi wendy,

    If I understand correctly, you want to create two ‘reports’ with a page break between them based on the current one report. If in this scenario, we can directly use a rectangle contain the current report, copy the rectangle and paste it to the design surface. Then right-click the second rectangle to open the Rectangle Properties dialog box, enable “Add a page break before” button.

    If you want to display the second ‘report’ only when we select ‘20 days’ at the parameter drop-down list, we can use the expression below to control the visibility of the second rectangle:
    =iif(Parameters!strLetter.Value="20days",false,true)

    If there are any misunderstanding, please elaborate the issue for further investigation.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, August 04, 2014 2:54 AM
    Moderator

All replies

  • Hi wendy,

    If I understand correctly, you want to create two ‘reports’ with a page break between them based on the current one report. If in this scenario, we can directly use a rectangle contain the current report, copy the rectangle and paste it to the design surface. Then right-click the second rectangle to open the Rectangle Properties dialog box, enable “Add a page break before” button.

    If you want to display the second ‘report’ only when we select ‘20 days’ at the parameter drop-down list, we can use the expression below to control the visibility of the second rectangle:
    =iif(Parameters!strLetter.Value="20days",false,true)

    If there are any misunderstanding, please elaborate the issue for further investigation.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, August 04, 2014 2:54 AM
    Moderator
  • Right now the report only has an expression it in.  Thus you are saying that I should do the following steps:

    1. Place a rectangle around the existing expression.

    2. Copy that rectangle to another location on the designer surface and call that rectangle2.

    3.  Right click the second rectangle properties and select 'page break before button'.

    Monday, August 04, 2014 3:33 PM
  • Hi wendy,

    Yes. Please note that the rectangle2 should stays under the the rectangle1.

    If there are any other questions, please feel free to ask.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Tuesday, August 05, 2014 1:15 AM
    Moderator