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 > april 2005 > threads for tuesday april 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

reporting services logfiles?
Posted by ECS at 4/12/2005 9:40:53 PM
can anyone tell me why the reporting service is dumping its logs in this folder? C:\Documents and Settings\NetworkService\Local Settings\Temp\LogFiles Is there a way to prevent this or get the logs back into: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles ...more >>


xquery in rdl
Posted by Shafia at 4/12/2005 4:18:57 PM
hi, I want to use xquery in the query part of the report definition is it supported? nageen ...more >>

Subscription
Posted by IB Ghost at 4/12/2005 4:03:52 PM
Hi, Is there a way I can stop a report subscription from being sent if there is no data available for it? Cheers Mandar ...more >>

RS Forms Authentication
Posted by Nate Dogg at 4/12/2005 3:26:40 PM
I have successfully implemeted Forms Authentication with reporting services. Now I have my web app that I wrote in VB.NET and use Reporting Services with URL access. My users have to login using the Logon.aspx and they can login successfully. I now need some guidance on how to make it so ...more >>

Null values cause row height to change
Posted by Byron at 4/12/2005 3:03:05 PM
I have a fairly simple report with several columns in the detail section. I have set the row height to 0.15in (text is 6pt) and set both CanGrow = false and CanShrink = false for all textboxes in the row. The report always renders perfectly in the Visual Studio preview tab and when exportin...more >>

Freeze Report Header
Posted by Jason B at 4/12/2005 1:17:52 PM
Is there a way to freeze the report header so when a user is looking at the report, on the web, and they scroll down the page that they can always see the header? Thanks, Jason ...more >>

Deploying to report server
Posted by Tab at 4/12/2005 12:33:08 PM
I was able to deploy reports but just recently get the error "A connection could not be made to the report server http://...../ReportServer". Does anyone have any suggestions on what i may want to look at? -- Tab...more >>

remote access to charts
Posted by Mike Smith at 4/12/2005 11:43:47 AM
When I create a chart and access it using an http://localhost/reportserver... url to display the chart, it works fine. However when I change the url to http://<server>/reportserver... where the <server> is the same physical machine as localhost (and the only change in the url), I don't see the c...more >>



Change report host server name?
Posted by Arthur Dent at 4/12/2005 10:17:58 AM
We have a SSRS web setup on one of our servers, and originally it was setup using the server's internal name. we want to be able to change this to use the external name. When you go to a report the frame which hosts the report output the src shows http://zweb/reportserver. we want this to show...more >>

site-wide-security
Posted by bjonigan at 4/12/2005 10:09:04 AM
I've installed reporting services on a server 2003 machine. I'm experiencing trouble with security administration. Any time I try to click "ok" on any of the security administration screens, nothing happens. The button just simply does not post the page. So I can't configure any new site-wide-...more >>

Can I back up a DataSource
Posted by DBA72 at 4/12/2005 9:17:01 AM
I am setting up all my reports to use a shared data source which will have its "Credentials stored securely in the report server". The datasource uses a windows account which has the "Use as Windows credentials when connecting to the data source" option set. The account used will have exec rig...more >>

Printing to a printer from SQL Server Reports
Posted by Lee Davies at 4/12/2005 9:14:05 AM
I am having problems understanding how to get a report to be sent to a printer. I have looked at the Printer Extension example which comes with the installation of SQL Reports but I still do not understand how to use this to send my reports. To put you in the picture I have rendered a repo...more >>

Including Images in Reports
Posted by Entellekt at 4/12/2005 8:40:03 AM
Is it possible to include an image within a SQL Server Report? e.g. 1. The image URI is stored in the database, can the report load this external URI into the report? e.g. 2. The image data is stored in the Database as binary, can the report render the Image? Any information would be g...more >>

Page Break?
Posted by Vinny Vinn at 4/12/2005 7:04:02 AM
Does anyone know how i can insert a page break in Sql Server Reports?(I am putting summary data at the end of the report and i would like it to be displayed on a separate page? TIA, Vinny...more >>

Is it possible to output a Field Value based on another field value?
Posted by chrispycrunch NO[at]SPAM gmail.com at 4/12/2005 6:58:57 AM
I would like the data value of a text field in a table to based on the value of another field (also used as a parameter). However, if I try switch or iif, I get an 'expression expected' error. For example, if car type is 'used' then output the 'salvage value' data field. If car type is 'new' o...more >>

Dynamic Tablename
Posted by Dieter Felix at 4/12/2005 4:19:01 AM
Hi, Maybe a simple Question I have a Dataset with following SQL Command: SELECT a.*, b.stelleText FROM verkauf_leas200510 a LEFT OUTER JOIN Vregion_stelle b ON a.stellelevel = b.stelleLevel AND a.stellekey = b.stelleKey WHERE (a.stellelevel = @pSte...more >>

Export to Excel
Posted by Pro at 4/12/2005 12:00:00 AM
Hi all, I cannot open the Excel report exported from Reporting Service by Excel2000. How to make the exported format (Excel) can be read by Excel2000? Thx Charles ...more >>

sp2 released date?
Posted by Donald at 4/12/2005 12:00:00 AM
someone said that it will release by the middle of this month? is it true ? I am waiting it for long time. Thanks in advance. ...more >>


DevelopmentNow Blog