I'd like to re-brand (and send error emails) for all of the SSRS default error pages (picture below) when you access reports via /ReportServer/. I'm already handling the ASP OnError event and some of the default SSRS errors appear to catch their own exceptions and then render this page cancel the response all before the OnError event is...
I am having an SQL reporting server reports which has 5 parameters which is nullable values. user may enter values for any of the fields. I need to check the condition that user have to enter atleast any one parameter out of five parameter values(any one is required). **Note: I need to do this in SQL Server reports itself.** Please su...
I found this extremely old document which appears to say that many of the web client features are not availiable when running on express edition--scheduling, subscription, etc--as well as no access to the report builder. Is that information still current, and are there any other features which are unavailable? ...
I am having huge lines data which could accomdate in Textbox. While I am exporting to excel the wrapping up of data occurs and the data is being cut off. When i manually change the textbox height i can see the full data but i need the full data to be displayed in the first time itself. ...
In other words, if I set up SSRS Express edition will I be able to consume and make calls through the webservice? ...
Is it possible to change the connection string of a published sql reporting services report? I can see the binary field called DataSource in the ReportServer database, but since it's stored as binary I don't think it's easily updatable. Do I need to republish the report with the correct data source? I'm hoping not since I do not want to...
In a project we have two build types, one for continuous integration and one that runs our test suite. When the Quality Indicators report is run, it displays data from all builds regardless of build type. The report suggests that one can only run it on a specific build type but the query that populates the builds field only seems to wo...
I have not been able to find a way to export/import subscriptions either in the Report Manager or by SQl Server Management Studio. Anybody know if this is possible? ...
I am looking for a reporting service/tool for visual Studio. My only restraint is my web server is off limits to me as far as installing ANYTHING. So I need something I can just include in my project. My users need to be able to export a report to PDF and without being able to use Crystal I am pretty much lost. Any ideas? ...
I need to know the maximum length of a textbox in ssrs. How much data can it accomodate? ...
In my SQL database, I have a one-to-many relationship, something like this: Teacher Student John Alex John Mike John Sean Bob Jack Gary George Gary Paul I'd like to display a table listing each teacher, with their students as a comma-delimited list, like this: Teacher Students John Alex, Mike, Sean Bo...
Hi, 1) I have a ReportViewer control on a page that's linked to a ServerReport (I'm using ASP.NET 2.0). The report displays fine, but the 'Export' link is present but disabled and the 'Select a format' drop down list (that's normally visible when you view the report in Reporting Services) isn't there. Any ideas? The ShowExportControls p...
The reports I can churn out in SQL Server 2005 Reporting Services using the MS Business Intelligence Development Studio is rather limited for what I want to do. I have had a look at a similiar stackoverflow question and have had a browse through the MSDN website. I have managed to add some additional functionality from examples I've foun...
I am having a problem like that i am having some 10 parameters. I am dispalying the parameter values in the textbox(10 different). I need to display the textbox based on my parameter values If the parameter has values - show them in textbox If the parameter has no values - hide the textbox. Currently I am using this above mentiond meth...
I have some data grouped in a table by a certain criteria, and for each group it is computed an average —well, the real case is a bit more tricky— of the values from each of the detail rows that belong to that group. This average is shown in each group footer rows. Let's see this simple example: What I want now is to show a grand tota...
I have a query that I use for charting in reporting services that looks something like: (SELECT Alpha, Beta, Gamma, Delta, Epsilon, Zeta, Eta, Theta, Iota, Kappa, Lambda, Mu,Nu, Xi from tbl WHERE Alpha in (@Alphas) and Beta in (@Betas) and Gamma in (@Gammas) and Delta in (@Deltas) and Epsilon in (@Epsilons) and Zeta in (@Zetas) ...
Could someone tell me why the SSRS web service ReportService2005.asmx has a recursive parameter on ListChildren while the Sharepoint integrated mode version ReportService2006.asmx does not? ReportService2005: public CatalogItem[] ListChildren ( string Item, bool Recursive ) Ref: http://technet.microsoft.com/en-us/library/repo...
I have a simple SQL Server 2005 Reporting Services report with a bar chart. When I print directly from the preview window in Visual Studio everything looks good, but if I export the report to a PDF file and print it then the labels and even some of the vertical lines come out pixelated. How can I increase the resolution of the PDF export...
Using SSRS2005, can you pull in values specified in the SSRS Web.Config file (think appSettings)? I'm needing to build up a dynamic hyperlink in a series of reports and would like this to be based on a value set in a config file. At present, it seems my only options are to: Update the hardcoded variable in each report that is build...
how to show all values of a particular field in a text box ??? ie. for eg. when u run the SP, u'll be getting 3 rows. and i want to show the (eg.empname) in a textbox each value separated by a comma. (ram, john, sita). ...