I want a parameter to load available values from a query (or whatever) and "allow multiple values." When I do so the list begins with "Select All." That's great, but there appears to be no way to default the parameter to "Select All" which is not acceptable in my case. This particular report will have 8 optional parameters and if htey ...
Hi guys, Whenever i try to access SSRS 2008 R2 through a URL i.e after being published on the net it always shows a login prompt when accessing the report. The problem does not appear on the developement enviroment. how do i prevent this login prompt from showing whenever i try to access a report. at present we are solving this proble...
Hi! Is Recoursive column grouping possible for tablix in RS2008? If yes, please provided related link ...
Hello, When I write report for SQL Reporting Services I put SQL-script inside my report (rdl). When I run this script in SQL Management Studio it takes about 1 second, but report are generated very long time (Sometimes report throws exception about timeout). Should I write stored procedure and use it in report? Will it be faster? And...
I have a dataset returned as below: Province City ItemID Sales BC Vancouver 1111 100 BC Victoria 1111 100 BC Vancouver 2222 100 ON Toronto 1111 200 ON Ottawa 1111 100 ON Toronto 2222 200 ON Ottawa 2222 300 Bunisee requires the report to show sales for each item grouping by province and then ...
I have the header in my report on SSRS frozen so it scrolls down as I scroll down the page. Is it possible to keep this header frozen when I export the report to excel so it will do the same in excel? ...
Hey database gurus. Using visual studio BI dev studio 2008. I have a chart that has a Y axis of numbers ranging from 0 to about 1500 (Values), an x axis of dates (Category Group). The Y-axis numbers are integers representing minutes. I want to convert the Y-Axis of minutes to hh:mm form and I thought it would be simple to write a cu...
Not that it's a prerequisite for commenting here, but I'd like to pick the brain of someone that's taken their Reporting Services platform from 2000 to 2008 (skipping right over 2005). The architecture between 2000 and 2005 (so thus between 2000 and 2008 also) changed significantly it seems, so I'd like to know what needs to be done (be...
Hello All, I have an SSRS 2005 report which I'd like to use a webservice to retrieve some data. This webservice will take in several parameters. As a test I set up a very simple demo webservice project on my local environment: [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]...
Hi, I am installing SSRS 2008 currently and am trying to ensure that all reports are delivered encrypted, via the certificate we have on the server. I have the default config for SSRS after installation and have added the certificate to Report Server and Report Manager. I can now access https://server/reportserver_instance and https://se...
The FourSquare iPhone app seems to be doing it already: http://screencast.com/t/NjRkNmIwNWQ How is this achieved? This SO question pointed out CrashReporter.framework, but isn't this the kind of 3rd party framework Apple doesn't allow in the App Store? ...
I have an application that makes use of Report Viewer and Report (.rdlc) files. Does this mean that I need to have "Reporting Services" installed on my SQL server?? Also would not having "SQL Server Analysis services" affect me any way I want to make sure I keep using - SQL Server Profiler - SQL Server Agent - create and run manageme...
When a report is renderes from report server and user saves it in excel version. When user opens the report hyperlinks or drill down in the report is available in excel and if user clicks on it ; it opens that in web browser. How to restrict hyperlinks while Exporting to Excel from report Server. ...
We're using a SSRS report with URL links that's being displayed in our web application. When we click on a link in the report, it should take you to a page within the web app. However, when we click on the link (link created using SSRS Action property), it appears to be clearing out the session variables. The web app gives the error t...
I need to set up this question a moment. Let's say you've created a database called ParameterTesting and created a table and populated it like so: IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'StarWars' AND TABLE_SCHEMA = 'dbo') BEGIN DROP TABLE dbo.StarWars PRINT 'Dropped Star...
I need to create a report that allows the user to give date and time range to report. I can set up the startdate and enddate but I can't seem to figure out how to add starttime and endtime. This is a report where they want to view what was processed between a certain date and time. ...
We have an application that will host about 13 reports. A reporting services server is not available. The plan is to generate rdlc's and use a ASP.NET report viewer control to display them. After googling a little bit looks like the solution is to have a page for each report with its own report viewer control. I was wondering if it is po...
can i run my reports developed in using ssrs 2008 on ssrs 2000 ...
Hi, Does anyone know the least windows account previlege to run under "credentials stored securely in the report server" option in the report manager? I have tried to create a windows account with admin right and assign to "credentials stored securely in the report server" option but didn't work. However I enter administrator account, ...
I have data that will be generated by users at runtime by performing queries. The shape of the data is unknown because users can choose which fields to bring back. The application is an ASP.NET MVC web app. The data will be .NET POCOs. However, each object could have properties that are collections of other objects. I want to use the R...