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?