ssrs determine maximum parameter value

Question

ssrs determine maximum parameter value

wendy elizabeth

SSCoach

Points: 16915
More actions
January 27, 2016 at 3:54 pm

#324274

In a ssrs 2008 report, I am adding a parameter for selecting a report by using an integer value. Each report will have an integer value between 1 and 27. The default is to select all reports, however there will be up to 27 reports that the user can select from.
I would like a way to be able to determine what the maximum report number is so that I can determine how to set page breaks.
Thus is there a way in an ssrs 2008 report to determine what the maximum report number that is selected by a user? if so, can you show me the code and or point me to a url (link) that will tell me how to accomplish this goal?

Viewing 7 posts - 1 through 6 (of 6 total)

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

pietlinden SSC Guru Points: 63428 More actions · Answer 1

If I have a multi-value parameter @OrderID, I can get the number of items selected using [@OrderID.Count]. Is that what you were looking for?

wendy elizabeth SSCoach Points: 16915 More actions · Answer 2

That is close to what I want. The problem is, how about if the user only selects one report and that is report #5. How would I obtain the value of 5 in this case?

pietlinden SSC Guru Points: 63428 More actions · Answer 3

The first item selected would be Parameter(0). So the number would be (ListIndex-1)

wendy elizabeth SSCoach Points: 16915 More actions · Answer 4

What I basically want to do is apply the logic in an ssrs 2008 report. I basically have 27 tablixes embedded in one main tablix. Each report that is displayed will be selected by row visibility level on the main tablix. Each embedded tablix has the page break after set.

What I want to see is not have a page break after the final report is generated. Thus I am thinking I could use some conditional page break logic. Basically once the maximum report number is selected, the last page break will not display.

Thus would you tell me how to accomplish this goal?

pietlinden SSC Guru Points: 63428 More actions · Answer 5

maybe like this?

http://stackoverflow.com/questions/15513313/conditional-page-breaks-at-group-level-in-ssrs2008-r2-reports

wendy elizabeth SSCoach Points: 16915 More actions · Answer 6

This is a very good suggestion! However, I do not have a group level to break on. All the selected reports are for one particular customer. In the page break disable property I think I would like to setup logic that looks like:

=IIf(Parameters!reportVisibile.Value = Parameters!reportVisibile.Value(ListIndex-1), false,true). The problem is the ssrs does not recognize ListIndex-1. Thus can you tell me something else I could try.