I have problem with the Security for Reporting Services. Actually i want to give this report access to everyone. I want to make it as public site. I want to use Anonymous access but i don't want to use Custom Security Extension. But if i am giving anonymous access then it gives error as "T...more >>

is it posable to pass a parameter to disable the print funciton for a PDF Render? also the same but to set no wrap on an excel render -- Message posted via http://www.sqlmonster.com...more >>

I was asked to design and deliver SQL Reporting Services reports to a customer; just the RDLs and RDSs. The customer will not have Visual Studio ..NET (or any other .NET IDE) loaded on their computer. So, I have a couple of questions: 1. How can I programmatically deploy all the RDLs and RD...more >>

I changed the password for the reporting service account on the AD server, now I can't access my reports. I keep getting logon failed, and every 5 seconds I get logon failures on teh sql server. If I stop the service on the sql server, the errors go away. I changed the password for the serv...more >>

I would like implement a search method to can find parameters. Obviously you can put a combobox but in a case there are a lot is is bad for performance. Anybody know how can introduce a method system. thanks ...more >>

As described in the RS BOL topic, "Creating a Report Using Report = Wizard", I went ahead and edited the "Compact" Style. The results were = great until I set a default TextAlign in the "Table Header" Style = section. I wanted to center all column headings as a default - not = unreasonable. VS...more >>

Hi, I have a long report - using a Table that goes over 100 rows. In order to restrict the numbers of rows per page in the HTML format, I created a "group". And I added the following expression to group on: =Int((RowNumber(Nothing)-1)/35) And added a "page break at end" for that group. ...more >>

I have a series of charts in a report with each chart comparing a particular department's sales for the last 3 months. An example being one chart showing the toy department's sales for Jan, Feb, and March. The next chart shows another departments sales for the same period. Is there a way that ...more >>

I have to compile my rendering application and access reports that are no longer on my local computer, but I can't get the reportpath correct. It used to be: reportpath = "/reportserver/myreports/report1 Now it's on another server and is always invalid when you name the server like: reportpat...more >>

My apologies if this has been asked before... Is there a way to control the 'Z' axis, or depth of a bar in a 3D bar chart? Thanks, Stuart ...more >>

I have a report that takes a single date parameter. My DataSource however, could be either a MSSQL db or a Sybase db. Both of these are included as shared datasources in my project (This is becase some clients of the report may point to the MSSQL db while others will point to the Sybase db). H...more >>

I have a sp that works in query analyser and the sp works for crystal reports, the sp will error out when I tried to create a new Report in Report Services using the same sp. "There is an error in the query. Invalid object name '#mastreportstmptable''." #mastreportstmptable is a temp table...more >>

I'm creating a report with Visual Studio 2003 and the reporting services project. I'd like to group like: 1/04 $20 2/04 $30 Right now I'm getting the grouping: 1/1/04 $10 1/2/04 $10 1/3/04 $10 The data is stored on a daily basis and it needs to be summed by month. Thanks, Ji...more >>

Are there any tools (other than Visual Studio.NET) that will allow me to build SQL Reporting Services Reports? I just want to build some simple reports and don't need (or want) to install the Visual Studio.NET....more >>

Hi, is there any way to get URL for RS from database ReportServer? I looked through tables in this DB but didn't find anything helpful. Thanks. Victor ...more >>

Can I modify the layout of the parameter section of the report?...more >>

When I run a report in Reporting Services on the Report Server on my local PC, I can save the report to Excel as reasonable file sizes eg. 700K. When I deploy the same report's rdl to the live server, run it and then save the same report to my network share, the file size explodes to several me...more >>

I had just sat down with my jamba joose and apparently looked a little too relaxed, as I was immediately called into a meeting. Does anyone know when the chat transcript will be archived? Or, if there is a way to receive notification when it is posted? Thanks ...more >>

Hi, I have images that reside in a database table on SQL server. When previewing a report in Report Designer, the images display just fine. After uploading the report to Report Manager, the images don't display and a red x displays. Another issue is that the graph on the report is not displ...more >>

I have a sp that returns a different dataset depending on the parameter values, it is dyanamic sp which has different field names and also the number of fields. Is there a way to incorporate this in reporting services, like in .Net we can display the dataset by just binding it to the datagrid ...more >>

I have not seen this question pose anywhere. Currently we can only assign 1 group at a time to role(s). Has anyone found a way to assign more than 1 group at a time to role(s)? I have about 70+ groups to assign role(s) to and doing this one by one is just not going to work. I'm using Custom A...more >>

I'm trying to create a report using an OLAP cube as my data source, but I can retrieve only the dimensions and measures, not the calculated members. My query is: select * from MasterCube Is there any way to extract them?...more >>

My biggest problem is the fact that I can not extend the Report Designer wizards, etc, to provide friendly dialogs for editing connection strings and query strings for my custom Data Source. Painful for my customers. Does SP2 help this? Thanks, Steve ...more >>

Hi, I ran into a challenge. When setting up a subscription, we have email address that contain spaces. For instance, John Doe@address.com. When we we up a subscription to send to this address, it states in the status field that the e-mail address of one or more recipients is not valid. Is t...more >>

Hi, I am sending parameters to the report from asp.net. In my aspx pages I have a permission check where I check whether or not the user can access the page: Dim myCurrentUser As PnClassLib.currentUser If IsNothing(Session("currUserObj")) Then Page.Response.Redirect("../AccessDenied.aspx...more >>

My Setup: Win2000 Pro SP4 (updated to the last one) SQL 2000 DeV Sp3a Reporting Service SP1 VS.Net 2003 I've build two reports based on Oracle data. Working locally it's ok (both for debug and production). When i try to acess the same reports from other machine i receive the following e...more >>

All of my reports work fine, while trying to export them to excel. But I'm not able to render one Report to Excel. The Report contains some Lists and the visibility depends on some(9) parameters. The rendering works fine with all other Rendering-Formats. It seems that the Reporting Service (th...more >>

I'm evaluating Reporting Services as a report writer for OLAP-based reports. I understand that I must use an expression to pass parameters to Analysis Services. However, I'm having two major issues with the resultsets. Both have to do with the fact that one of the dimensions in the MDX quer...more >>

While installing MSRS i have taken care of all pre-requisites. I am installing it on Windows 2003 server machine. I want to have the remote sql-server instance for my reporting services. For Sql-server, i have taken 'Mixed mode installation' and given the username & password as 'sa'. As spec...more >>