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 > october 2006 > threads for thursday october 12

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

SQL Timeout building report model
Posted by Davidlev at 10/12/2006 10:08:01 PM
Hi, I am trying to build a report model that contains a very large table (22 million rows). When the wizard gets to the part 'Calculating Column Uniqueness' on the very large table, I get an SQL timeout. Is there a way to increase the timeout on this process? My datasource that it uses has a ...more >>


why is BIDS cutting my Sql Statement in HALF?
Posted by susiedba NO[at]SPAM hotmail.com at 10/12/2006 6:08:19 PM
hey MS i'm pasting this sql statement into a subquery in BIDS AND IT KEEPS ON DROPPING THE WHERE CLAUSE grow some balls MS and hire some real testers you fat lazy stupid lame company.. and for once; why dont you hire some people that SPEAK ENGLISH I mean seriously here. WHO THE FUCK...more >>

Dundas help topic missing: 'Start from Zero' property
Posted by Steve MunLeeuw at 10/12/2006 5:27:26 PM
I searched the Dundas help for this property but found nothing. I've been experimenting with a stacked bar chart trying to work around another issue related to sorting the bars from left to right with a zero line and having the same order in the legend. I don't see that the property affects ...more >>

Dundas: Feature request: Allow expression on enabled property of chart legend
Posted by Steve MunLeeuw at 10/12/2006 3:51:32 PM
In our horizontal stacked bar charts we use a zero line as a watermark. Because we need to re-arange the sort order from left to right, rather than from the zero line we use a custom legend. Depending on the data availible we show one of two sets of statistics. I'd like to build two custom l...more >>

Can't Access Reports, Server App Unavailable, and Error and SQLServerAgent Can't Access EventLog Error
Posted by EoRaptor013 at 10/12/2006 2:29:13 PM
Somehow or another, our http://OurSQLServer/Reports has gone south. On the web interface we get this message: "Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to r...more >>

Table control columns difficult to resize with embeded rectangles and tables.
Posted by Steve MunLeeuw at 10/12/2006 1:47:40 PM
I can't remember where you post feature suggestions, so if you know please respond with a link. I'm maintaining a report that contains a table with nested tables, rectangles, and merged columns. I wanted to add a column on the far left to indent a section of the table. After doing this I'...more >>

hot key for "Expression" in VS2005
Posted by Dmitry Duginov at 10/12/2006 1:27:37 PM
Is there a hotkey for "Expression" right-click menu item in report designer? -- Regards, Dmitry...more >>

A connection could not be made to report server
Posted by AB at 10/12/2006 12:40:22 PM
Hi, :Every time I try to Deploy report I get this error A connection could not be made to report server http:// localhost/reports/pages/folder.aspx I have already tried: 1. Define my user 2. I can see the report manager from the browser 3. change to asp.net 2 4. find out that the IIS use...more >>



Creating a hyperlink within a report to access specific CRM screen
Posted by Tony at 10/12/2006 12:29:01 PM
Does anybody know how to create a hyperlink within a report to access specific CRM screen? Thanks!...more >>

repoting services charts rendering
Posted by Passx at 10/12/2006 12:13:00 PM
Hi Guys Can any body help me for this problem. I am having a table and two charts. These charts are places one below the other. When ever i view the report the first chart shows up fine at the side of the table. But the other chart which was placed below the first chart shows up after the t...more >>

"Pages breaks" when I add a page footer to the report
Posted by gdjoshua at 10/12/2006 11:04:01 AM
i have a report that calls several subreports. I had everything working fine until I added a page footer to the main report. All I put in it was a small textbox that is going to hold page numbers.... Anybody know why its page breaking? I hope it has nothing to do with the implicit keep t...more >>

Saving subscription reports in database
Posted by John Scott at 10/12/2006 10:10:01 AM
I was wondering if it was possible to have a Subscription report write back into a table on the database?? Thanks in advance, John Scott....more >>

timeout expired when building model
Posted by Dan D. at 10/12/2006 8:25:02 AM
Using VS2003. I was trying to build a model for a table with 17M rows. The process timed out around 90 minutes. Where can I increase the timeout setting? Thanks, -- Dan D....more >>

Secruing RS
Posted by Brennan at 10/12/2006 7:36:02 AM
Hi All: We are using RS 2005. I want to take away the New Data Source and Upload File options from the end user interface for regular users. Is this possible? Thanks ...more >>

"Global" Report Parameters
Posted by florian at 10/12/2006 7:06:00 AM
Hi, I have a report with 3 different datasets. How can I add a parameter to this report which works or is valid for all the 3 datasets? Thanks ...more >>

List of all folder permissions
Posted by madrigal at 10/12/2006 6:53:57 AM
Is there a way to get a list of all folder permissions per folder? We are in the process of cleaning up two Reporting Services boxes that have gotten way out of control, including permissions. Part of this process is assigning users to roles, rather than individual permissions on folders. But...more >>

rsInvalidReportServerDatabase-Error after installing SP2
Posted by Sandra Geisler at 10/12/2006 5:17:01 AM
Hello all, I have a W2003 Server machine running Sql Server 2000 SP4 and Reporting Services with *now* installed SP2 (before SP1). After installing the service pack, I get the following error (sry, its german): "Die Version der Berichtsserver-Datenbank liegt in einem Format vor, das nich...more >>

Dynamicly displaying Page Header and Page Footer
Posted by Wendy at 10/12/2006 1:47:02 AM
I need to show or hide Page Header and Footer on the last page of a report based on a parameter. Is there a way of doing this? Thanks in advance ...more >>

How to add parameters to a MDX query in RS 2005?
Posted by Kaisa M. Lindahl Lervik at 10/12/2006 12:00:00 AM
I'm currently struggling with parameters when doing reports based on SSAS 2005 in RS 2005. How do I add a new parameter to an MDX query, after having built the query using the wysiwig query builder? I could probably start all over again to use the query builder, but I can't figure out how to ...more >>

Problem with Report viewer
Posted by Tan at 10/12/2006 12:00:00 AM
Hi, I recently upgraded by ASP.Net 1.1 application to 2.0. 1.1 application = was using awReportViewer to view the reports. But, when upgraded, awreportViewer doesnt display the RS2005 = enhancements like sorting, etc...so I decided to replace it with Report = Viewer control in VS2005. Now ...more >>

for dgk and anyone else who knows
Posted by Nick Hatzis at 10/12/2006 12:00:00 AM
Thanks a lot dgk. You covered both cases and the second was the case needed. Although an other problem arised. I got this error message : "The source of the report definition has not been specified" I thought that when you set the report in the report viewer control the work is done but unfo...more >>

Incorrect page rotation when printing
Posted by Grant Morgan at 10/12/2006 12:00:00 AM
I have two machines on my network, that when printing a RS2005 report, rotate the page incorrectly. ie. Print a portrait report in landscape, cutting off the bottom of the report. I am printing by using the print button in the RS2005 control from a web browser. ...more >>


DevelopmentNow Blog