Does the below expression have any syntax errors? It's giving me an "n" when I am expecting an "o"?? =IIF(TRIM(Fields!ITEMNMBR.Value) = "1000" OR "1003" OR "1006" OR "1009" OR "1012" OR "1015" OR "1018" OR "1024" OR "1027" OR "1021" OR "2311" OR "2316" OR "2319" OR "1030" OR "1033" OR ...more >>

Short version: http://machinename/reports works as does http://machinename/reportserver http://FQDN/reports repeatedly requests authentication and then fails. Longer version: Everything was working perfectly. I attempted to change to Sharepoint integrated mode from native (after giving up o...more >>

Hi - Is it possible to configure an SSRS parameter drop down to act like an Access combo box? The user wants the drop down to auto-complete. Right now, if the user types "P", the drop down goes to the first item that starts with P, but then if he types "C", the drop down goes to the first it...more >>

I'm looking at the Properties tab of a report In the Report Manager. If I go into 'New Role Assignment', I see a 'Group or user name:' textbox. Do I understand this correctly?: Any name I enter for a new role must match an existing SQL Server user or group? (If so I would expect some sor...more >>

I'm pretty much a rookie with this so I'm wondering if someone might be able to point me in the right direction here.. Here's what I'm using now: =MonthName(Month(NOW())-1) & ", " & YEAR(NOW()) which displays 'April, 2007' What I'm trying to do is provide the month,year of the previous m...more >>

I've been experiencing this odd bug. I'm running LocalReports, btw. Anyhow, so a report gets displayed in the viewer and the page navigation will display "1 of 2" and the right arrow is activated so I can navigate to the second page. However, if I click on the "Print Layout" button to see the pr...more >>

Is there a sql equivalent to CASE in srs expressions? I have a field which can return a value of 1-10, and based the the value I want to display some text. I know how to do the case in sql, but would prefer to do it in SRS if possible as I have about 12 fields like this and don't want sql to...more >>

We are attempting to create a report with a dataset that contains an IN List in the where clause (Seel SQL Below). The query runs perfectly in the query design mode. However, trying to preview the report will never return results. During the testing we've found that our "IN" List Where clause wi...more >>

Hello, everyone! Being new to SRS and Sharepoint, I was wondering: Are there any walkthroughs or guides that can show me how to create an SRS Report that displays data from a Sharepoint site? For example, if I have a list on some site, and I want to run a report in SRS to simply display...more >>

Hello, We are having a VB application and we call the reports using URL and passing parameters to render in Excel Format. This opens an IE browser minimised and pop-up with a File Download Dialog box. User would like to avoid this File Download Dialog and always "Open" the Excel file direct...more >>

How do I check for the existence of a specific value in a column in a dataset? For example, I have 'dataset' with 'columnA' and I want to find out if ANY row in that dataset has a 'columnA' of value 'valueA'. Seems simple but I'm having trouble. Thanks. Stephanie...more >>

Hi, I have a DDL Report Parameter tied to a Dataset. When I go to view the Report in RS the Dataset is run to populate the Parameter, but it also seems to run the Dataset when I hit the View Report button. I don't have the Dataset tied to anything except the Report Parameter. Is t...more >>

I just installed SQL Server 2005 and reporting services in my home computer (XP). From a different computer in my basement connected via peer to peer network I am able to connect to SQL Server installed in the computer upstairs byusing a SQL Server login. I have installed only the client comp...more >>

Ok I have a parameter on a report. It list all the Agencys we have. The person who runs the report selects all the agencies they wont on the report. THE PROBLEM::: There are over 400 agencies!!!!!!! This is what I wont to do. I wont to add "ALL*" to the query after it creates the agencie...more >>

Hi, Does any one know if there is a way to set the location of the parameter on stand alone SRS reporting? I have numerous reports with numerous parameters and the parameters are all crunched together when rendered to the screen. At times they are hard to read and use the space provided ineff...more >>

I want to display the example record below in a text box without the hard returns. How can I strip them out so the record displays in one nice line? The hard return shows as a sqaure box in the sql table, however it does not paste into this web form. Imagine a sqaure box at the end of each ...more >>

I'm really stuck and I'm not sure what I'm supposed to do!? I've started receiving the following error in my SBS2003 R2 SP2 server performance report. Source: Report Server Windows Service (MSSQLSERVER) Event ID: 120 Total Occurrences: *2 The report server cannot decrypt the symmetric k...more >>