Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssrs report do page break on between 2 expressions Expand / Collapse
Posted Sunday, August 3, 2014 12:35 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 565, Visits: 702
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?
Post #1599067
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse