all groups > sql server reporting services > december 2004 > threads for thursday december 23
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
Footer problems
Posted by Jim at 12/23/2004 11:30:59 AM
Hi all,
I've got a couple of problems with some reports that I'm developing:
1) I'm trying to print a Group Footer at the bottom of the page in a fixed
position, regardless of how many detail records there are. Is there a way
to do this?
2) I have another report that is supposed to giv... more >>
Using Action Items
Posted by Asim at 12/23/2004 11:11:03 AM
I am trying to refer a field using ACTION ITEM property and selecting JUMP TO
option. I am trying to create a linked field which if clicked will open up a
new report and passing this field as a parameter. How can i set up the values
of the other reports parameter in this report.
Thanks
Asim... more >>
maximum width
Posted by Bucky at 12/23/2004 10:27:39 AM
When loading a report that another developer created, I got an error
message saying that the deserialization failed because the width value
needs to be between 0 and 85.3333 in. I was able to get around this by
opening the RDL file in notepad and changing the width values manually.
But my qu... more >>
producing a report that lists 1 record per page
Posted by zero at 12/23/2004 9:55:33 AM
Greetings,
I am creating a report using VS.NET and SQL Reporting services. The
report I have created is detailed and has images and lines etc. I tied
this report to a stored proc that returns back 7 records in a result
set. When I view the report, the results list out downwards on a page
i... more >>
unexpected Error in Production
Posted by RK Balaji at 12/23/2004 9:05:03 AM
We received the following error on reporting server in production this
morning. I would like know if this is a known issue or what can be done to
prevent this from happening.. Following this error, the connection to the
report server database from the report server was lost for a brief moment.... more >>
Strange charting behaviour
Posted by Mark Allison at 12/23/2004 8:46:18 AM
Hi guys,
I have just built my first RS report and when I preview it I get the
this image:
http://tinyurl.com/4lfqv
My query in the dataset is this:
select DBName,statsdate,avg(space_used) as space_used
from DBAConfig.dbo.All_Usage_History
where Server = @Server group by DBName,statsd... more >>
how to change the user of the application pool and keep RS to work?
Posted by Jéjé at 12/23/2004 8:32:29 AM
Hi,
actually my application pool run under the network user, but I have to
change this to a specific user.
When I change my application pool, RS stop working.
How to do this?
What are the required steps?
Thanks.
Jerome.
... more >>
Average problem
Posted by Seb at 12/23/2004 7:19:03 AM
Hi,
I've a subtotal row in a matrix. I do an average of a column but the avg
function return me the average of all results of each rows. In fact, I want
do the average of each colums except where the results is equal to 0.
How can I do that?... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
GUID in parameter causes 'Invalid URI: The hostname could not be parsed'
Posted by Jeremy M. White at 12/23/2004 7:11:42 AM
I have a report in which I have a GUID as a parameter. This has worked
fine until I ran across one instance where I get the following error:
=======================================================================================================
Exception of type
Microsoft.ReportingServices.Re... more >>
rskeymgmt error (local NT service is disabled)
Posted by Zehra Kendir at 12/23/2004 5:53:03 AM
hello,
I am trying to install the full versinon of reporting services. When I try
to backup the symmetric key using RSKeyMgmt.exe it gives the error :
"System.Exception: The local NT Service is disabled 0x80090005 --->
System.E
xception: 0x80090005
--- End of inner exception stac... more >>
List
Posted by Mike Klaarhamer at 12/23/2004 4:29:02 AM
Hi,
I would like to create a dynamic legenda.
Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus,
DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne steunverlening,
KAZ=Kazernedienst, ... more >>
Custom Format
Posted by Seb at 12/23/2004 3:17:03 AM
Hi,
I've a problem. I get some decimals data from by database like 123,45 and
I'd like to create a custom format to print in my reports the decimals like
123,45 €. If I've 0 in database I'd like print as 0,00 €
How can I do that?
Thanks
... more >>
Export to Excel. Version Problem
Posted by Ale Dori at 12/23/2004 2:19:03 AM
when I try to eport a report in EXCEL format it only works on client with
EXCEL XP installed. With EXCEL 2000 it dosn't work correctly.
Anyone knows if there are EXCEL version Requirements??
Thenks... more >>
Import & Export
Posted by עידן at 12/23/2004 2:09:07 AM
Hi,
I'm using Reporting Services and MOM 2005.
How can I import existing reports to Visual Studio for design mode?... more >>
Average in Matrix
Posted by Mike Klaarhamer at 12/23/2004 2:09:04 AM
Hi Everyone!
I have a question about a matrix in RS.
Its possible to add a Subtotal to a matrix bij right-clicking and Add
Subtotal:
PAUL | 1
MIKE | 4
JOSE | 8
TOTAL | 13
But how can i get the average in this matrix like:
PAUL | 1
MIKE | 4
JOSE | ... more >>
|