| Thread | Last Post | Replies |
|
| return results from stored procedure | 17 Jul 2008 16:59 GMT | 4 |
I have managed to get my Reporting Services 2005 up and running. I have a question though: Instead of defining my dataset as a text query (such as select * from table..) I would like to define it as executing a stored procedure. This stored procedure will be a little bit more ...
|
| Adding a dataset problem | 17 Jul 2008 15:43 GMT | 2 |
Good Morning, I have a very frustrating problem. I have a report that needs two datasets from two different data sources. i have reaports that already have multiple datasources, and eveything is okay. THis report however, when i add the
|
| Export to MSProject | 17 Jul 2008 12:55 GMT | 2 |
Is there a direct way to export a SQL Server report to a Microsoft Project file?
 Signature stullhe104
|
| Background image on more than one page? | 16 Jul 2008 15:37 GMT | 4 |
My background image only prints on the first page of a multi page report. Is that normal? I do have some logic that tells what image to use but even when I took that out and hard coded it to a single image it still did not repeat.
|
| change label, error with asp and network reports | 16 Jul 2008 10:25 GMT | 1 |
I hope someone can help me with three newbie problems . 1) When I have a user editable parameter in my reports, the user can edit the parameter and then hit the "View Report" button to see the report. Is it possible to change the label of the "View Report" button to something ...
|
| snapShot with userID | 16 Jul 2008 05:52 GMT | 2 |
I have a report with parameter that depend on another parameter that take the value of the current user (=User!UserId). The report run fine until I'm trying to make a snapshot of the report. I then get the error:
|
| Report Model with SQL Uniqueidentifier data type - I can't filter on them. | 15 Jul 2008 20:29 GMT | 2 |
I am trying to filter a resultset from a report model that contains columns that have a sql uniqueidentifier data type. When I attempt to use one of these columns in a filte expression I get the following error. I haven't been able to modify the report or model to accept this ...
|
| Show/Hide Tables based on parameters | 15 Jul 2008 19:55 GMT | 4 |
Has anyone created a report that shows/hides tables based on selections from a parameter list? For example, I have a report that has 10 tables, each one summarizing sales and dollars based on various types within an attribute of a product. I want to allow the user to be able to ...
|
| Querying ExecutionLog Table | 15 Jul 2008 19:08 GMT | 1 |
I'm writing a quick and dirty report to give to the powers that be showing just how often - or not - certain reports are run. I'm also going to include some other anecdotal information. One of the things I'd like to include are average times (rendering, data retrieval, etc.). ...
|
| Parameter not being passed to stored procedure | 15 Jul 2008 18:30 GMT | 1 |
eI have created a report that contains several stored procedures and they except a parameter to be passed to it... The parameter name is the same in all the stored procedures. I created a report parameter and named it exactly like the parameter in the stored procedures. I can ...
|
| Invoice / Customer Datasets question | 15 Jul 2008 17:14 GMT | 1 |
I am trying to create an invoice report. Essentially, there are two datasets in use, the invoice set itself, with the main fields such as invoice number, invoice items etc and the dsCustomer which contains the customer addresses. I have the invoice details fine, but I want to be ...
|
| Migrate Reports to new server and new db | 15 Jul 2008 16:06 GMT | 1 |
I've got reporting services reports sitting on SSRS 2000 and report on a (semi-broken) SSRS2005 server. At this point we'd like to just create a new SSRS 2005 server (which uses new DBs) and move the reports from both servers to the new server.
|
| Report databases on existing db server | 15 Jul 2008 14:36 GMT | 4 |
I would like to deploy reporting services to 60 users. We have SQL 2005 Standard Edition I have 1 ad server, 1 IIS server & 1 db server on the dmz. All the apps on the IIS server have the databases on the db server. I
|
| Inserting data from an excel file to SQL Server | 15 Jul 2008 13:29 GMT | 2 |
I have an auto generated excel file(.xlsx) in a particular format . I tried importing the file to the SQL server database using the query below. SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB.
|
| Creating a new filtered dataSet (new tableadapter) from an exisitng tableAdapter in the XSD | 15 Jul 2008 10:10 GMT | 6 |
This is in a web environment and the data that is to be used in a ReportViewer report in local mode. What I am asking is how I can filter the result-set returned from a tableAdapter into a new tableAdapter that I can then use as the
|