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