all groups > sql server reporting services > november 2006 > threads for tuesday november 14
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
<?xml version="1.0" encoding="utf-8"?>
Posted by aaron.kempf NO[at]SPAM gmail.com at 11/14/2006 4:43:37 PM
Hey we've been building some reports.. occassionally the build / change
team complains when we use 'special characters' in our reports..
I opened up our RDLs; and I noted that we have this as the first line
<?xml version=3D"1.0" encoding=3D"utf-8"?>
I was thinking that we might need to cha... more >>
Running multiple reports
Posted by Vorno at 11/14/2006 4:43:32 PM
Hi,
I need to find a way to run multiple reports simultaneously. I thought
that I could use subscriptions, but as the date parameter that I want
to run them for will be changing, I don't think that this is the
answer. Is there a tool out there that will allow me to package a group
of reports ... more >>
Need to populate a Report with Dynamic field list coming from a sp
Posted by rapiddata at 11/14/2006 4:26:01 PM
Is there a way to programatically specify dynamic fields list to be mapped to
reports columns at runtime. The stored procedure returns different fields
list in the result set and these fields need to be bound to report column
details.... more >>
changing subscription email address in RS2000
Posted by Jackson at 11/14/2006 4:21:59 PM
Is there a way I can change the email address associated to sending timed
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
Jackson
... more >>
Creating Template Reports in RS 2005
Posted by Chris Conner at 11/14/2006 2:14:07 PM
I am tired of creating reports from scratch that contain essentially the
same elements, i.e. page footer with DateTime printed, page numbering, and
headers with report file names, setting the same margins and grid spacing
EACH AND EVERYTIME I write a report.
I want to create a template repo... more >>
Logon failure: the user has not been granted the requested logon t
Posted by Sanjay T at 11/14/2006 1:40:02 PM
I get the following error when I try running a report using Reporting
Services 2005. The Data Source gets to SQL Server using a domain account. The
Application Pool is running under NETWORK SERVICE.
I see a lot of postings about allowing for Logon Locally. I am sure this
could fix the issu... more >>
Reports not running simultaneously.
Posted by Matt M at 11/14/2006 12:33:02 PM
On our SQL 2005 box it seems that only one report will run at a time. For
example, if I run one of our reports which takes about a minute to complete,
then I try to run another report (even a small one that takes a second to
run) the second report will just stay as a blank screen until the fir... more >>
Does an embedded XML DataSet have to be hardcoded?
Posted by Chris G. at 11/14/2006 12:03:02 PM
I have an XML DataSource in my report which does not specify a connection
string, because I want to use an embedded XML DataSet. However I would like
the XML DataSet text to be defined using an expression (actually a function
call in my custom assembly). Even though you can define an expressio... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Report with default of all
Posted by chad at 11/14/2006 11:53:52 AM
Have a report with three datasets. The first dataset pulls the
department table and uses this as one of the parameters.
select DEPT from dept
The second dataset pulls the division table and uses that as one of the
parameters.
select DIV from div
The third dataset calls a stored procedure t... more >>
Displaying '$' currency in a graph
Posted by Twobridge at 11/14/2006 11:12:10 AM
I am populating a graph from a stored procedure. My graph displays
without a problem, except for the fact that it will not show a $ dollar
sign. I have tried using FormatCurrency() function on the value, but
it does not work. I have also tried just inserting a $ in front of the
vaue "$" & Fie... more >>
Email as Rpt Delivery Option for Subscription
Posted by Dan at 11/14/2006 11:00:01 AM
Is email an option for delivery of a subscription? Right now the only thing
showing up in my reporting services as a report delivery option is "Report
Server File Share".
Is there a way to configure this to deliver via email?
If so, where can I find documentation on how to set this up?... more >>
SQL Reporting Services with Visual Basic 6
Posted by Jothi at 11/14/2006 9:53:02 AM
HI,
I would like to know if we could use VB6.00 to call SQL Reporting Services
and possibly pass information like selection criteria to these Reports.
Thanks,
Jothi... more >>
SQL Server 2000 Reporting Services
Posted by MartinClayton at 11/14/2006 9:33:30 AM
Hi,
At our company we are looking at implementing SQL Server 2000 Reporting
Services into our internet-based application. I have found a problem
with calling reports in a multi-user environment.
The problem is that generally a user will log into our (.Net 1.1)
application and then connects ... more >>
Change CSV export to TAB delimited
Posted by FidelR at 11/14/2006 9:22:01 AM
Hi,
I want to change the CSV export to TAB delimited instead of comma delimited
in order Excel to open it properly without defining the delimiter each time I
open the export. I define the following in rsreportserver.config:
<Extension Name="CSV-TAB"
Type="Microsoft.ReportingServices.Render... more >>
Uninstall SQL 2000 Reporting Services
Posted by Daniele Preite at 11/14/2006 8:35:02 AM
Hi,
We have on one single server SQL2000 and SQL 2000 reporting services standard.
We would like to uninstall the reporting services.
How can we do that keeping all other instances and DB's that are running on
the SQL server
Thank you in advance for your help... more >>
Report Filtering with Query and Report Parameter
Posted by Curtis at 11/14/2006 8:03:04 AM
I am attempting to filter my dataset based on a query parameter. It all
works except I am having difficulty allowing the user to show all
records by default.
My query parameter is based on a report parameter which is a String and
provides a user prompt. The values are obtained from a database ... more >>
Log Import Problem using Reporting Services
Posted by mivey4 at 11/14/2006 7:13:10 AM
Hi,
I am creating a report using MSS and the Microsoft utility
MSSLogToDatabase utility. The utility seems to work great until there
is an attempt to specify a subdirectory for the /reportfolder
parameter.
I have searched far and wide in diverse newsgroups, google, microsoft's
site and etc... more >>
open a report in a new window???
Posted by jonknutsonhome NO[at]SPAM yahoo.com at 11/14/2006 6:32:52 AM
Hi guys.. quick question.
We are using SRS.
When using my browser, i can find my list of reports...
the problem that my users want fixed.. is they want to click on a
report... and have it open in a new window.
so the main list of reports always stays open.. and also so they can
run mor... more >>
Show Adhoc report filter value in header?
Posted by Frits at 11/14/2006 3:56:01 AM
Is it possible to print the filter value that the user has selected in the
header? I know you can with custom reports (parameter value) but I don't see
any options to insert the filter value in a text box. Am I the only one that
wants this?... more >>
Report Models for OLAP Cubes
Posted by Marc at 11/14/2006 12:07:01 AM
Dear all
I studied BOL to find out how Report Models and Report Builder work. In
there it is written that Report Models from Cubes can only be created and
edited inside SQL Server Management Studio or Report Manager but not from
BIDS. They show this as an advantage, because automatical gene... more >>
|