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 |
|
cincyKid
Starting Member
22 Posts |
 Posted - 2011-03-11 : 09:41:20
|
| I am new to SSRS and although I have some SQL Server knowledge I feel I am missing something basic here. Someone else designed our reports and now I am trying to look into them to change a couple of values. There is one report called: Invoice.rdl and its inside a project called: Timmons Reports.rptprojOn that Invoice.rdl file I want to change the description of one of the fields from "Great Product" to just "Product". i have tried this 3 different ways:1) opened up the Invoice.rdl file as xml and searched changed the value and saved the file2) opened up the Invoice.rdl in design view, right clicked on the cell i wanted to change, clicked Properties and then changed the value, clicked ok and saved the .rdl file3) opened up the project Timmons Reports.rptproj, double clicked on Invoice.rdl and tried to change it both in design view (as mentioned above) and the xml way too.There are many duplicates of this project and file in different folders (backups and copies on different drives) on the server. I have changed it everywhere on every file but when i run the report to generate an invoice it still says "Great Product".So then I started thinking well maybe its getting that value from the database. When the report opens in a web browser the url looks something like: http://sqlserver/ReportServer$TIMMONSTEST/Pages/ReportViewer.aspx?..... (and some other parameters that follow)So I open up SQL Server Management Studio, choose sqlserver/TIMMONSTEST and connect. Then i click on Databases and I see ReportServer$TIMMONSTEST but when i open up the tables i dont see anything besides system tables. Am i just missing it in one of the tables or do these values not come from any database?Thats kind of where I am. Just want to change the value of one of the cells in one of the reports.Help?thanks! |
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2011-03-17 : 10:55:31
|
| might be a cache issue - in IE, or whatever browser you use, clear the browser cache properly and re try it |
 |
|
|
cincyKid
Starting Member
22 Posts |
Posted - 2011-03-17 : 12:28:53
|
| Cleared cache, still nothing. Are you telling me that one of the 3 ways I tried changing it should work? If so, which method? I still think I am missing something here...thanks! |
|
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2011-03-17 : 12:36:15
|
| I would use 2) |
|
|
|
cincyKid
Starting Member
22 Posts |
Posted - 2011-03-17 : 13:03:52
|
| so just to confirm, there is no database value i need to change? Because I make the change in the .rdl file, and still nothing changes on the invoice. When i reopen the .rdl file, it shows the change I made so it saved it, but does not reflect on the invoice. |
|
|
|
kevindockerty
Starting Member
27 Posts |
Posted - 2011-03-18 : 05:49:32
|
| The report will be pulling data from somewhere - probably a database - perhaps this is what you need to look at.This wont be the same database as Reporting Services itself (ie TIMMONSTEST in your case) To find out where the data is coming from, open the report rdl in designer and look at the "data source" within the report - it will prbably be a table, a view or more likely a strored procedure. Have a look and see what you find.You can then try running the stored procedure or whatever on its own to see the reults. |
|
|
|
cincyKid
Starting Member
22 Posts |
Posted - 2011-03-18 : 09:48:19
|
| Thanks for the reply Kevin. I opened the report rdl in designer and the shared data source is a stored procedure (sp_addb.rds). I have looked everywhere and cant find this stored procedure in a database. If I open the .rds file in notepad it just shows me things like DatasourceID and Connections String, etc. But I cant find the table or database to change this value. |
|
|
|
cincyKid
Starting Member
22 Posts |
Posted - 2011-03-21 : 13:35:50
|
| still cant find this. I have looked in every table of every database (or so it seems) and cant find these values anywhere. Something weird is in the report designer it shows something like this for all the values:=Fields!DateOfSale.ValueBut in the field I'm trying to change it just says "Great Product" - almost like its hard coded. But again, I changed the value and saved it but it does not reflect my change in the report..any other ideas? |
|
|
|
|
|
|
|
|
Reporting Service Noob Question