The Reporting Database in Project Server 2007 has about 7 "User Views" based on Assignment, Resource, Task, and Project. They all have fields for Work, OvertimeWork, ActualWork, MaterialWork, BudgetWork, ActualRegularWork. How do all these fields relate in terms of a formula. I can't find a good resource on it. Thanks for any help. ...
We have various reporting services reports which are scheduled to automatically generate reports and email them to a distribution list. This works really well but they appear to come from [email protected]. This is all well and good but the PHB would like them to look like they are coming from [email protected]. We've got a g...
I've created a model using SQL Server Reporting Services. When I try to create a report using the Report Builder, I can drag an entity to the report, followed by a nested sub-entity. I get the two-level grouping as expected. However, I cannot add a third level entity to the relationship, no matter which combination I try. What can I do...
Is it possible to limit export formats only PDF and Excel ? ...
Two installations of SSRS 2005 on two separate machines in my shop seem to have lost their encryption keys at exactly the same time. These are developer machines with the development edition of SQL Server 2005 running, so I'm hoping that perhaps someone here has an explanation for this. Yesterday, both machines began reporting the erro...
Using SSRS 2008 Express Edition, is it possible to create a datasource that connects to an external SQL server, or is it artificially limited to same SQL Server and instance of that Reporting Services engine? ...
I've inherited a legacy application that is supposed to grab an on the fly pdf from a reporting services server. Everything works fine up until the point where you try to open the pdf being returned and adobe acrobat tells you: Adobe Reader could not open 'thisStoopidReport'.pdf' because it is either not a supported file type or ...
I put a table into my report with labels in the first column and mappings in the second column, but when I click on the preview (in the IDE) the table does not show up. The "Initial Visibility" is set to "Visible". I'm using VS 2005 Team Explorer Edition (Which is open from Sql Server 2005 BI) Here is an sample xml (code), if that m...
I can't create a NT account for everyone that need access to the reports. Does anyone know or have a link to the info to allow anonymous access to reporting services reports ? Thanks ...
I recently switched a report from the usual table view (horizontal) to vertical because I had a ton of columns. The issue now is that when I click to sort nothing happens in the report itself. Does anyone know if it's possible to sort using a layout that is not horizontal? (using the default sort expression) **Currently in the interac...
I would like to use SQL Reporting Services 2008 to generate my reports, but I want to use my own UI for specifying the report type, columns, parameters and everything. I want to be able to take these criteria, and then kick off an asynchronous request to SSRS and have the report emailed to me. Is this possible? I don't want to go all ...
Which one you choose? Use the Deploy feature in VS Build a rss script and execute it through rs.exe Build a deployment package Another option Keep in mind that in many of your environments the report developers/designers don't have publish role in Reporting Server. ...
Hi, A client has installed Sql server 2005 reporting services. When we go to the web bit at http://servername/reports/ we just see a blank screen like: http://img91.imageshack.us/img91/3787/rsblankqx4.jpg We are using windows authentication and I think it has authenticated us as the "site settings" button is appearing and we can alter ...
Hi, I have a SSRS report. When i tried to export to PDF it was taking 4 pages due to its width., where the 2nd and 4th pages were displaying one of my field from the table. So i tried to set the layout size in report properties as width=18in and height =8.5in. It gave me the whole table in a single page of PDF. But I am getting 2nd and ...
We currently send an email notification in plain text or html format. Our environment is C#/.NET/SQL Server. I'd like to know if anyone recommends a particular solution. I see two ways of doing this: dynamically convert current email to pdf using a third party library and sending the pdf as an attachment or use SSRS to allow us...
When I try to create a a new snapshot in SQL Server Reporting Services 2005, i get the message: "report history may not be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, default report parameter values are missing, or if a linked report, the link is no longer vali...
I'm looking for a little help on programmatically passing parameters to a SSRS report via VB.NET and ASP.NET. This seems like it should be a relatively simple thing to do, but I haven't had much luck finding help on this. Does anyone have any suggestions on where to go to get help with this, or perhaps even some sample code? Thanks. ...
I've got a report that works perfectly in development previews. But when I deploy I get the following error: In the Dev Environment the Error displayed is: Error 4 The data source 'myDataSource' cannot be found. c:\reporting services projects\reports\rest_of_path\my_report.rdl 0 0 On the reporting services side the error ...
I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf. Is there any way to protect the report. ...
Is there any chance of installing Reporting Services 2008 against an instance of SQL Server 2000? The docs clearly state that only SQL Server 2005 or 2008 are supported, but I thought I should ask anyway, for ways to bypass this limitation. I should mention that I am not talking about the data source for my reports (which is a remote da...