Groups | Blog | Home


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



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


DevelopmentNow Blog