November 4, 2013 at 8:16 pm
In an existing SSRS 2008 r2 report, I have a database column that originally contained two values. The two values are customer name and customer number. We the have changed the database where the customer name and customer number are in two different database columns.
Now the user wants the SSRS 2009 R2 report to look like the following:
Customer Name: Customertestname
Customer Number: 78789
detail line product # ordered quantity ordered product price
567 2 $5.99
879zl 1 $879.19
The customer name is a paramter value that the user selects. However I do not want the user to have to select the Customer Number. The customer number and customer name are in the same table called 'Clients'. The customer name and customer number are not values that appear on the detail line. Thus if the Customer Name is selected by the user as a parameter value, how can I have the customer number appear on the next line?
November 5, 2013 at 6:37 am
Elizabeth,
When you say "appear on the next line", are you referring to the next parameter, or is the customer number going to be in the header along with the name?
November 5, 2013 at 7:27 am
The values will not be in the page header. The values will be at a grouping level.
The customer name will appear on one line and the customer number will appear on
a separate line.
November 5, 2013 at 8:29 am
wendy elizabeth (11/5/2013)
The values will not be in the page header. The values will be at a grouping level.The customer name will appear on one line and the customer number will appear on
a separate line.
You have just answered your own question! Where are you stuck??
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply