Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > may 2005 > threads for wednesday may 18

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Reporting Services Install error on Windows 2K
Posted by Marc Hensley at 5/18/2005 4:55:32 PM
I am trying to install Reporting Services on a Windows 2000 Server with SP4 and SQL 2000 SP3. I keep getting an error as it is finalizing installation. I opened the RSMSIO.log and found the error entry -- 'Error 1935. An error occured during the installation of assembly component {D825F1C6-...more >>


What is the ValueLocID property used for ?
Posted by DaveD at 5/18/2005 4:47:01 PM
Did this just appear with the latest patch....... can you tell me what it is about ?...more >>

Report Hidden in Excel Export
Posted by Brian at 5/18/2005 2:36:33 PM
I have an ASPX page that I build to display a report generated in Reporting Services. The report is a table and is built using the Render command, generating HTML and inserting into the page. This work fine, but I have functionality that allows the report to also be exported to excel. I agai...more >>

Drilldown and charts fail to show
Posted by Olof at 5/18/2005 2:36:01 PM
I have multiple reports where drilldown doesn't work & chart doesn't show. It works on my local machine & and on a test-server. The server I want to implement it to has "_" in it's name so I tried to use the IP-adress instead. I get my total & subtotals but not the detail. Anyone got a idea h...more >>

Passing Value from Report to SubReport
Posted by Benjamin at 5/18/2005 2:32:09 PM
I have a Report that looks like this: Department Number of Employees MKT 58 Details... And i have a subreport displaying the info of the employees for a given department.. i want if its possible, that the user clicks on Details.. and ...more >>

SecurityException when running RS scripts
Posted by JoeA at 5/18/2005 1:05:01 PM
I'm getting an CAS exception when I run various RS scripts, though the scripts seem to work correctly... I'm running RS SP2. Any idea what might be wrong? - the dump looks like: Unhandled Exception: System.Security.SecurityException: Request for the permissi on of type System.Security.Per...more >>

Expect Parameters which was not supplied when hit the preview tab
Posted by MissQti at 5/18/2005 12:30:01 PM
I'm creating my reports and connect to the stored procedure. The results of data returned when I'm on Data Tab. However when I hit the Preview Tab I got the error said "An error has occured during report processing. Query execution failed for data set "TheNameOfMyData". Procedure "MyWebProce...more >>

Conditional page breaks
Posted by B Shaffer at 5/18/2005 12:15:02 PM
I want to set a page break at the change of a group conditionally based on a parameter value. Is there any way to do this in Reporting Services?...more >>



Question for CHART Experts: How to show Percentages?
Posted by neokortex at 5/18/2005 11:42:07 AM
We want a PIE chart to show the PERCENTAGE of each TYPE of a particular product for all the orders in a dataset. How do we get at the TOTAL number of orders in the dataset? When editing Chart properties. the VALUES editor on the DATA tab seems to apply only per category, which does not lend ...more >>

Weekly Activity Chart
Posted by Bethany at 5/18/2005 11:16:07 AM
I need to create a chart that tracks activity on a weekly basis. I am using SELECT MIN (datecompleted), COUNT(activity) from table GROUP BY DATEPART(ww,datecompleted), DATEPART (yy,datecompeted) This gives me a date for the beginning of each week and the amount of activity for all weeks ...more >>

How to use windows-based authentication (rsAccessDenied)
Posted by tabbey at 5/18/2005 9:45:50 AM
Hi, Question on how to setup the windows-based authentication correctly. From what I read so far, it seems that RS uses windows-based authentication as default security measure. However, other users who are on the same domain are getting the ACCESS DENIED error when accessing RS reports vi...more >>

Duplicating Chart Line Colors
Posted by BW at 5/18/2005 9:42:10 AM
Hello, We have several reports that we use that contain charts with several servers. The issue is that we have more than 16 servers in these charts and the colors start to duplicate. Is there a way to make the color palette use more colors? Any assistance would be appreciated. -- Th...more >>

Filter based on a parameter
Posted by Myles at 5/18/2005 9:29:53 AM
Hi all, How would you go about creatig a filter that is used based on the value of a parameter? Can this be done? Lets say we have a report parameter called 'Show cases missing <attribute> data?' If the user sets this to true, then the filter would kick in, which is a filter that wou...more >>

Report Dev
Posted by Gael Le Mouhaer at 5/18/2005 7:30:59 AM
Hello, I'am developping a report. In this report, I have a big table. I want to only one record per page. How can tell Report Services ti put the second table on the second page, the third .... ? Thx Gael...more >>

data-driven subscription not available
Posted by RMac at 5/18/2005 6:18:09 AM
I would like to setup a data-driven subscription for a report, but the New Data-driven Subscription button is not available on the subscription page - only the New Subscription button appears. I have checked that the report uses a custom data source and stores the user name and password crede...more >>

Page number reseting
Posted by Dave Sundell at 5/18/2005 5:51:34 AM
Are there any plans in RS 2005 to have greater control over page numbers with regard to group breaks? For example, if we have a multi-page report for each group with page numbers "page x of y" in the page footer, we would like the page number reset on each group break so that group 1 may h...more >>

Export to Excel fails - ASPNET_WP.EXE consumes 60% RAM
Posted by Nick Prudhoe at 5/18/2005 4:50:03 AM
I'm trying to export a report to Excel that contains 60,000 rows (but not more than Excels 65,000 limit) and I get an "internal server error". When I check the event log on the server it states that aspnet_wp.exe terminated the report process because it had consumed more than 60% of the ser...more >>

RGB background color problem in Report Designer
Posted by Wolfgang Himmelsbach at 5/18/2005 3:05:09 AM
Dear Report Designer Developers, FYI - when I am using (e.g in a table) a RGB background color (e.g. ="#003399“ = blue) instead of a color of the selectbox there is always a white background displayed in the Report Designer (layout view). Together with a white font color I do not see anyt...more >>

Datasource properties while publishing report
Posted by Jasvinder at 5/18/2005 2:18:04 AM
Hi, I am having problem where I am uploading report and setting its datasource properties using rs.setproperties. I had defined datasource but it says “data source in not published on report server” or “System.Web.Services.Protocols.SoapException: The required field DataSource is mi...more >>

Linked report rendered out of custom iFrame
Posted by GG at 5/18/2005 2:15:17 AM
I render my reports in the ReportViewer control on a aspx page of a corporate intranet. When I try to generate a linked report from within the control, the report is rendered in the web browser and not in the iFrame of my aspx page, taking the user out of my site and taking him to report manag...more >>


DevelopmentNow Blog