Hi,
I have a report in one folder in Report Manager. Let's call that the 'base' report. I've created a linked report with that 'base' report to another folder. When I go into Visual Studio BIDS, change the report and deploy it to Report Manager, only the base report changes. The linked report does not change.
Is this by design? I thought linking reports gave you the ability to have a base report and numerous other linked reports, all of which would also change if you changed and redeployed the base report. Is that not the case?
Perhaps i'm missing something but when i update the master report and then go and run the linked report, it's not updating? Is this a known issue?
If i update the master and re-link the linked report, then all is well? Shouldn't the linked report reflect the master report in real-time and i shouldn't have to re-link the report?
I created a base report that covers most of my reporting requirements. I created linked reports using different parameters. Is there a way to transfer linked reports from my development report server to the production report server?
I would have used report models but my system architecture uses a different database for every customer. I use a custom connection expression to determine the database by User ID.
Having just discovered that linked reports do not retain any print formating applied to the original report I thought I'd check out the forum and see if it was just me having a senile moment or if Microsoft had in fact dropped a clanger of massive proportion.
After reading one or two questions from other RS users it does seem as if Microsoft have stuck again and completely diminished a useful feature by stripping it of anything, well....... useful. Well done MS, you once again have my applause for mind-boggling ineptitude of what should be impossible magnitude. Ah, you've got to laugh.
Maybe this and other bugs with RS2005 will be ironed out in Microsoft Reporting Services 2008 - The Search for More Money.
we have a problem with linked reports. We are using the same reports that are run on about 70 different Oracle schemas. The credential information is passed when calling the report. This works fine for reports and reports with subreports. But when linking to another reports, the credential information is lost.
Is the a possibuility to pass the datasource credential information to a linked report?
I have several reports that are set to landscape but then lose this layout when a linked report is created from the original report. I found the link below describing Brian Welcker's workaround and my question is where do you place the vb.net code he provided?
i have allready install mssql2005 Dev version on WinXP in one machine
then try to connect . in browser http://localgost/reports
as a result error Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
if try connect from MS managment studio
also have a error
why it can happent ?
when i try to configure :
go to reportin services config manager I see that "web service identity is not configured ",
go to web service identity
ASPNET Service account : = ASPNET
click APPLY
as a result such error :
ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domainalias.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
I have created a "read only" login on the SQL 2005 database server with rights to the public role with grant connection rights. When I use the "read only" username in Crystal Reports, the database does not show in the dropdown box. When I give "read only" sysadmin rights, all databases appear. I do not want "read only" to have sysadmin rights, is there another way around this that would truly give "read only" read-only rights?
I need to move few folders from our DEV SSRS 2005 environment to another server. Folders will be moved to new parent folders. Is there any tool that I can use fot this purpose? I used RSScripter from SQLdbatips.com. Although the tool works great but it can't script multiple folder reports. I have to script one by one and it is a big problem.
I am trying to access some SQL 2005 reports externally from the network, however when i try to open the reports i get the following error -
· "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure."
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B. Can you show me guidance on where to start please?
I had a report (.rdl) using sql reporting services in sql server 2005, where it was running quite good. I have just installed sql server 2005 sp2. After that, when I run the report through report viewer, the result of the report contains the first record of the dataset keep on repeating for all other records. If I run the dataset the results are correct,but if I preview it, then the first record alone repeating for all other records.
I feel that sp2 might cause this rendering problem. Any suggestion please?
We have sql 2005 setup pulling sharepoint list data and we have created a report from this data. We can view this report through sharepoint internally however when we try to view the report externally we cant view it?
I had a report that exported to PDF just fine before installing SP2 and now it is completely messed up. The report consists of a table that has two header rows (the report is basically a calendar). First Header Row is Month - merged across all 7 columns, Second header row is day of week. The next row is a row containing the date and finally the last row contains the actual data that is populated into each day. It is a sub-report in each cell of the row. It used to export fine but after applying SP2 it exports to pdf like this:
1st page is the first header row (Month) - Nothing else on the page
2nd page is the 2nd header row (Day of Week) - Nothing else on this page.
3rd page is the 1st row of actual dates - Nothing else on the page.
4th page is the data that goes to that 1st row of dates on the 3rd page, this page all all following pages are fine and show the row with the date directly above the data row with no page breaks in-between. There is nothing in any of the controls forcing a page break (remember, it worked fine up until SP2 was applied).
What did the SP break? I am unable to modify my report now so that it exports to PDF correctly. What the heck???
This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.
I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"
When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.
I had developed my reports using SQL 2005 reporting service. While crerating the report i set the page size to 8.27in Width x 11.69in Height. I am calling this report in my aspx pages using report viewer.
But the problem is I can't able to set the size of the page to A4 size. When i set the size of the page to A4 while printing the page is divided into two pages.
Is there any way to override the print option in reportviewer where we can set the page size to A4 ?
Hi all, Could some one help me with the below issue:
I have set up our webserver along with the database in one machine, (machine1) and the SQL 2005 Reporting server in another (machine2). When a page hosted in machine1 is accessed:
1. The page uses a reportviewer control to fetch and show the report. 2. The reports are fetched from machine2. 3. machine2 inturn fetches the data from DB setup in machine1, populates the report and sends it back to the report viewer in machine1.
The problem I am facing is that whenever a report related page is accessed from machine1 it comes up with the below error:
"The permissions granted to user 'machine1IUSR_machine1' are insufficient for performing this operation. (rsAccessDenied)
We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.
After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)
We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.
When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.
aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased). aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0) aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()
I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition. Any recommendations will be appreciated.
Recently my boss decide migrate reports in Oracle Discoverer to SqlServer 2005 using Reporting Services..because SqlServer is less expensive than Oracle. .. Well I don't know exactly How do I began? because it's new for me. Any has experienced? Can you give any recomendations to migration?
I have visual studio 2008 on my vista ultimate machine. I also have sql express edition, however I have no installed it I was thinking of installing sql standard edition because I really am interested in development of ssrs, crystal reports in a commercial development. Is it best to have both sql express and the standard edition I am excited about sql 2008. What is the best configuaration for an aspiring small comercial developer like myself. I am looking for input. Thanks
