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 > july 2004 > threads for wednesday july 28

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 31

How to use Render() SOAP API?
Posted by Chiara at 7/28/2004 11:55:20 PM
Hi How do i use the Render() method? Where do i begin? I am try out avoiding the grey pop-up message when exporting reports. Currently, i have a java servlet web application. There are hyperlinks to the reports in some JSP pages. I am using URL Access now. How do i use SOAP API instead? Th...more >>


Me!Value in matrix subtotal
Posted by Thomas Williams at 7/28/2004 10:50:02 PM
G'day all, Trying to set a property, for instance foreground color, based on Me!Value expression in a matric subtotal with an expression like: =IIf(Me.Value < 0, "Red", "Black") produces the following error: The color expression for the matrix ‘matrix1’ contains an error: [BC30456] 'Val...more >>

Published wish list?
Posted by noonie at 7/28/2004 10:40:07 PM
Greetings, Is there a published wish-list or a prioritised "future features" list for Reporting Services? Such a list would help me avoid asking if a non-existent feature has been implemented and (maybe) give me some idea of when a particular desirable feature may become available... -- ...more >>

Print report with report manager
Posted by Keenz at 7/28/2004 8:23:04 PM
Can I print reports with Report Manager ? Or I have to wait for the next version of Reporting Service ? Thanks...more >>

Datasets access from custom code
Posted by Mauricio Cadima at 7/28/2004 8:13:23 PM
Hi to all Is possible to access to the report datasets or even report items from the custom code embedded in the report?, If yes, how?,could you send some sample code? Thanks ...more >>

Table row height
Posted by Ernesto Bascón at 7/28/2004 6:30:29 PM
Hi everybody: I created a report using the report designer in VS.NET2003; my report contains a table that has a row with a height of 0.05 inches. The VS.NET2003 report designer preview shows me the report properly but when I deploy my report, the row that I created has a height of 0.22 inche...more >>

Questions of RS
Posted by angi at 7/28/2004 6:06:39 PM
1. I have 2 Data Sources in different DataBase Server, and want to combine them in one report, can RS DataSet support this? use what's kind of way? 2. What's difference between " Query Parameter " and " Filter " ? For purpose, implement, implement result and performance? Thanks! ...more >>

Hiding Rows....
Posted by ashvsaod at 7/28/2004 5:31:12 PM
I have the following in a cell... =iif(Fields!TRANSDATE.Value >= Parameters!Report_Parameter_Mon.Value, Fields!TRANSDATE.Value,Nothing) What I want it to do is if the TRANSDATE is greater than or equal to the Parameter display the TRANSDATE... otherwise don't display it... The above code...more >>



Changing the parameter of a Snapshot
Posted by primer200 NO[at]SPAM yahoo.com at 7/28/2004 4:59:02 PM
I understand that a history can be created in Reporting Services. Is it true that when you click on the "New Snapshot" button, you get a report using the default parameter? If so, then the "history" feature is pretty much useless as you can only generate one version of the report. What we want i...more >>

Could not establish secure channel for SSL/TLS
Posted by kbunch NO[at]SPAM gapac.com at 7/28/2004 4:47:04 PM
We are getting the same error. We changed the asp timeout at the master property level, and we are now getting the same error. I have checked the RSWebApplication.config and it matches the server name. I have gone through the other posts around this issue, but haven't been able to resolve the iss...more >>

Subscriptions Acting Erradicately
Posted by Joel Rumerman at 7/28/2004 4:37:21 PM
Some of my RS users have noted that they are not receiving their regular subscription report emails. I looked at the RS log file and it stated that the emails were being sent. I then talked to my operations staff and they stated they had no record of the emails coming across the email server (ex...more >>

Upgrade from trial
Posted by Will Byron at 7/28/2004 4:33:00 PM
If we originally installed the trial version Then installed Sp1, is it necessary to uninstall reporting services, delete db's and reinstall the Final version then reinstall SP1? Thanks ...more >>

Drill down using url access in ASP.net not working
Posted by yevger NO[at]SPAM yahoo.com at 7/28/2004 3:50:15 PM
I've been through a good bit of the message boards trying to find an answer to this problem. I have an application that uses an iframe to embed a MSRS report. I'm using URL access to call the report. The problem is that any drill downs in the report DO NOT actually expand anything in the report...more >>

Reporting Service in Cluster Web Server
Posted by dennis at 7/28/2004 3:39:07 PM
I am trying to install RS on two web servers which are clustered. First, I install the report service and report database on a sql server. then after i successfully install RS on the 1st webserver in web farm, i have problem install RS on the 2nd web server in web farm. below is the log. all three m...more >>

Dynamic Graphs
Posted by Kershni Chetty at 7/28/2004 3:37:44 PM
I'm tryin to create a graph, the info comes from a stored proc which takes in the day (eg Monday) as a parameter. The graph is then plotted based on that day. I now want to create graphs for 7 days of the week using this same stored proc. Can anybody give me any ideas as to how I can change th...more >>

Header Problem
Posted by vivi at 7/28/2004 3:11:02 PM
It is a header stuff: I have a header that have to be builded dynamic: For example on every page i want: Name Year Those are stored on the DB. What i did is, i create a parameter with a query value. and then on the header a textbox with that parameter, it works fine on the visual studi but wh...more >>

use of previous subtotal in Matrix
Posted by Claus Aaberg at 7/28/2004 2:59:46 PM
I'm running low on ideas (which might be because what i'm trying isn't possible). I'm trying to display a summary of inventory transaction by week: Week1 Week2 Week3 Sold -10 -15 -10 Purchased 15 20 ...more >>

Quickie: SMTP config for attachments
Posted by REM7600 at 7/28/2004 2:57:01 PM
I can configure a working subscription to e-mail through my SMTP server when sending only the LINK to a report but not if I attach the report to the e-mail in say excel or xml format. Any suggestions? Thanks Travis ...more >>

Question about userright
Posted by Frank at 7/28/2004 2:33:24 PM
I want to allow additional user to publish report to their own folder (yet only they have access to those report) This is what I did 1) I assigned a windows user as an system user. 2) I enabled "Enable My Reports to support user-owned folders for publishing and running personalized reports"...more >>

Deserialize ScheduleDefinition
Posted by Joel Rumerman at 7/28/2004 2:02:08 PM
I'm attempting to pull the Matchdata that is retrieved from the GetSubscriptionProperties call into an object. According to the documentation, matchdata is XML that is a represents a ScheduleDefinition object. What I'd like to do is deserialize the XML string into a ScheduleDefinition object. So...more >>

Multiple ToggleItems
Posted by chris.utter NO[at]SPAM gmail.com at 7/28/2004 1:57:40 PM
I have a report that utilizes five separate tables. All of the tables are filtered by the same datetimestamp, which appears in the detail row. Right now, I have the ToggleItem for all of the tables set to the same text box at the top of the report. I can also set the ToggleItem for each of th...more >>

Parameter bug in Service Pack 1
Posted by G at 7/28/2004 11:33:26 AM
I'm just curious if Microsoft has officially recognized the bug in Service Pack 1, where attempting to pass a hidden and a prompted variable to a report generates a Javascript "Object expected" error. Or is this still being researched? Anyone? Brian ...more >>

RS enhancements planned for VS 2005?
Posted by Jeff Davis at 7/28/2004 9:56:49 AM
I just downloaded SQL Server 2005 Beta 2 and looked over the RS functionality. Though the report designer is available from the Business Intelligence Development Studio rather than VS.Net, I can't find any significant enhancements in this rev of RS over the SQL 2000 SP 1 (i.e. support for rich t...more >>

RS_BooksOnline error 2711
Posted by Joe Bourne at 7/28/2004 9:44:12 AM
I'm doing the command line install with setup.exe /settings. In my ini file, I have the following enry (watch for line wrap): ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS _BooksOnline_EN,RS_Samples,RS_AdventureWorks The setup fails, and in the setup log file, I have this ...more >>

Blank Page Between Exported Report
Posted by Michael Solomons at 7/28/2004 9:27:01 AM
For some reason when I export the report from the web interface it exports with an extra page between each page - it looks as if it has set the tables that are in the report to 100% and then added an extra page because it overflowed. However, this does not occur when I export from the Report Ma...more >>

number formatting w/in charts and colors
Posted by Ha Vo at 7/28/2004 9:03:34 AM
1) How do you format numbers within charts. My numbers are currently without commas (ex. 20000) and decimals with no formattting ( example: 679.8906890). I would like them to be prettier with commas ( 20,000) and just 2 decimal places ( 679.89) , respectively. 2) How do I assign colors to cert...more >>

The underlying connection was closed: Could not establish secure channel for SSL
Posted by carlos lara at 7/28/2004 8:50:17 AM
The underlying connection was closed: Could not establish secure channel for SSL/TLS. I had try everithing. Does anyone have suggestion? Thanks in advance Carlos Lara ...more >>

Render to text file/MSWord
Posted by Chiara at 7/28/2004 4:24:03 AM
Hi How can i render report to MS Word? I need to create a report that looks like a letter. I can get some fields from the database. However the content of the letter changes. Therefore, i would like to render report to MSWord to let the user type changes . Other formats does not allow typi...more >>


DevelopmentNow Blog