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