all groups > sql server reporting services > june 2004 > threads for friday june 18
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
Fireevent call generates a warning...
Posted by Jéjé at 6/18/2004 7:13:40 PM
I see this warning in the RS log file when I call the fireevent method:
ReportingServicesService!dbpolling!cd0!18/06/2004-19:03:57:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!95c!18/06/2004-19:03:57:: EventPolling
processing item ... more >>
Newbie: working with expressions on tables
Posted by Cindy Lee at 6/18/2004 4:26:36 PM
I was reading the help, but I don't know if this is possible.
Dataset
first | last | Id
a | b | 1
c | d | 2
e | f | 3
For 1 cell I want to put:
Fields!ID.Value where Fields!First.Value="c" and Fields!Last.Value="d"
I just want to put specific fields in different spots. I didn't ... more >>
Web access to this newsgroup
Posted by Paul Ibison at 6/18/2004 4:22:01 PM
Please can anyone tell me what is the URL for web access to this newsgroup?
I used to navigate to it using a node under sqlserver but it seems to have
disappeared!
TIA,
Paul Ibison
... more >>
RepeatWith property doesn't appear to work
Posted by Bryan Bullard at 6/18/2004 4:01:23 PM
The RepeatWith property doesn't appear to work. I have named an element (a
table) that in is the same ReportItems collection but the object is only
displayed on the first page of the report.
Thanks
... more >>
Stored Procedure with dynamic T-SQL data fields not showing up
Posted by Jessica C at 6/18/2004 3:04:27 PM
I have a stored procedure where the final thing it is does is call
execute sp_executesql @SQL
and in reporting services the data shows up but the only field available to
put on the report is "ID" which is not a column name from the sp.... the
correct data set is coming back when I run the sp... more >>
RS web farm installation problem
Posted by Alex Korygin at 6/18/2004 2:42:01 PM
Hi,
we have a web farm of two IIS servers, running under Windows 2003. Because of the security requirements, the servers are not part of a domain. After installing the Reporting Services on both machines, we have an activation problem: activation of the second server de-activates the first one an... more >>
Export Excel Bug In Visual Studio .Net
Posted by Bryan Bullard at 6/18/2004 2:11:44 PM
I have a problem. In the Preview Pane I can export to web archive or PDF
fine. When I try to export to Excel, I get a text file with a .xls
extension with the follow contents (obviously not an excel format):
MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related;boundar... more >>
Code Samples for external linking to Reports
Posted by Karthik at 6/18/2004 2:02:37 PM
Hello All,
Are there any code samples which would let me post a URL
link from a classic ASP app to specified Reports on SRS
via URL querystring parameters?
Any thoughts/insight would be greatly appreciated...
TIA,
--Karthik... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Support for Nested Datasets
Posted by jcohen NO[at]SPAM kensingtonbooks.com at 6/18/2004 1:52:00 PM
I have an idea for a report that grab a list of titles and for each
title runs a one page snapshot report. I have queries in place to get
all the data for the one title (sales, main info, print info). But, I
was wondering in RS can I have one dataset that can feed its rows
(grabbed title #'s) t... more >>
Service Pack 1
Posted by Rus Bailey at 6/18/2004 1:12:09 PM
Is there a release date for service pack 1?
... more >>
Reporting SVCS and OLAP
Posted by Matej Kavèiè at 6/18/2004 12:58:01 PM
Hello
I have question about OLAP and reporting services, is there any way, or any
add in component for Reporting SVCS, for dynamic olap table. First when i
read feature of Reporting services i read something about integration with
OWC so i was thougt that i can add OWC PivotTable like compone... more >>
Cached instances require credentials - why??
Posted by Joe at 6/18/2004 12:42:01 PM
Why do cached reports require credentials to be stored? Credentials required for snapshots I can understand, but a cached report is initiated by the user, so integrated security should be possible?
TIA... more >>
Hide in list view?
Posted by Joe at 6/18/2004 12:40:02 PM
Can anyone tell me when you would want to do this and what exactly it does? I've seen this as a property of reports.
TIA... more >>
Where do I find the Product Key for installing on web server when SQL Server is on separate server ??
Posted by Laurence Neville at 6/18/2004 12:37:03 PM
I am attempting to set up the following architecture for Reporting Services:
Report Designer on a number of workstations running Visual Studio 2003
RS web site (not sure of correct terms for this) on two IIS 5.0 web
servers NOT running SQL Server, one inside our firewall and the other
... more >>
Shared Datasources?
Posted by Mr Bloggs at 6/18/2004 12:36:01 PM
Are there any benefits of using a shared datasource or using a datasource defined in the report?
TIA... more >>
Again: eMail subscription
Posted by Roland at 6/18/2004 12:31:59 PM
I got a clue what might be wrong on my server machines which do not allow
eMail subscription due to a "configuration error"
I have an XP machine here with a local SQL server and a local RS client and
server. If I look at the property page of a given report there is always
something like that (... more >>
User Selected Multiple Parameters
Posted by MichaelY at 6/18/2004 11:29:11 AM
I am trying to run a report that lets the user selects items out of a list
and run it on those items only. How do I allow a user to select multiple
parameters? For example, instead of selecting items A, B, and C separtely
and running 3 seperate reports, I want to be able to select A, B, and C an... more >>
Install issues under IIS6
Posted by Z D at 6/18/2004 11:20:21 AM
Hello,
I ran the installer on a windows 2000/ iis5 server and no issues at all, the
server components were available during setup (trial version downloaded from
MS).
I subsequently tried the same thing on a Windows 2003 / IIS6 server and it
says IIS is not properly configured but it does no... more >>
Extent of Dundas functionality
Posted by murphy NO[at]SPAM murphysw.com at 6/18/2004 10:48:20 AM
I'm planning to implement MS RS and to take advantage of the charting
supplied by Dundas in my web application. My question is this:
Is the chart control available for use on web pages not created via MS
RS? I will be running MS RS and MS SQL on one machine and IIS on
another. In my web app... more >>
Limiting Dataset for Chart but not Table
Posted by Christopher Walls at 6/18/2004 9:43:41 AM
I have a report that has a single dataset that is used to populate both a
chart and a table. I want to limit the rows used by the chart but I want
the table to display all rows. I'm having difficulty determining how to
apply some sort of "rowcount <=10" condition to the chart's dataset. I
wou... more >>
Urgent - Page Numbers are Incorrect (PDF) - Please help
Posted by chanley54 at 6/18/2004 9:23:01 AM
Hello,
I have been through the various posts looking for a solution. I am using
=" " & Globals.PageNumber & " of " & Globals.txtTotalPages and am consistently getting the wrong values.
I have a report that is 269 pages and the top header section says that I have 267 pages. When I get ... more >>
Installing Reporting Services Problem
Posted by Ian at 6/18/2004 9:00:05 AM
I would be grateful if anyone could offer any pointers here. I am trying to
install Reporting Services Beta 2.
The setup.exe fails or more like hangs after I agree to the licensing and
press Next, On the Component Update. A red arrow pointing to Microsoft
Reporting Services Setup Support Files... more >>
Security and Inactive OK button
Posted by Christopher Walls at 6/18/2004 8:29:43 AM
I've recently setup Reporting Services and I created a test report. As long
as a user is an administrator, they can view the report. I attempted to
create a new role assignment for the home folder. I click "Properties",
then "New Role Assignment". No matter what I specify as the user/group or... more >>
Reporting Services Web Service Programming Question
Posted by Tom at 6/18/2004 7:54:01 AM
I'm trying to go through the Reporting Service Web Service programming reference and I am having trouble figuring out how to do the following:
(1) Create a role in the home directory
(2) Associate the role to an NT Domain group
(3) Associate this role to the Browser role
Can anyone please prov... more >>
Where field = Null
Posted by Derek in Richmond at 6/18/2004 7:33:02 AM
I am not a Microsoft programmer, and do most of my work in Oracle databases using SQL, so I have a syntax question. The context is - I am re-writing our client's reports in Reporting Services. I originally designed and developed these reports in Crystal 7. I'm having trouble "duplicating" many of... more >>
Generating reports using data feeds from other systems
Posted by Graham Goodey at 6/18/2004 7:26:38 AM
Dear all,
I've been following this group with interest for a while now but haven't
seen any firm pointers for a solution to meet my problems.
Essentially I would like to be able to
1) Create reports, acknowledgements, delivery notes, invoices, etc using
data supplied from my legacy system ... more >>
Using Expressions in TextAlign for TextBox
Posted by sbieker NO[at]SPAM yahoo.com at 6/18/2004 7:13:24 AM
I am having troubles trying to make an expression work in a TextBox.
Can someone please provide some guidance. I am able to make
expressions work for most properties, but not for TextAlign. Here are
two examples, the TextDecoration works, but TextAlign does not.
TextAlign
=iif(Value = 32, ... more >>
Show ChartFX graph in Reporting Services?
Posted by Joey F Jeremiah at 6/18/2004 5:32:01 AM
(first time poster, forgive me if something doesn't work)
I have created a report in Reporting Services that works how I want it. Except for one part, it doesn't appear to allow for Histograms.
I have created a Histogram using ChartFX.
Is there any way to incorporate this chartfx graph int... more >>
suppresing url of internet explorer while exporting report
Posted by samar mahapatra at 6/18/2004 12:12:18 AM
hi
i want to supress the url or page while rendering the
report into a specific format . so that the user can not
view the url while exporting . as in the url uses query
string method for redirrecting .
Any idea regarding this problem
regards
samar
... more >>
|