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 > september 2005 > threads for friday september 9

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

Error Data bases not compatible, Installation Reporting services
Posted by Arturo Alegria Palacios at 9/9/2005 4:45:04 PM
Hi, I install Report services (standard, developer, enterprise edition) on sql server 2000 personal edition, and windows 2003 server enterprise, during the installation, when creating the data base sends the following message of error "This version of the data base of the Reporting services...more >>

Still can't Access Report server.
Posted by Bob at 9/9/2005 3:30:29 PM
Its on a Win Xp Pro that is part of domain, sitting on D: drive. Install went OK but still can't access the report manager. I still get the following although I did as explained in there to grant asp.net access rights to the folder. While testing this problem I also gave full rights to the cu...more >>

pdf instead of html as default output format
Posted by Ricardo at 9/9/2005 11:56:06 AM
Hi all, I would like to output all reports in pdf format instead of html. I dont want to allow users to choose an export format. So, if they access an URL and fill some textboxes with appropriated parameters I can send them a ready-to-print PDF file in Internet Explorer. Is it possible? ...more >>

Report Header
Posted by John Grant at 9/9/2005 10:50:03 AM
It doesn't appear to be possible, but does anyone know of a way to suppress the Report Header on all pages except the first page? Thanks John...more >>

Report Parameters
Posted by PeteMitchell at 9/9/2005 10:38:03 AM
I have a report that takes one parameter called StartDate and I have given it a default value and a prompt of 'Enter a Starting Date'. When I preview it in the report writer or run it from the Report Manager after deployment, the report runs using the default value, displays the correct data, ...more >>

Filter by parameter value
Posted by Brent at 9/9/2005 9:48:54 AM
Is this possible? I searched and couldnt find a solution that would allow me to filter my results by a paramter value that I want the user to be able to enter. My filtering works fine when entering in a numeric value in manually but not when running it by the parameter. I get the following error...more >>

Cancel Running Data Driven Subscription???
Posted by NO[at]SPAM at 9/9/2005 8:55:05 AM
Is there anyway to cancel a running data-driven subscription? I have one that was given incorrect credentials with the file share delivery extension and a dataset of 8000+ records to process. It has been running since yesterday and I really need to cancel it....it is throwing a log on error fo...more >>

Dataset limitation
Posted by Nat at 9/9/2005 8:50:04 AM
I have encountered a really strange error regarding using Unions in my datasets. If i exceed the limit of 4 unions in my dataset, it ignores the data for those 4 unions and only gives me the data from the 5th union and onwards until it reaches the limit of again 4 unions, i.e. 8 for the se...more >>



Group by Top # entered in as Parameter
Posted by Brent at 9/9/2005 8:38:49 AM
Background: I have a report that groups by Item number and gives adds up total amount for that item number. What I want to do is have the user enter in a numeric value as a parameter such as 10, 15, 20, etc that will then only display the TOP 10, 15, 20, etc (what they entered in the parameter) ...more >>

*** Interesting chart problem ****
Posted by Nagini Indugula at 9/9/2005 8:27:03 AM
Hi: Lets say for eg: you have LCD projectors that you can borrow at various times in a day. I need to create a chart that shows the 24 hours (like 12AM, 1AM, 2Am, 3Am...11PM, 12PM), on the X axis, and the LCD resource name on the Y axis, and if it was booked between 2AM and 4AM, have a colo...more >>

Hyperlink expression - conditional navigation and parameters
Posted by BootieDay at 9/9/2005 7:37:07 AM
I want to use the Jump to Report action in an expression to control jumping to one of two different reports, depending upon a parameter value. I can write the expression with no problem, but how do I control the parameter list? i.e. one of the reports take 4 params and the other takes only 1...more >>

problem with report parameters in nested IIf
Posted by Gearoid at 9/9/2005 4:27:52 AM
I have the following to diplay the frequecny a report is run for - based on parameters selected at run time... =3D"Report Period " & IIf(Parameters!StartDate.Value > "01/01/1900", Parameters!StartDate.Value & " to " & IIf(Parameters!EndDate.Value > "01/01/1900", Parameters!EndDate.Value, Pa...more >>

SRS, Oracle and empty parameters
Posted by John Grant at 9/9/2005 3:56:02 AM
Basically I am trying to generate a sql statement via an expression based upon 2 parameters: My dataset is being generated by the sql in this expression: ="SELECT GEN.CMDS_DOCUMENT.DOC_PREFIX, GEN.CMDS_DOCUMENT.DOC_NUM, GEN.CMDS_DOCUMENT.DOC_REVISION_LEVEL,GEN.CMDS_WUC.WUC_EQUIP, GEN.CMD...more >>

Who can I set the culture on report server?
Posted by ET at 9/9/2005 3:51:03 AM
I have created a Report which have a date parameter. As I execute it, a list box with available dates to chose is appeared at western format (MM/dd/yyyy) how can I change this to UK format (dd/MM/yyyy)? ...more >>

slow server in farm
Posted by Mel at 9/9/2005 1:59:04 AM
I have a problem with one web server in a web farm setup of 3 web servers (all identical) and two database servers (one for Warehouse, one for ReportServer/ReportServerTempDB). On the problem server all reports take much longer to execute. On either of the good servers the TimeDataRetrie...more >>

Please Help - User Authentication Problem
Posted by Rowan Massey at 9/9/2005 1:15:28 AM
Hi Lads, I'm having this severe problem that's wrecking my head altogether! I created a new user on my local machine, the purpose of this was to allow this user to access certain reports through an asp.net application (to build up the specified reports parameters, and pass them back using t...more >>

Problem when Exporting a Report which have subreports in it
Posted by Malik Asif Joyia at 9/9/2005 12:00:00 AM
Hello i am facing a problem when i render a report in Excel which have a subreport in it. it give me error "Sub Report within Table/Matrix are ignored". how can i solve this issue plz help. Thanks ...more >>


DevelopmentNow Blog