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 2005 > threads for thursday october 20

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

Report Server error
Posted by Claude at 10/20/2005 10:30:02 PM
I have a RS200 server with many reports that work fine. There is one report that comes up with the following error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'StockCoverage'. (rsErrorExecutingCommand) Get Onlin...more >>

1 dataset per report grouping??
Posted by yoyo at 10/20/2005 9:25:01 PM
Hi, Is it that I must retrived all the data that i need via 1 sql statement when i need to do grouping in my report?? ...more >>

manually removing encryption keys
Posted by chandra NO[at]SPAM cbmi.org.au at 10/20/2005 7:33:45 PM
Hi, I am trying to recover a reporting services installation to a different server with a different name. At the moment I am battling a "this edition of reporting services does not support web farms". I think now I have remove all the encryption keys and then install just one key, with the ...more >>

Sub-Report Footers and Headers
Posted by Alexey Kouzmitch at 10/20/2005 5:12:41 PM
Hi, Is there a way to display the Header and/or Footer of the subreport in the header and footer space of the containing report or at least get the header and footer of the sub-report to render? Thanks. Alexey. ...more >>

Exporting to Excel from Preview Tab
Posted by Giya at 10/20/2005 4:51:02 PM
I designed a report and from Preview tab, i exported it to Excel format and saved. I sent the Xls file to others, but when they opened it, it is displaying the Metadata info of the file. any idea what is going on? In my report i have a table, and above it i have a bunch of textboxes which s...more >>

Reporting Services performance
Posted by Dennis P via SQLMonster.com at 10/20/2005 3:01:04 PM
When I first go to the Report Manager, it takes a long time to load the web page (15-30 seconds). After that it loads in a acceptable amount of time. is there a way to configure it so that the page loads more quickly the first time? -- Message posted via http://www.sqlmonster.com...more >>

oracle driver
Posted by Teresa at 10/20/2005 2:57:03 PM
Where can I download the Oracle driver for SQL Server Reporting Server? The Oracle Client is 500MB, wasn't sure if there's something smaller for just the driver. Thanks!...more >>

Cross Domain report authentication
Posted by Kalyan at 10/20/2005 2:26:00 PM
Hi all, I have a reporting server(with reports) on "domain1". and the users who login into web applications which is on a different domain say "domain2" to access the reports. I used to have a url access to the reporting server. but when the user tries to generate a report it ask for authentica...more >>



Subscription or creating reports on demand
Posted by sam at 10/20/2005 2:02:13 PM
I presume that subcribtion reports are run with default values to parameters and will be send to all the subscriibed users. User specific data cannot be obtained this way. Please correct me if I am wrong. Now my requirement is I have to generate a report for all the managers on status of th...more >>

Where does list of users come from
Posted by Jeffrey K. Ericson at 10/20/2005 1:59:01 PM
I am trying to admin a new to me reporting services site. All roles are granted at the home folder level. When I click on properties, a list of users appears. This list corresponds to a list in the users table within the reporting sever database. How do names get in and out of the table? ...more >>

Iff command need to sup in text
Posted by Bill at 10/20/2005 12:27:11 PM
New to this. Im teaching myself this so bear with me thx. I have a report where each section returned i.e. 1, 2, 3.. has information what I would like to do is rather then having it show 1 say for the section I would like it to subsititue the proper text based on the number i.e. 1 = Top ...more >>

Images in reports . . . .TIFs?
Posted by Rick at 10/20/2005 12:17:02 PM
I am trying to embed images within the detail line of my report. It appearse that this should be easy, the primary problem is the images are .tif . From everything I am seeing .tifs do not appear to be supported. Is this the case or am I selecting the wrong option somehow along the way? I fi...more >>

Open existing report with Report Builder?
Posted by Justin Marshall at 10/20/2005 11:53:01 AM
Greetings, I would like to be able to open an existing server report for editing with Report Builder. I have done a lot of investigation but have not come across anything. I know that Report Builder can be launched by navigating to http://<localhost>/reportserver/reportbuilder/reportbuilder....more >>

MDX Parser
Posted by Fernando Marçal at 10/20/2005 9:26:02 AM
Hello, Im currently running SEPT CTP, and im trying to create a report based on a dataset filled by a MDX query. That query must have parameters. I have defined the query in query designer, but after that I must edit the query because some of my parameters include spaces ' ' and I must edit...more >>

Footer pointing to ReportItems
Posted by KimB at 10/20/2005 8:45:56 AM
I know that you cannot use a field in a footer, but you can use ReportItems in a footer. My problem is that the field I am referencing only appears on the first page of my report, so the item only appears on the first page of my report. Does anyone know of anyway around this issue? I need some...more >>

SQL RS 2005 and Stylesheets
Posted by Chris Durkin at 10/20/2005 8:04:02 AM
Greetings... There's been some discussion in here on the lack of support for stylesheets. I added a suggestion on the MSDN feedback center. Please vote for it! http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?feedbackId=FDBK38995 -Chris ...more >>

Working Locally but not remotely
Posted by Bryan Avery at 10/20/2005 7:49:06 AM
I have just installed RS on a machine which I can access locally with no troubles at all, I can view the folders and view the reports. But when I access the RS from a machine over the Internet I find the folders come up all okay, when I click on a report is goes as if to load and then displ...more >>

How to get from JobID back to SubscriptionID
Posted by bobhug at 10/20/2005 6:47:10 AM
Hi! I am hoping someone can explain how I can determine the subscription associated with a currently running job (report). If a report is misbehaving, we would like to determine the subscription that initiated the report running. We can cancel the job to stop the report from running this ...more >>

Q: Deployed report
Posted by JIM.H. at 10/20/2005 6:19:27 AM
Hello, When I run Build=> Deploy , where does the report go, I check Virtual Directory of ReportServer which is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer in my case and I do not see any file related to my report. Thanks, ...more >>

Bar chart target value
Posted by Mattsson at 10/20/2005 4:40:02 AM
Hi, I need to create a bar chart with values for quality indicators. Is there a way to draw a horizontal line to indicate target or min/max value in RS 2000 (2005)? ...more >>

Question: Stored Credentials
Posted by Terry at 10/20/2005 4:28:01 AM
When should the option 'Credentials stored securely in the report server' be used? And, what type of account should be setup or used? Is the stored credentials use for unattended or scheduled reports setup by the Report Designer? Thank you for your assistance....more >>

BI Development Studio Licensing in SQL Server 2005
Posted by penfoldtaylor NO[at]SPAM gmail.com at 10/20/2005 3:39:06 AM
Can someone clarify the above for me? Specifically, do you need VS 2005 installed and/or a license or is the Development Studio covered under the SQL Server 2005 licence in it's entirety? Thanks, Paul ...more >>

radar chart ?
Posted by Tenval Ael at 10/20/2005 12:37:01 AM
Hello, it seems that the radar type of chart is not available for Reporting Services (in opposition, it is available in OWC10). Anyone can confirm that or anyone has found any way to use radar chart in Reporting Services (without purchasing commercial chart) ? Thanks in advance...more >>


DevelopmentNow Blog