I have a Report with 2 Date Parameters using Calendar Controls, followed by 2 multi-valued (cascading) parameters. This worked fine with the June CTP15. After upgrading to the Sept CTP16, if I change the default date (yesterday) on either calendar control, an error page is generated, with this...more >>

I have a table with groups. I have a detail field (textbox66) that has the following expression: =iif(Fields!endDate.Value = Nothing, 1, iif(Fields!endDate.Value < dateadd("d", 14, Parameters!startDate.Value), 0, 1)) I need to have a field in the group footer sum this column. How do I do...more >>

I can successfully create a subscription with the report embedded in the email as a web archive. But if I choose the file type to be excel or pdf, the email never comes though. However under the status column of the subscription it shows as being sent. (not in my junk mail either) I don't ...more >>

I'm having trouble getting my report to run on the reporting services server. I can run it fine from my machine, but when I deploy it, I get a Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I've set the datasource to use a shared datasource, with a ...more >>

I have a top level report in which I am select a particular run. The id for that run is passed to a child report which uses the id from that run to generate a list of possible values to generate the drill through report. My problem is that I seem to have to set both values from the top level...more >>

I have a simple report, it has one parameter(string type) that the user types in named description. They type their description in the parameter box, then click view report and the description is in a textbox on the report. The problem is when the description is over 2000 characters long it do...more >>

When installing the September SQL 2005 CTP, the installation of Reporting Services fails with the message: "The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation." Here's the section from the ...more >>

I'd like to use the render webservice method to render HTML for a report. Using DeviceInfo, I can jump from page to page (section to section). I can't figure out how to get the maximum number of sections. What am I missing?...more >>

Hi.. I using Charts in our reports. So far my requriment was only X - Y axis. Now I need to create Chart like X, Y and Secondary Y axis. Is there any way I can do this Chart using RS ? I don't see any option like Secondary axis. Thanks -Kris ...more >>

I'm in the process of writing a new renderer for Reporting Services to get around some of the problems it's main HTML renderer has - fixed headers, screen flash, losing scroll position on refresh, customisable refresh rate etc. Although it's been fun trying to do this with almost no documen...more >>

No matter what I try, after looking at various 'versions' supplied in MS documentation, I am unable to get the RS utility to accept more than one global variable. I have decided that it is a bug, guys. Just FYI -- Thanks, CGW...more >>

Is there a way to test whether a user chose the <select all> option from a multi-value user parameter prompt? I would like to evaluate what the user selected in order to display what the user selected but not print out every entry in the selection list if the user chose the <select all>. I...more >>

I have the following data: name, grade and am displaying it in a table like the following: table header: Monthly Attendance by Student group header: ="Grade: " & Fields!grade.Value (grade 1-12) group detail: =Fields!Name.Value group footer: need a count of the number of students in grade ...more >>

We have license for SQL 2000 but all I can find on the Microsoft download page was the 120-days trial for Reporting Service and SP1, SP2. http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions Is there a place to download the...more >>

Hi, --Question I have a created a custom data extension and I want to populate the query string with some default text, how can I do this? I've initialised the command text property to my desired default but it always shows an empty string in the designer? I've included the background as t...more >>

HI, We are using RunningValue function to alternate color for displaying rows. Here is the property value for backgrond color: =iif(RunningValue(Fields!Row_Date.Value, CountDistinct,Nothing) Mod 2, "white", "#E4E7E6") We are having a problem with using that and a drill down at the same ...more >>

I'm having trouble getting the rs utility to recognize more than one global variable. my command line is something like... rs -i c:\inetpub\MySite\DailyReports.rss -s http://localhost/reportserver -v AccountManagerID=203 ReportPath=”/DailyReports/Purchase Orders With Projected Shorts" Fil...more >>

Hi, I was wondering if anyone could help me with a bit of mdx. We want to display something like this: Year + Month Company Num of Cases Num of Cases that haven't been paid We want to show the number...more >>

Hi, My requirement is that I want users to be able to view a parameterised report without exposing a query string that can be tampered with. Users of our application are only allowed to view one particular report and none other than the one they have permission to. I want to expose some ...more >>

hi i have one report with a parameter. in this parameter iam using uniqidentifier (guid) as value and code as label. to filter the report data,iam using the uniqidentifier value. like (parameters!classrun.value) but it is giving sintax error. can any body help how i can use uniqueidentifier...more >>

Hi All, I want to know how to use the reporting services with SQL Server 2005. Do I need to get reporting services seperately for SQL Server 2005 or is it bundled with it. (I have installed the SQL Server 2005 Express edition) I can't install the SQL Serv...more >>

I have a requirement to export the report into multiple excel worksheet. Is that possible? Can someone please help me with that? Thanks -- Message posted via http://www.sqlmonster.com...more >>