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 tuesday september 13

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

Brian Bischof's comparison between Crystal Reports and SQL Reporting Services
Posted by LaceyLou at 9/13/2005 8:25:39 PM
Could someone paste a link to a place where I could download the .pdf comparison between Crystal Reports and SQL Reporting Services that was done by Brian Bischof? His web site seems to be down and I really need this to help make up my mind. Thanks in advance. Jim...more >>


Excute Stored Procedure When Report Completes
Posted by digitor at 9/13/2005 6:52:26 PM
Does anyone know how to execute a stored procedure when a report is completed? Is there possibly an on report end event or something i can use perhaps? Any ideas? ...more >>

How about a Rich Text or HTML Text TextBox
Posted by asnewbie+rs=argh at 9/13/2005 6:00:01 PM
Come one guys how about a rich text or HTML text box in RS2005, this is a glaring omission. I know there are some workarounds, but for some items this is just necessary. How hard can this be? Lets consider an example. I have a report that I send out that is really quite complex. To help...more >>

Dynamically retrieve the name of all the parameters for a report.
Posted by Mike Barzilli at 9/13/2005 4:30:01 PM
Does anyone know, if you are inside the body of a report, of a way to have a textbox dynamically populated with the name of all the parameters that are on that report? So, the idea is, this textbox in the body of the report would have some expression, and that expression would always return...more >>

reading setting from config file
Posted by Abe at 9/13/2005 1:36:40 PM
I think its possible (is it?) to read from appSettings in web.config from a custom assembly deployed to the ReportServer. What happens when you subscribe to the report or the report is rendered from the windows service and not through the web service or Report Manager? Does it read from the we...more >>

Parameters collection
Posted by Paul H at 9/13/2005 12:34:43 PM
I have a function defined in Report->Report Properties-> Code Tab which I want to access the parameters collection to look for a Debug flag. I get the following error: c:\Reports\ReportMockup.rdl There is an error on line 4 of custom code: [BC30469] Reference to a non-shared member requires an...more >>

Report printing issue with header and footer
Posted by Sheila at 9/13/2005 10:01:02 AM
Hi, If I print the report (with header and footer defined in the report) from browser directly, report header and footer can not be printed properly, for example footer is printed in the middle of the page. But if i click the Print button from report maanger, it doesn't have such problem. I...more >>

Installation Error
Posted by Greg at 9/13/2005 9:44:22 AM
I have a SBS Premium with SQL Server 2000 SP3, I try to install Reporting Services Std, and send a error "One does not find the point of entry of the procedure abort in the DLL msvcr71.dll". Anybody can help me plz... Thanks in advance, Grg...more >>



First run of reports is SLOW
Posted by John at 9/13/2005 9:43:13 AM
Hello all I realize that the first time you run a report from RS it's slow because it has to load everything up. Is there some way around this? Can I setup a report to refresh itself every so often? Anyway to turn this off? I hate the 30 second wait time to view the first report......more >>

RS - Planning Question
Posted by Jerry Spivey at 9/13/2005 8:41:44 AM
Hi, We're looking to implement Reporting Services in our environment. We currently have a couple of high-end SQL Server boxes with relatively low usage. I'm considering installing Reporting Services on one of these SQL Server boxes or installing Reporting Services on another box isolated ...more >>

Expression Error: Attempted to divide by zero.
Posted by levogiro at 9/13/2005 7:08:05 AM
i'm trying to calculate a percent field with the following expression and getting the error message above: =IIF(Fields!valorPrevisto.Value = 0, 0, Fields!valorRealizado.Value / Fields!valorPrevisto.Value) what am i doing wrong ? thanks....more >>

How to convert parameter before passing it to the stored procedure
Posted by DBA72 at 9/13/2005 3:54:05 AM
I have a stored proc which accepts a date parameter as an int (YYYYMMDD) and which I do not want to change. I want to create a report which allows users to enter the date as a date and then convert this to the int format before passing it to the stored proc. I've already created the following ...more >>

Checking whether an external image exists
Posted by S=f8ren Lund at 9/13/2005 1:30:36 AM
Hello, I have a table containing an image with dynamic content. My dataset gives me a path to the image, now I can't be sure that the image actually exists in the file system so I check using File.Exists. This works fine on my development box but when I deploy it to my production environmen...more >>

Reporting Services Snapshots Access Denied
Posted by Paul L via SQLMonster.com at 9/13/2005 12:46:37 AM
Hi guys, I've set up a scheduled execution snapshots on a report; however, the snapshot could only be viewed once. After the snapshot file being created on rstempfiles directory, it cannot be acessed anymore. The error was 'Access to path "C:\Program Files\Microsoft SQL Server\RSTempFiles\RSFi...more >>

Filter report data
Posted by Amid at 9/13/2005 12:43:04 AM
Is it possible to filter report data dynamically (for example: FirstName like "Dim%") , when calling ReportService.Render method. If not then what are the other possible solutions? Thanks in advance....more >>

Problem in form Authentication
Posted by Gopal Prabhakaran at 9/13/2005 12:00:00 AM
Dear All, I have problem while calling my report from report server using URL METHOD. we have config'red our reporting service using forms Authentication. (so we have login page) My problem is i have to call the report, using URL METHOD, by supressing that login page why becos, some...more >>

'C.0.6.51'. The expected version is 'C.0.6.43'
Posted by EB at 9/13/2005 12:00:00 AM
Hi all, We have been using RS for about 3 mos, and just this am when attempting to access the main web page we get an error message saying: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.51'. The expected...more >>


DevelopmentNow Blog