Hi, I am trying to find out information on how to use the CustomReportItem node. The online documentation (and RDL specification) talks about accessing a RichTextControl as an example but does not give details on full implementation required. If CustomReportItem is currently supported (se...more >>

Hi- I'm trying to create a calculated field that is the percentage difference between two database fields. To prevent a divide by zero, I tried making it: = Iif( Fields!dsPrice.Value <> 0, (Fields!eePrice.Value - Fields!dsPrice.Value) / Fields!dsPrice.Value, 1) This should provide the % diff,...more >>

I have a vb.net project which compiled to CommonLibrary.dll with no error when I add references CommonLibrary.dll on my reporting project, it will show an error(as following) when I compile the reporting project Error message: "\TestReport.rdl Error while loading code module: ‘CommonLibrar...more >>

I am having a difficult time with the following problem. I have a calculated field that calculates the difference between two dates, resulting in the number of seconds between the two dates. I would like to display this value as: xx hrs yy mins zz secs I have written an expression usin...more >>

Hello... I have a report I made on my local machine that runs fine. When I deploy this report, along with the datasources, to a remote server, the report fails and gives me the following error: SQL Server does not exist or access denied. I figured this might be due to the stored proced...more >>

Is it possible to manipulate table or matrix cells with colspan in reports? I have several reports that show Client and Project. Currently, the only way I have to display it is like this: Clientname ..................Project What I want to do is like this: Clientname ......Project Is it...more >>

How can I use checkbox and listbox (with multiple selection) for report paramters? Do I need to go into the coding to do this, or I can do this from the designing tool? Currently I can only use either a textbox (for single value) or a pulldown box (for list of pre-defined values). I want to...more >>

How do you pass a set a parameter null from an expression (i.e. drill through report)? I've tried null, nothing, System.DBNull; none of these work. Thanks. ...more >>

Hi, I wanna know if it's possible to deploy reports to a production environment where sql server is completely not needed? Maybe only some reporting service components that can be installed for the report generation? I know this question has been asked before, but I just can't find a defini...more >>

An +/- button includes a rc:Area parameter placed there by Reporting Services. I cannot find any documentation about the rc:Area parameter. Can anyone give me a description of the parameter? Can I remove this parameter from the link? ...more >>

Hello, I was hoping to modify the default interface for the Report Manager to feel more like our other online reporting pages. I found a few articles about creating asp.net web applications and all that, but was hoping just to change the color scheme, place an image somewhere, etc... is ...more >>

Most users have no problems, but some are experiencing this. They can hit the Report Server fine and are able to see the folders and report links. Only when they try to click on a report link do they get a "page cannot be displayed" error. The permissions are fine - identical to other u...more >>

I installed Reporting Services onto my SQL 2000 Developer edition on windows XP. I can create reports in visual studio .net . However I do not have a Report Manager in Start->All Programs->Microsoft SQL Server-> Reporting Services I am going through the samples so I can use Reporting Serv...more >>

Hi All. Is it posible (or any trick) to do this in presentation level in reporting service (not using sql)? -- group by brand name and code section is repeating. -- Before Sony 1 2 3 Toshiba 1 2 -- After Sony 1 ,2, 3 Toshiba 1, 2 Byung Choi ...more >>

I'm trying to hide a subreport when there is nothing to show. I already have the the subreport itself set the hidden property. The problem is that on the main page, when the report is blank, it still takes up space on the page. There are several subreports called, so they add up. Thanks ...more >>

Hi, Is there any way that the parameters passed from the URL is not shown to the users. Making the "Prompt User" unchecked and passing the parameter through the URL gave some error. Is there a work around. Thanks. -- Message posted via http://www.sqlmonster.com...more >>

I have a report requiring two different data sources be compared in one data region. For example, I'm comparing a measure for a client against a national average. The client measure comes from one cube and the national average is stored in a sql database. RS won't allow two data sources to be...more >>

Hi I have a field that holds an integer value. I want to only show the value of a remainder if there is one. =Fields!IDCount.Value, Mod 2 What I am looking for is if the number is not even, then by having a remainder when dividing by two will prove it is an odd number. I keep gett...more >>

How can I pass a null value for a parameter in a url? I have a StoredProc report that should accept null values from a url. sp: (works fine) exec report1 1, '471316:18435720', '57348022', '981IPCI1-000',NULL,NULL,NULL,NULL,NULL direct url: (doesn't work) ....&SiteQuery=1&CFIDTOKEN= 47...more >>

Hi! Is there any way to set a default export format so that the user doesn't have to choose export format from the dropdownlist before clicking export? Thanks Patrik...more >>

I have a .RDL file. I need to show it as a Report in a internet Explorer using Asp.net. Simply, I have a .RDL File and using ReportServer i have to view .RDL in a Report Format. Thanx Karthik.A ...more >>

Hi, Does anybody know how i can add a borderline (at the top), only when there is a value in that cell? (when the cell is empty then no borderline). Expression in the borderstyle-property? Gr. Mike...more >>