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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|