I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
Has anyone successfully implemented forms authentication with SSRS? It seems like a lot of the documentation out there is just wrong or doesn't indicate which version of IIS / SSRS is being used.
View 1 Repliesmy qyery is Select * from UserTable .
i set my parameter as @UserId,checked multivalue check box.
in Available values-from query-i set my value and label field.
default value is null.
when i click the preview tab,multiple UserId with check box appear in drop down list...
when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...
I am desinging the report in ssrs 2005.I used table control to display data.I have three columns col1,col2 and col3.Col2 and col3 are grouped on Col1 where as Col1 is monthend_dateMy result should be like this
View 1 Replieswhat are the things to get noticed before moving reports.? What are the common errors that we come across while moving?
View 4 RepliesI have two parameters :
1. ReportType (with values - Manager, Supervisor, ALL)
2. EnterID (should enter manually)
Normally, the intention of my report is when the user selects ReportType as ALL, they should enter in EnterID as ALL But for some reason, when the user selects ReportType as ALL and he enters the EnterID as value 100 or 200 or some number, the report is showing incorrect results. Now, what I want is When the user selects ReportType as 'ALL' and if he enters anynumber other than ALL, I would like to see a pop up message displaying saying 'Please type ALL'.
I would like to hide a column in matrix using SSRS 2005 but when i use visibility : hidden then it shows white space and if i reduce a width to 0in; but it accepts by default 0.035in something.
i really would like to hide a complete column without any whitespace and all.
i want to write query in run time in SSRS.is it possible??...
View 1 RepliesI have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.
These reports can be called succesfully from both the report manager and my asp.net website.Everything has been working fine.
Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.
The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"
I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.
I need to convert an old html report to SSRS . The current report uses two datasets- one is a parent table that is iterated through to pull a data key; the report then pulls an array based upon the key and displays the associated records. Is there any simple way to do this in SSRS?
View 1 Repliesi would like to hide the % of toggle item when image is + then it sum up the % which is incorrect.
Hence i would like to hide the % column when toggle image is + otherwise show the % column value.
i tried something - IIF(TextBox.ToggleState,false,true) or iif(toggle state = 'Collapsed', Parameter A, Parameter B)) in visibility column with expression but it does not seems to work in SSRS 2005.
I am using SSRS 2005 and want to hide specific set of rowsin a matrix when a texts has been toggled. The visibility functiondoes not working as i wanted because it hide/show either set. What i need is show everything and when a text is click show a specific set.
example:
[code]....
I am missing this DLL reference in c:program filesSQL Server90ToolsBinn. I'm assuming that this is because I didn't install the 2005 client. I installed all of the services for 2005, the database instance, reporting services instance, SSAS and SSIS. I installed the 2008 client though, not the 2005 client, and 2008 database instance.So I assume it's because I didn't install the client, but does something else give me this DLL? Another install or a SDK or something?
View 1 RepliesI have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.
I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.
dont say to use multi select as multi select is used only when we have to multi select from one parameter.
Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.
i need to generate multiple pdf files based on input parameters using ssrs. Suppose there are 1000 branches then it should generate 1000 pdf files one for each branch data. how can i achieve this using Sql Server 2005 and .net framework 1.1 or 3.5.
View 4 RepliesI am new to SQL Server Reporting Services. I am generating Reports VS 2005 Business Intelligence Report Server Project.
Here I got a general QQ when I am generating report.
How can i add custom text if column value is null. I tried to add it by column Expression property.
i,e =IIF(IsNothing(Fields!DOB_YY.Value) , "Null", Fields!DOB_YY.Value)
Here I added custom text as 'NULL'. But its not doing any changes in my pages.
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
I have a working SQL Server 2005 Express on my PC. Now I want to use Business Intelligence Development Studio so that I can create reports using SSRS. But I am not sure what to do. I assume I have to download this module. But the only things I see when I search is the entire SQL Server 2005 Express. I do not want to do this and wipeout my present databases. Can someone list the steps I need to follow to get this working on my PC?
View 2 RepliesI have a web application where users can authenticate using either SiteMinder or Windows domain accounts. This is actually configured as two separate virtual directories within IIS 6. Both applications need to use the same instance of SSRS. Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?
View 2 RepliesI have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.
View 2 RepliesI am doing a SSRS report to generate some kind of print outs.
I need to have different footers inside the whole print out.
e.g. After first several pages I need to use page number as page footer( this can be easily done). but after that i need have footers as Annex A -1, Annex A-2, or Annex B -1 , Annex C - 1, when the page is Annex A, Annex B...etc.
I'm a software manager that want to select a Reporting engine and develop international application , i want to know Dose SSRS support multi-languages environments(Special in Report Builder for end users) or not ?
View 1 RepliesI use SSRS to generate an XML file using XSLT. All is fine, except that the XML file starts with the letters 'EF BB BF' which I need to get rid of. How do I generate an XML file without it?
View 3 RepliesI need a reliable method to switch off users' access to SSRS dynamically. If you care about the reason, users are not allowed to access SSRS from home, but they are allowed access from within the factory walls.
I can generate a token or event when they arrive at work or leave, no problem, such is the sophistication of our security system.
So I can create a little .net app that pokes SSRS in some way and tells SSRS to allow that username to access reports. When the users leaves the premises, the .net app will prod SSRS to deny that username access.
I considered dynamically adding and removing usernames from the authentication section of web.config in the SSRS root dir, as in <deny=usernamelist />. But given the frequency of changes (dozens per hour at peak times), that seems too intrusive, as it probably causes the restart of the app.
I tried adding usernames to the ACL on the SSRS physical directory (Microsoft SQL ServerMSSQL.2Reporting ServicesReportServer) as deny reader, and for a few brief minutes I thought I had arrived at a solution, but for some reason SSRS decided to serve pages to denied users seemingly at random. Must be cached somewhere, although I can't for the life of me figure out why that would be happening seemingly at random.
I rather like the ACL idea from the perspective of ease of control, and if there's a simple thing i have overlooked in the way SSRS interacts with IIS and NTFS permissions, I hope someone can point it out so I can understand why the ACL seems to be mostly ignored.
I have SSRS report and have customized the toolbar with textbox. User can enter the report page number and can press enter so that report will generate with report number. I have made autopostback=true to the textbox and below is my code in textbox_textchanged event
[Code]....
Suppose if I enter 2 in textbox and then press enter,it is not firing and if i press enter second time it is working. From page 2 if i enter 1 in textbox and press enter also it is not working.