I have three datasets connected to AS2005. They differ in the years they provide, but the product types need to be selected by the user. I can't figure out how to have different datasets use the same parameter selection. Thank you! Chris ...more >>

I want to be able to do something like iif(this.value >= 1, "Green", "Red") or iif(textbox3!Value >=1, ..... Is there a well to reference the current textbox for which i am performing an expression on. Thanks in advance. ...more >>

The report I have to create is a Medication Administration Record. Each page (of a minimum of three pages) must have at least 6 detail sections. If the patient upon whom we're reporting only has 3 active medications to display, I would like to display 3 details sections with the available dat...more >>

I've been reading and re-reading the posts concerning placing dataset fields into headers and footers. I use reporting services 2000. The best answer I got was the hidden field being referenced in the header and footer. But what happens if that field exists only on the first page? I'll tell ...more >>

In RS, is it possible to code an expression so that if a field contains the word "STAT" that whole row is highlighted in another color? If not, how about a that field? I can do it with numeric values, not text. Thanks. ...more >>

I get an error (Incorrect syntax near ','.) when I choose more than one value for any of the multi-valued report parameters in the below query. All parameters, except scheduled_date and tracking_number, are defined as multi-value. It may be a problem with strings appending. Any suggestions?...more >>

I am using SQL Server Reporting Services 2005. I need to export a report into a predefined XML format. I have the report exporting almost as I need it. The issue I can't seem to find a way around is supressing the export of the "Detail collection name" from a table. This XML tag can be fou...more >>

I have an expression that looks like this;"=Fields!Quantity.Value-Fields!QuantityAvailable.Value-Fields!QTYONORD.Value" The field returns fine, but I want negative values to be returned as 0 when the value is <=0. Any ideas on how to do this? Would I add a IIF to the expression? Any he...more >>

Hi, I would like to check if the external image url is valid, if it is not valid i would like to show another external "not available" image from an alternate url. Any idea how do do it or any function that i can use? i have added a vb function is the custom code to be called to check if t...more >>

Hello, We can embed server reports in .NET applications by using the ReportViewer control. Wondering if this still works when SSRS is running in Sharepoint integrated mode and the reports in question are hosted within Sharepoint? Thanks for any help, Jim...more >>

Does anyone know how I would execute/render a Reporting Services report (.rdl)outside of Reporting Services? I don't want to create a subscription. I would like to create a separate job to execute a series of rdls. This job would most likely be initiated from another As400 job once a month...more >>

Hi all im new to SQL reporting i am using visual studio 2005 and i am trying to do the following A count of finance term where finance term = 2 years, options are 1 and 2 year i have tried numerous ways can any one help me? =Count(Fields!FinanceTerm.Value) = 2 returns "false" =Count(Fiel...more >>

The below expression is in the font colour expression. It's not working 100%. The first part of each line works (before the OR), but the OR parts are not. Am I using the correct syntax for an OR statement? =IIF(TRIM(Fields!GSArchHeightNWBLeft.Value)="0" OR TRIM(Fields!GSArchHeightNWBLeft...more >>

Hi! I've got some problems with a few reports I've made. The MDX queries of the datasets are quite complex, so I have turned off design mode when working with them. Of course, design mode won't work anymore, but Report Designer has understood this until now and disabled design mode when I'v...more >>

Hello, Is it possible to change the default report layout which is used when you start a new report in Report Builder? I want e.g. always a logo, datetime and pagenumber in the header or footer. Regards, Jaap ...more >>

Hello, When I create a new matrix report in the Report Builder, then the height of the title cell of the dimension on the left of the matrix, is half height. If you want to see, I have a pdf to illustrate it. Is this a bug in the designer? Or can I solve this? Regards, Jaap ...more >>