Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 r2 customer name and number display
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

332 Posts

Posted - 11/04/2013 :  22:19:45  Show Profile  Reply with Quote
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?

Constraint Violating Yak Guru

332 Posts

Posted - 11/05/2013 :  12:31:13  Show Profile  Reply with Quote
problem solved by putting data on detail line
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000