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 2006 > threads for wednesday 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

Barcodes in PDF
Posted by NDE at 4/12/2006 5:02:40 PM
Hi there I am creating a report with MS SQL reporting services 2000 that includes a barcode. It 's for a kind of ticket creation. So, I am using the Code 3of9 font to create my barcodes. So for example *01511051* is the text, but font type is code 3àf9, giving the barcode in display Whe...more >>

Show Reports in Excel Format
Posted by Bruce at 4/12/2006 11:29:03 AM
Is there a way to tell RS to use the Excel template? Instead of creating reports that looks exactly like Excel sheets Thanks in Advance...more >>

Incorrect printed pages in SQL Report-Imp. pls. reply asap
Posted by SDRoy at 4/12/2006 10:35:02 AM
Hi Can someone tell me why my printed pages from the print icon on SQL Report 2005 is different from the page # shown on the browser. Meaning, if I specify that I want to print page # 10 of a 50 paged report, the printed output is a different page and not the page #10 which is seen in the ...more >>

How to Stop or Abort Report Processing
Posted by Rob at 4/12/2006 8:39:01 AM
Is there a way to stop report processing based on evaluating a report parameter? If the paramater fails to meet a certain requirement I would like to stop report. I've come up with a work around to return no data in these scenarios. But I would like to stop report processing all together and a...more >>

RS2005 multi-select parameter
Posted by OTSolutions NO[at]SPAM shaw.ca at 4/12/2006 8:11:21 AM
How do I use the mult-select parameter option on a report and pass it to the stored procedure? ie. if I have a multi-select list of employees and I pass in the employeeid to the proc would I? create procedure show_employees(@empid int) as select * from employees where empid in (@empi...more >>

Dynamic Data in Page Header?
Posted by Thomas at 4/12/2006 7:40:03 AM
Hi all, is there's a way to add fields to the Page Header? We have to display dynamic data on each page... Thanks Thomas ...more >>

WHILE in data source does not iterate
Posted by William at 4/12/2006 7:17:02 AM
I have a while loop in a query that increments a date by one year so I can gather mult-year data for a particular date. The query works fine in QA, but in RS I only get the first year of data (the loop only appears to execute once). I can code a work around, but I would like to know why th...more >>

How to resolve the "The underlying connection was closed" error in RS2005.
Posted by CdSlc at 4/12/2006 6:59:23 AM
Hi, I have VS2003, VS2005, RS2000 and RS2005 all on the same PC. My VS2003 - RS2000 environment works fine. I can create a report, deploy it and see the reports through the web. But my RS2005 is a different story. Since I have two instances of SQL Server installed, I have called my SQL2005 ...more >>



Rename Server - SQL 2005 RS
Posted by Jefffff at 4/12/2006 6:52:01 AM
Windows 2003 R2, SQL 2005 I use Virtual Server images for my testing environments and so I need to be able to take my master copy of an image and rename the server so that I can put out on the network. When I do this, Reporting Services is unable to connect to the database, which is no sur...more >>

Printer issues
Posted by David at 4/12/2006 6:42:02 AM
I have a couple of users that is having problems printing a few of my reports. It takes over 20 minutes for the reports to print from my user. When I print from my computer and other computers, it prints fast and fine. The reports are around 10 pages. I notice when I print and look at the ...more >>

Dynamicaly add charts to report
Posted by Simon Gold at 4/12/2006 6:25:02 AM
I need display some processes (lines in a chart) in the report. One process per chart. The number of processes is not known at the design time and is defined by the result of the underlying report query, so I do not know how many chart objects to place on the report at design time. Is it possi...more >>

VS 2005 Location of error log
Posted by Nathan at 4/12/2006 4:06:50 AM
I'm developing reports using VS 2005 against SSRS 2005. I'm often getting an error when I try to preview a report and the ide says to see error log for more details. When I check the SSRS log's (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) I find the normal SSRS lo...more >>

Pass parameters to OLAP sub-report
Posted by waynest at 4/12/2006 3:16:42 AM
Hi there Using RS 2005 I've got a main report onto which I've placed a subreport to which I need to pass 2 parameters. I've done this a 100 times in the past but here I am getting this error message: [rsErrorExecutingSubreport] An error occurred while executing the subreport 'subrep...more >>

Populate parameters in sub reports
Posted by Jens Winter at 4/12/2006 12:00:00 AM
Hello, How do I populate the parameters of subreports? In the SubreportProcessingEvent there is a Parameters collection. But I can't fill any values. Ciao, Jens...more >>

Reporting Services subscription
Posted by Gouri at 4/12/2006 12:00:00 AM
Hi, Is it possible to create new subscription for reporting services in sql 2005 standard edition? I get New subscription and New data driven subscription greyed out. GS ...more >>

Reporting Services Scheduled Subscription Logon Error
Posted by Paul Buxton at 4/12/2006 12:00:00 AM
Hi all, For 8 months, I have had a set of Timed Subscriptions in use to generate and email reports. In the last few days, they've failed. The SQL Agent says success, but when you view the subscriptions in report manager, they say Logon Failed. There is nothing in Event viewewr, and I can...more >>

Parameters in subreports
Posted by Jens Winter at 4/12/2006 12:00:00 AM
Hi, I have problems using parameters in subreports. As soon as I add a parameter to one of my subreports the SubreportProcessingEvent doesn't get fired anymore. So I can't set parameter values. Does anyone know why this happens? Ciao, Jens...more >>


DevelopmentNow Blog