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 21

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

Accessing multiple recordsets in MRS
Posted by Monty at 11/21/2006 11:07:53 PM
Hi all, Can anybody tell me how to acccess multiple recordsets in mrs. Please read the following scenario. I have written a Stored Procedure in SQL Server, this SP returns two recordsets, suppose the sp name is my_test_sp (lets assign some alias for those two recordsets as recordsrt1 and re...more >>


dynamic matrix reports
Posted by jai at 11/21/2006 2:55:04 PM
Hello, Is it possible to create a report which allows users to select the fields for the matrix in a report. To explain in detail, can we allow the users to select the X and Y axis for a matrix in a report? For ex., there is a report containing a matrix which shows the total sales( data ...more >>

Using One Report Parameter for two vaules
Posted by Colin at 11/21/2006 2:31:10 PM
I've got a query where I pass in the start and end date for the parameters. These dates correlate to start and end dates of a quarter. I'd like the user to be able to choose Q1 2006 and a date is returned for @start and @end. Is there a way I can pass two values but only display one report ...more >>

Visual Studio Licence
Posted by Brankos at 11/21/2006 1:46:27 PM
Hi, We are planning to use SQL 2000 Reporting Services in order to create and deliver reports to our end-users. It is our understanding that we do not need any extra licenses for Reporting Services as long as our SQL Server is properly licensed. However, in order to use Report Designer w...more >>

always show subreport
Posted by aggiechick717 at 11/21/2006 12:03:30 PM
I have a report with many subreports. Recently the user requested that they would like the subreport to show even if no data is returned in the subreport. (They want the space on the report to show) Can this be done without redoing the whole report and taking out the subreports? I have tried ev...more >>

Generating Model in Report Manager
Posted by daveoram24 NO[at]SPAM hotmail.com at 11/21/2006 10:26:31 AM
Hi all, I am trying to generate a model in report manager so i can use the report builder function. However when i click on 'Generate Model' then fill out a name and click OK, it says: "You do not have sufficient permission to create this item in this folder." However, i have administrator pe...more >>

Corrupt Email Attachments
Posted by crferguson NO[at]SPAM gmail.com at 11/21/2006 9:59:03 AM
I'm having problems with file attachments delivered by RS2000 hosted on a W2003 server coming across corrupt. The SMTP server is a Lotus Domino server. I've searched this and other forums to find no answer on how (or if) this can be fixed. It seems there is a patch for non-2003 servers, but n...more >>

Clarification on SQL Server Reporting Services 2005
Posted by Reeves Smith at 11/21/2006 9:26:02 AM
Are all of the Reporting Services service packs handled in the SQL Server service packs? So, no more separate services packs for reporting services like in SQL Server Reporting Services 2000. Thanks Reeves ...more >>



RS2005+ADAM+User!Userid
Posted by jordi_ramis NO[at]SPAM hotmail.com at 11/21/2006 8:56:53 AM
Hi, I'm trying to obtain the value of some attributes of the current user, this is made using an OLEDB connection to an ADAM server. Then I use a query like this: Select RS-SGRE-OFFICE,RS-SGRE-CUSTOMER from 'LDAP://myserver/OU=Users ESP,DC=ibsesp,DC=loc' where userPrincipalName='jordi.ram...more >>

execution log report samples - job failing
Posted by Shawn at 11/21/2006 7:45:02 AM
I am trying to install the samle execution log reports provided with SSRS. http://msdn2.microsoft.com/en-us/library/ms161561.aspx When I try to install them on our development server everything goes fine until I try to start the job (step #13 in link above) "Execution of job 'RSExecutio...more >>

Fetching data from a Flat file in SQL Server2000
Posted by Praveen at 11/21/2006 7:24:44 AM
Posted - 11/03/2006 : 08:00:37 AM -------------------------------------------------------------------------------- Hi, I am new to SQL Server 2000. I have to write a stored procedure that fetches some of the fields from two flat files. Here is my requirement.... There is a flat file by...more >>

query execution failed for dataset
Posted by Tenchy at 11/21/2006 7:21:02 AM
have all my reports on a server, and so far have had no problems giving users access. They are all located in the Cg Role, i created. Here's the delima, I added a new user and to this role. The user can view report manager, view the folders, and view the reports..but when they try to run a ...more >>

Changing DB locations in production
Posted by cbmeeks at 11/21/2006 7:19:02 AM
Can't seem to find the answer to this one. Anyway, I have a report class that several developers use for reporting. Each developer has his own DB. The report class uses the web services for connecting/viewing. What I want to do is be able for each developer to pass a connection string ...more >>

HT enable remote errormessages
Posted by Zekske at 11/21/2006 6:45:01 AM
In our development environment we send our reports to the reportingserver but when we access them and get an errormessage wich says nothing. How can we enable the remote errormessages so wo don't have to go to the server and login locally? Regards...more >>

Need to Sort on this aggregate for Interactive Sort
Posted by bjkaledas at 11/21/2006 6:16:01 AM
I need to sort on this value =Last(Fields!ACTIVITYTIMESTAMP.Value) for an Interactive Sort. You can't sort on aggregates, but I need to do that because that is the information that is displayed in the report that I am sorting on. If I sort by =Fields!ACTIVITYTIMESTAMP.Value it does not work....more >>

Sql Server & IIS Problem
Posted by Mr. Murad Jamal at 11/21/2006 5:57:02 AM
dear guys, I have Windows Vista Ultimate, i installed IIS (default configuration) from Control Panel -> Programs & Features -> Windows Features dialog, and tested that http://localhost opens regularly ! everything is OK ! everything in the IIS console is STARTED ! I'm now trying to run Sql...more >>

date in Calander is in incorrect format
Posted by Namshub at 11/21/2006 12:00:00 AM
Hi this is driving me completely mad. UK based so we want the calendar parameter to display the date format as dd/MM/yyyy rather than MM/dd/YYYY. I'm using SQL RS 2005 on a Windows 2003 sp1 box. I've used regedit to look at all the user account international settings, all of which are ...more >>

Data Driven subscription not working for PDF, IMAGE
Posted by Ginny at 11/21/2006 12:00:00 AM
Hi, I worked on SQL Server tutorials in Books online, "Data Driven Subscription". In this tutorial, reports are delivered via email on a scheduled time. as per the tutorial emails are being delivered in "MHTML" format but it does not deliver the report in "PDF" or "Image" format. The repo...more >>


DevelopmentNow Blog