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 > 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 >>



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 >>


DevelopmentNow Blog