Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 r2 display customer name and number Expand / Collapse
Author
Message
Posted Monday, November 4, 2013 8:16 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:17 AM
Points: 362, Visits: 422
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?
Post #1511349
Posted Tuesday, November 5, 2013 6:37 AM


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: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
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?
Post #1511465
Posted Tuesday, November 5, 2013 7:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:17 AM
Points: 362, Visits: 422
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.
Post #1511486
Posted Tuesday, November 5, 2013 8:29 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 4:59 PM
Points: 275, Visits: 1,665
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??
Post #1511507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse