all groups > sql server reporting services > november 2004 > threads for tuesday november 16
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
FEATURE REQUEST: Jump to Report with rs:, rc: parameters
Posted by Jeff A. Stucker at 11/16/2004 5:48:23 PM
FEATURE REQUEST (already submitted to sqlwish@microsoft.com): Allow rs: and
rc: parameters as an exception to the "CLR-compliant parameter name" rule
within Navigation Parameter properties.
Background: I have created a custom report manager that displays reports
within an IFRAME. With URL a... more >>
Batch Execution of Reports
Posted by Marc at 11/16/2004 5:44:32 PM
I have a report server set up with about a dozen or so reports. Right now,
the user is accessing each one (via a URL with the appropriate PDF rendering
tags) from a custom web application to generate the reports. What they'd
really prefer to do is click one "button" or something that execute... more >>
CSV Export problem
Posted by Jan Bodey via SQLMonster.com at 11/16/2004 5:03:44 PM
Hi
I wish to export a reportas CSV format, however when I open it in Excel it is assuming it is fixed width seperated, when it clearly is comma seperated! Is there any way I can get it to do it right?
I am using Excel 2000 to view the csv output, and it is being triggered via a URL on a ASP.N... more >>
How do I use an IFRAME to show a report?
Posted by Jim at 11/16/2004 4:16:20 PM
Hi,
I've got a report that I wish to display within an IFRAME on an existing
site. It looks great, and fits nicely. The problem is, when I drill
through one of my charts, the target for the image map is "_top", i.e. the
report I've drilled through to is no longer in the IFRAME, but rather... more >>
Dynamic MDX Deployement in Reporting Services
Posted by AndyT at 11/16/2004 3:03:10 PM
I have created a Reporting Services report that uses MDX to retrieve data
from a cube. The MDX statements must use a parameter so they are placed into
text strings. The report will run with the Dynamic MDX in Visual Studio but
when I deploy it to the Web Server it locks up.
I believe th... more >>
Trouble with Reporting Services on Performance Monitor data
Posted by Peter Ordal at 11/16/2004 1:59:14 PM
Hi,
I'm having a lot of trouble using Reporting Services to handle data from the
Performance Monitor on Windows Server 2003. This stems from the way
Performance Monitor logs timestamp information. It puts its CounterDateTime
information into a character field, and appends a weird ASCII char... more >>
Calling my web service from the custom code is failing
Posted by yogeshprabhu NO[at]SPAM hotmail.com at 11/16/2004 1:46:06 PM
This is what I'm trying to achieve. I want to call into my custom
assembly from the reports, and that assembly in turn calls a web
service. The reason I have to do that is because I think we can't
directly call a web service from the reports. To complicate the things
further I also have Forms Au... more >>
Report Server and Report Manager on different machines
Posted by Justin at 11/16/2004 1:41:03 PM
It is possible to configure a system of servers such that
the Report Manager can be running on a separate machine
than the Report Server?
We are concerned about the security issues of exposing a
server with the Front Page Server Extensions installed on
it, because it will reside outside o... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
RS from VBScript/ASP web-app
Posted by Leif at 11/16/2004 1:03:39 PM
I have been playing a round with RepServices for some time, creating some
nice, dynamic reports.
Now our pointy-haired boss would like for me to incorporate a few of these
reports into an old internet application, which was developed using VBS/ASP.
This would be a temporary solution, the applica... more >>
Report Formatting
Posted by Yoshi at 11/16/2004 11:18:10 AM
Hi !
I have a simple question. I am using a Table in my report. I would like to
apply a different color to alternating rows in the table.
What is the correct or recommended way to do this?
Thank you,
Y
... more >>
Sum only header values
Posted by Jose Pollola Baron at 11/16/2004 11:03:18 AM
My datasource returns records with head and detail data in each record, and
I
would like to get a total of a head value, but if I use
sum(fields!total_cost) function I get dupplicated values because the value
repeats for each detail. I can't use sum(reportitemes!txtCost.value) because
I'm not i... more >>
Execute permission cannot be acquired?
Posted by Brian at 11/16/2004 9:59:09 AM
I have an assembly which uses file I/O to stream in some text based reports
into a container in a report. I have set the FileIOPermissionAttribute and
it works in the design environment but when I deploy the dll to the report
server it only works on that box. If I try to run it through the p... more >>
Is there Limit to # of Matrixes Displayed in RDL?
Posted by mike at 11/16/2004 8:10:01 AM
I have a report that consists of 12 matrixes. In Dev Studio all the data for
all matrixes returns correctly, but when the rdl is on the Report Server and
the Report is run, the 12th ( last ) matrix only displays column group and
row headings, no detail data within the matrix cells. Also from... more >>
Dateadd - Time accumulation
Posted by Gary at 11/16/2004 7:31:02 AM
Hi.
I'm in the process of converting seconds into an HH:mm:ss format using the
following statement...
=DateAdd("s", Sum(Fields!TimeInSeconds.Value), #01/01/0001#)
This gives me an absolute value of the beginning of time, which is great.
The problem arises when I clock over the 24h scenario, ... more >>
Desperate Newbie - Charts
Posted by CGW at 11/16/2004 6:19:02 AM
I have a chart rendering problem. Sometimes the chart renders in the browser,
sometimes it does not. Even when it doesn’t, it exports successfully to pdf,
etc. And it renders fine in VS.
I have tried a number of things and so far have succeeded only in reversing
the instances where the ch... more >>
Connection Issues with Oracle Data Source
Posted by Marty at 11/16/2004 6:06:02 AM
We are getting a recurring connection problem when connecting to an Oracle 9i
database. The error we get is ORA 12154 - Cannot create a connection to data
source. This issue only occurs on the Report Server and not in the
development environment.
This is an intermittent problem although... more >>
Rendering report
Posted by Osvaldo Colitti at 11/16/2004 3:34:11 AM
I request a report from a web service to be rendered in html 4.0 format.
In the request i also set this parameter:
<DeviceInfo><HTMLFragment>true</HTMLFragment>
The rendering is ok, but the problem is that the images in the report are
not displaied.
Any ideas?
Thanks!
--
OSVALDO COLI... more >>
|