I want to hide Duplicates in The Document Map in SQL Server 2000 Reporting Services. I had group in document map like - A abc - A pqr - A lmn + B + B + B + B + B + C + C .... but I want it to be + A + B + C ...more >>

Hey there, I've been banging my head against this for several hours. I have an (admittedly) huge query that works just great in Query Analyzer. I copy and paste the query into Reporting Services, hit the !, enter the parameters, and I get zero results. In query analyzer, I get 46. I have c...more >>

I cannot get RS to install on Vista. I have a clean install of Vista with IIS 7 installed. I was not getting the option to install SSRS when I first installed Sql Server. I installed SP2 and still cannot get the SSRS option to show up. How do I get SSRS installed? Thanks in advance. Jim...more >>

Hello: I'm receiving the following error while trying to open an Oracle connection from a custom assembly; it seems that ASP.NET has insufficient permissions. OracleConnection oc = null; // v----------------------- creating connection object, this is where the exception...more >>

I have a report that we give to our Doctors to fill out that has patient information on it. One of the things we are supposed to have on the report is a checkbox for symptoms found. I would like it if I could get a check box to align with its associated text. If you have over 3 rows of this...more >>

Hi, I need to move the both Reporting Service Databases "ReportServer" and "ReportServerTempDB" to another SQL Server, only the both DB are moved, the Server with installed RServices remains the same. Is there some dokument about? Thnaks ...more >>

I'm trying to delete reports using Report Manager from the folder level by checking multiple files and hitting the delete button. It use to work but after SP2, the script behind the button no longer works. Is anyone experiencing the same issue? Thanks, T ...more >>

I'm trying to delete reports using Report Manager from the folder level by checking multiple files and hitting the delete button. It use to work but after SP2, the script behind the button no longer works. Is anyone experiencing the same issue? Thanks, T ...more >>

The Report Builder works fine for me in IE of course, but I get this error in Firefox: "Could not find file 'C:\Documents and Settings\Greg\Desktop \ReportBuilder.exe.manifest'." Mind you, Firefox asks me to save the file instead of opening it directly as IE does. Thanks in advance, Greg ...more >>

Is there any way that I can handle events using a custom library in the Report Builder? For example, I have written my stored procs to specifically handle the "All" case of multi-select parameters without the necessity of a huge comma-separated list. I'd like to post-process the parameters bef...more >>

I know there have been a bunch of posts re: setting a param to 'All'. I have done this successfully when using a query param but an using a non-queried list for this project and the methods I've used in the past such as " (cy.Division IN (@Div) OR '(All)' in(@Div)) " in the dataset do not work. ...more >>

I created a report model that has two entities. Both entities, in the SQL terminology, can have an inner join. Now the two tables do not have any foreign key relationship or anything. .. Now when i open the report builder and select a field from one of the entity the other one just dissapea...more >>

Since the Select all feature was removed from drop downs I have created my own value to represent that and union it to the dataset for one of my parameters. I'm trying to make that the default value, but it won't let me reference the top of the dataset because the parameter uses the same d...more >>

I have been told that you can create a Report Model from an Analysis Services Cube in the Model Designer even though the documentation says you can not. I can import the Analysis Project that contains the cube into BI Development Studio but I can not create a model from that project. Does an...more >>

Using SQLRS 2005 No matter how I format the percentage (using FormatPercent or "P" format option, my text box in a table control rounds the percentage to a whole percentage with zeroes in the decimal columns. I don't want it to round off at all. Any pointers? -- John Shahan...more >>

Hi: I need to execute a query from a custom code for filtering purposes, but = I want to use one of the datasets defined on the server. I've found how = to get connection string, the database type and the userId, but still = can't find the password (see the code below). Also, I don't like the ...more >>

I have many reports that are compiled as embedded resources in my ClickOnce application. All of the reports work on my dev computer when run from Visual Studio or when installed via ClickOnce on my dev computer. On client computers, the reports with sub-reports fail. The following error mes...more >>

I am writing a .NET app, I'd like the user to have access to the report builder to make ad-hoc reports, how would I go about doing this from inside my application? thanks! ...more >>

Ok this is a big snag... in crystal reports you can translate RTF and HTML fields into your report... so we had a very large table with values stored as HTML in a single field... its not full html, just formatting markup like <p> <b> etc... in crystal it would preserve these formatting, in rep...more >>

Hi, I have a report..and I am using the Globals!ExecutionTime to show the print time. Is there a way to have the user's loca time zone printed instead of the GMT? thanks, Matthias ...more >>

My company uses SQL 2005 Reporting Services and we have written several reports for clients to use in the software that we sell. We have a client that still uses SQL 2000 Reporting Services. Does anyone know whether 2005 reports will be compatible in SQL 2000 Reporting Services? Any help i...more >>

Hi, Is there going to be a SQL RS 2000 Service pack 3? If so, when? and also, is it going to have the ability to reset a page number at the beginning of a new group? Cheers ...more >>

Hi All, I am using Reporting Services 2005 and designing my reports using Visual Studio 2005. My reports look perfect when previewed on my local machine but when I deploy reports to the server and view them in the same web browser the location of report items such as textbox fields and tabl...more >>

we are not able to install SQL reporting services 2000 on .net framework 2.0.0. it is showing some worning of lower version of .net 1.1.4322 fremwork. please suggest.. or give us exact installation process ...more >>

Is it possible to change the background color for a tablerow if you click on a field, so that it is easier to see the data when there are many columns. I tried this on the visibilty button on a field but it says tablerow2 is not declared =TableRow2.BackgroundColor.Value = "Silver"; ...more >>

If I'm building a Report Services solution that every night sends out email to 50 email adresses, am I then correct in asuming that I only need one (1) user license for the Reporting Server, as the 50 email recipients simply get an email, and do not access the reporting server as such? Than...more >>

We developed all our reports (a bunch of them) using our development server named "development" which is not a local server... meaning we cant set our connection string to localhost when we make them... but then we need to deploy them to our Live server which then can be localhost as they will...more >>

How can I call a web service and/or an external program (not a referenced assembly) from inside of Report Services 2005? Can I do both? Thank you for your help. ...more >>

I am having the exact same problem... I'm using the latest service packs. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

There are many business users in my office who would like an AD HOC reporting system. I am not in a position to install the reporting server right now suite and check it out myself. I have seen some presentations and i like the tool for the most part ...I have some questions if anyone can help...more >>

Hi Folks, I am having difficulty using expression based connection strings. I have followed the instructions in this posting http://blogs.msdn.com/bimusings/archive/2006/07/20/673051.aspx , and as far as I can tell, I have everything set up correctly, but when I put in the ServerName ...more >>

Is it possible to only allow someone to search for values from a specific column in a published report? ...more >>

Hi all, I'm a new guy trying to tutor myself on MRS and I'm using SQL05DEV on my desktop. I managed to finally get connected to the sample AdventureWorks db that the built in tutorial uses. When I run this query: SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastNam...more >>

When I run reports from the ReportManager, the parameter list and the reporting toolbar seem to be missing the css style, and I get the error: "unable to connect to the remote server The attempted operation is not supported for the type of object referenced". I can successfully execute ...more >>

I'm Brazilian and my English is not very good, but I need you help. Can Someone help me in the following questions? 1. How to justify the text of a textbox? 2. How put some words inside the textbox in boldface?(When I landmark, all the TextBox is in boldface, not only what I marked) ...more >>

I installed SQL SERVER 2005 with RS2005 - it worked great. Cause of a problem we had to re-installed the IIS so the virtual directories of RS where gone... To continue with errors i deleted the DB of RS So now i try to re-install the RS but i get this error: Reason: Your upgrade is blocked. ...more >>

I have over 200 log files with a date and timestamp in the filename in the Reporting Services\LogFiles folder that are 33MB each. This is a development machine. How do I get rid of them? Can I just delete them? Thanks, -- Dan D....more >>

After tearing out a few hairs I'll share my challenge: (given that only an image can be processed at runtime) I need to be able to take for example the List element below and create a sort of design time only CRI that once it is dragged into the report layout window in VS inserts the xml ...more >>

Does Reporting Services in any way offer justified text alignment? From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com...more >>

Is it possible to deploy report models without Visual Studio? I ask this for when it comes to deploy an ASP.NET project to a customer that includes reports and they would like to use the Report Builder. I've heard use of the RS Web Service but I have not seen any code. This would normally be ...more >>

Hi, I have set the page size and the report size to A4 dimensions. Within the page is the table, having the same size as the page (29.7 * 21) Is there a way I can set the table (not the text witin a table) in the center of the page? The number of columns vary, depending for on the month for wh...more >>

Hi All, I'm trying to deploy a report that have just been created in Visual Studio 2005 (for Microsoft CRM) I'm getting an error message ****************************** The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in...more >>

I have developed a custom assembly for my reports, and it works fine on the development machine. However.... Once I move the report to the production Report Server, it runs fine in preview mode within VS2005. But if I open the report from the Report Manager webpage, i get a "request for ...more >>

Sorry for repeating myself... I'm still looking for a workaround here.... Based on a User's credentials, I perform a query within our company's Sales Org to determine which Branches and Sales Reps are displayed in Parent Report's Table. Then, when the user clicks on a Sales Rep, a secondary...more >>

Hi All, I was able to get some hyperlinks to work within the context of a report (from a header section to details below). However, it seems that these hyperlinks within the report will only work when the report is accessed online with the Report Server (through the Report Manager). Is t...more >>

Hi! Does anybody know how one can prevent users from accessing some reports on the report server website using active directory? I have an active directory with all the users and I would like to use this to enable / disable users from viewing and accessing reports. Cheers Erik ...more >>

There is a date range parameter in my rdl, the list value is "This Week","This Month", "This Year" and "Custom", when user choose "Custom", then display two parameter "Date From" and "Date To" to select custom date range. My question, how to show "Date From" and "Date To" when user choose "Cu...more >>

Hi NG, I deinstalled SQLServer 2005 Express Edition and installed the Advanced Express Edition again to try the technics of the Reproting Services. The installation finished without any error message. If I try to run the Configuration-Manager for Reporting Services a message is immediatel...more >>

Hello, I'm struggling to make operations on results obtained from grouping by specific dimensions. To be more specific, I'd like to substract value of e.g. sales for some product for one year from values from the preceding year. I'd like to somehow access the resulting recordset from group...more >>

Hello All, I have created Reporting Services Report and I had given a user Browser permissions to browse the report. But he is not able to get to the report. The browser asks for userid and password and when typed it does not take it. Only when I put the user in the local administrator group...more >>