I want to connect to a SQL Server Reporting Services Report Server from SQL Server Management Studio Express. Unfortunately there is no "Report Server" option in the "Server Type" drop down. Am I missing something here? ...
So I have been making some reports and using displaytag to output these reports in html, csv, excel, pdf, etc. They are paginated, and take a simple object graph... and output excellent results everytime, with very little code. However, I need to use displaytag or its equivalent outside of a jsp. So that a user can schedule a report...
I got a complex report using reporting service, the report connect to a SQl 2005 database, and calling a number of store procedure and functions. it works ok initially, but after a few months(data grows), it run into timeout error. I created a few indexes to improve the performance, but the strange thing it that it works after the inde...
I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I found on the net a patch for it, but it doesn't work (link to patch) "The upgrade patch cannot be installed by the Windows I...
I'm using SSRS to generate reports in my app. My app calls the web service behind the scenes. In some cases I render the report using the ReportViewer web control, in other cases (if user is using Webkit based browser for example), I just allow them to download a pdf of the report. I set the report parameters programatically. How ca...
In a SQL 2005 Report Server Project, how do you put an HTML entity (such as & or ) in the value of a column's header Textbox? ...
In SSRS 2008 I would like to create a relative path URL. Long story short I have a subscription that outputs a few thousand static HTML pages to a folder that is used as content for a website. In the past I have created full URLs to other pages on the site (sub-reports, really) using Text Box Properties -> Action -> Go to URL. I would...
Hi, Is there a way to configure the Report Server to Archive the reports to the Report Server or to a path on the File System. I need to save the reports generated as .pdf files. TIA. ...
Hello, I just watched a video regarding the Report Designer. It said to go to Start, Programs, Microsoft SQL Server 2008, Reporting Services, and then select the Report Designer. I'm certain I installed everything, but I do not have this program. I have VS2008 Professional Version installed and SQL Server 2008. I can open a Report P...
I've got a bunch of reports deployed as RDL's to a SSRS. Because of high security requirements, the db passwords change very frequently. It's become a huge task to keep up with the changes and having to modify dozens upon dozens of reports. This leads to my question... Is it possible to programmatically set a data source or a connection...
I have an SSRS 2005 report that has two sections. The first few pages have various data elements and should have one item in the page header. The remaining pages of the report consist of a single list control, and those pages should have a different item in the page header. I'm thinking of putting both items in the page header and hiding...
I have successfully implemented Forms Authentication in SSRS, so it now uses both Roles and Users from my website, using the ordinary asp.net membership framework. I can log in to the portal and run any report, as long as I have the correct role from my original app. All good. However, if I create a subscription, then, when the subscri...
Is there a way to change the default scroll bar colors in code? My failed attempt is of no use. This is using VB.Net in webform. .ReportRender { background-color:#eaf3ff; SCROLLBAR-FACE-COLOR: white; SCROLLBAR-HIGHLIGHT-COLOR: #d6e8ff; SCROLLBAR-SHADOW-COLOR: #d6e8ff; SCROLLBAR-3DLIGHT-COLOR: #6699cc; ...
How would I set one BackgroundColor = to another Textboxes BackgroundColor property. ...
I have a scenario where an asp.net page is using the SSRS reportviewer control to display a report. we recently updated the IIS server to use an SSL certificate and now the same application has a HTTPS URL. Is it now, necessary to setup SSL certificate on the SSRS Report Server box as well? Or, can the (HTTPS)web application continue ...
I have my data set column1 column2 column3 column4 column5 data1 data1 data1 data1 data1 data2 data2 data2 data2 data2 data3 data3 data3 data3 data3 data4 data4 data4 data4 data4 sum sum sum sum sum I have those sums of those columns but I want to show the data 4 in the det...
hi i have Requirment where. i create report in microsoftReportViewer. like i have one report if i click on any row of that report it should show me the next report. corresponding report to that the row i have clicked (know as rill down report). there is one more Issue here: if i try to import the ...
I am trying to allow my custom assembly to utilize the Report Server's web.config file during report rendering. Currently, the custom assembly code can access the ConnectionStrings and AppSettings from the web.config, but when I try to access customer config setting via System.Configuration.ConfigurationManager.GetSection("") I get a typ...
I have a problem with my matrix not rendering properly in HTML. It's a minor issue but annoying nonetheless. The problem is that the right borders disappear on the rightmost column. It only happens on cells with data in them. Like so: Does anyone else experience this? Workarounds? Fixes? Does SSRS 2008 have the same issue? ...
Can we improve the performance of the report viewer. Instead of bringing the whole dataset, can we bring only the page? ...