Right now i am using two rdlc file to achieve. except for the field gender and field age , rest are the same. these are the two queries i use. query 1 :select state,gender,count(*) from table query 2 :select state,age,count(*) from table how do i dynamically set the column frm the dataset to achieve in a single rdlc file. do i need ...
hi, i am using SSRS 2008 and currently I am facing wordwrapping issues. In report I am placing a table and some 6 columns. My report size is A4 landscape. When running the report,one of the column has a large value without any spaces,the column was not wrapping up,so I changed the layout to A3 landscape and the wrapping started worki...
Hello, I've a web-site, that use asp.net membership provider. Two days ago I got a task to Integrate with my site SSRS 2008 security. WEB-site is located in http://localhost. In this page I have login page. If user is authenticated, web-site is redirects to main page. Report site generated by SSRS is located in http://localhost/Reports...
Hello, As you may be aware there is a peculiar situation with the display of column headers in SSRS2008... i.e. you need to dig around a bit to get them to repeat on every page. http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx All of the examples I've seen rely on some kind of...
My report server has 2 folders: ProductionReports - about 50 reports AND TestReports - 0 reports I want to copy all the reports from Production to Test. One method is to save each Prodcution .rdl then upload each one to Test and then change its datasource. This will take a long time!!!! Is there a way and can copy them all together and ...
Hi We are facing a strange problem. We have developed a dashboard using Sharepoint 2007, Custom report viewer and SSRS 2008. Due to unknown reason the custom report viewer was not able to show reports from reporting service through default authentication. I mean with the credential of the logged-in user in sharepoint site. So we hard ...
Hi all, I have a stored proc that I use to create some customized lists. I'm trying to create it as an SSRS report, but it's running into a sticking point where it chokes trying to deal with the User Defined Table Type parameters. Am I just screwed? As an aside, it does work when you call it with a sql exec statement. Thanks, ...
Problem: Printing from within BIDS 2008 R2 "Preview" tab hangs and must have the process ended in task manager. Facts I can set the report as StartItem under Debug Configuration Properties for the project and then run, producing the Preview window. And then successfully print. I can deploy the report to the Reporting Services server ...
When I print from report manager in reporting services (2008) the quality of the output is terrible with fonts that look great on screen being very blurry and badly sized. Is there a known issue here? ...
I have reporting services setup and can publish report to it by hitting deploy in Reports Solution. After publishing I can view them through the web server and they work as expected. However if the report contains any row group the deploy times out. The preview function will work correctly, but publishing times out regardless of timeo...
How can I count the number of null values using SSRS? The following expression is not working: = Count(IsNothing(Feilds!.FieldName.Value)) This also isn't working: = Count(Feilds!.FieldName.Value Is Nothing) ...
Good morning fellow stack overflow people, I have a question that sounds like the start of something from the daily wtf. The company that I work for is not so much sacred of new technology they just seem to let things slip, you know the type, “It worked 5/6+ years ago so I don’t see why we should change it” Despite this I have managed ...
I have Fresh Install SSRS 2008 R2 on Win2k8 box ( on which i am administrator). After install, When i run Reports Manager, It gives following error - User 'WIN2008\Tellink' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. ...
When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB is well established. OPTIONAL: In case you want to have a look at my query (its too long), i checked it very well. Nothing wrong in ...
We have an application which is created in asp.net/flex front end, ms sql/ssas as data source. We are in phase of creating a new reporting module. so for consistency of graphs and ui we want to use flex as front end and SSAS as backend for reporting module. My understanding is: *Flex based UI (reports/parameters) SSRS Reports (standa...
Can crystal reports get data from an object data source instead of a database? I am using the crystal reports that comes with vs2008. I am coding in c# 3.5. I would like to use an object data source that returns a List< MyClass>. For when we migrate to ssrs in the future, Can ssrs 2008 get data from this object data source ? ...
Hi, I am new to SSRS. I have Business Intelligence VS 2008. I am trying to add report parameters to the report but the data tab does not seem to be coming up in the designer. My requirement is to pass parameters from the UI to the report in a remote/server mode. I have to just pass the parameters to the report and the report should ren...
Hi, I have created reports with drill thru functionality. I use a blue foreground and bold font to give the user hints as to what they can drill into. I would like to be able to turn off the blue, bold, and even the drill thru action when the report is being printed or exported. I have thought of basing those properties on a hidden/no...
I would like to know in order to use the Report Builder at the user system, What kind of licencing model we require, If we have one SSRS server (SQL Server licence) and all the users can download report builder? What is the licencing model to use the Report Builder? It is SQL 2008 ...
I have a matrix in an SSRS 2008 report. The rows are grouped on the Time field, and the columns are grouped on the FieldName field. Pretty standard stuff, you can see the designer view of it below. This works pretty well, except that in some instances I need to hide the "time" column (highlighted in the image). I've tried setting the...