I've set up a shared datasource to oracle with the option of prompting for credientals. The report works with just static SQL in the Query designer. I have been trying for a number of days now to use a call to an oracle stored procedure or function as my report data set without success. The func...more >>

I want a distinctCount in a group for a criteria. How can i do it I am doing something like this =CountDistinct(IIF(Fields!CATE.Value='N'),Fields!ERNR.Value,nothing), "grpResCat") Is this right? ...more >>

Based on data in my table (business date), I want to highlight any rows in red that are past a certain date. How can I selectively format background/font color? I'm pretty sure that I can do this using a second detail line and just hide one or the other but is there another way? Thanks...more >>

Howdo, I'm trying in vain to get the Printer Delivery sample working, originally I was getting errors like 'this printer is not installed' etc, after debugging the code in vs, I managed to sort that one out. Now I cannot seem to debug the actual process that sends the jobs to the printer - ...more >>

Hi, I'm having a problem with the datetime format in RS. I live in Canada but want to use the "en-US" language setting because most of our clients using the app are in the States. What I'm doing is formatting a start and end date parameter from a .NET calendar control with "MM/DD/YYYY" before ...more >>

Help! I have a project that has been completed and tested fully and today I was ready to move it to production. When I tried to open it, I received the error: Microsoft Development Environment is unable to load this document. Deserialization Failed: Font 'Arial' doesn't support style 'Regular.'...more >>

I am using the =now() expression in one of my reports but the SQL statement I am using uses runs the report based on data from 2 days ago. Is it possible to use something like =now()-2 to give the accurate date of the report data? =now()-2 doesn't work, and I have searched Books online, and help...more >>

Hi What is a minimal configuration of .NET Visual Studio to setup Reporting Service? Regards, Gennadi ...more >>

Did anyone have rendered a report in excel format directly to browser instead to a file? I tried this code below wich works fine for pdf rendering: result = rs.Render("/MyReports/SVREL00104", "Excel", Nothing, _ Nothing, params, Nothing, _ Nothing, encoding, mi...more >>

Is it possible to call for a RS report and pass in parameters from a SQL script? ...more >>

Getting warning in reporting services report: The value of the MIMEType property for the image ‘image1’ is “”, which is not a valid MIMEType. my image is a .GIF and source is set to External. It is my understanding that the MIMEType is ignored when source is External. I have also tried s...more >>

Hi All, I would like to create report like below: For example: I have a stored procedure spDeptEmp, which has a Dept ID as input parameter, Once the Dept ID has been passed in, I will get all the employees on that dept. The question is: I would like to generate the report, which will display...more >>

I have recently started using Reporting Services and am having a couple of problems with 2 reports that are linked to stored procedures in EM. The first one no mater what I have tried I can not get the fields list to fill. If I add the field I get column headers but no data will show inthe report, b...more >>

Using standard example reports. select Employee Sales Summary, with Syed Abbas and November 2003. Using Excel Render by program the BIFF sequence in the workbook globals is as expected: STYLE 0293 4 .€.ÿ 13 80 07 FF STYLE 0293 4 .€.ÿ 00 80 00 FF STYLE 0293 4 .€.ÿ 14 80 05 FF USESELF...more >>

Hi, I am facing a problem with the security extension of MSRS. I am using the form authentication sample. When i click or view any report or folder, it is calling the checkaccess method present in Authorization class. But the securitydescriptor parameter of the checkaccess method is ...more >>

I have a problem of hiding a few of my parameters. People are talking about the SP1 and the "Prompt User" check box. I have SP1 installed. But I cannot see "Prompt User" checkbox anywhere either in the ReportManager or the VS.NET Report Designer. I've been pulling my hair all day. Please let me ...more >>

I want to know how to use RSReportHost.exe from command line. I think someone already post this issue, but I forgot when and where. Thanks before...more >>

My report have tooltips for some of the columns and the tooltips display well when in HTML. But when I export it as excel/pdf format, the tooltips disappear. The tooltips are retained when in MHTML format though. Anyone knows whether this is a limitation of reporting service? is there any w...more >>

i am using reporting serveces : i created a DataExtension to get a dataset's value in the report as an xml input file (this works) 1. i am designing the report using this dataset's values and some calculated expressions like "runningvalue" everything works fine in the preview button but wh...more >>