Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-04 : 22:19:45
|
| 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: CustomertestnameCustomer Number: 78789detail 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? |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-05 : 12:31:13
|
| problem solved by putting data on detail line |
 |
|
|
|
|
|
ssrs 2008 r2 customer name and number display