all groups > sql server reporting services > september 2004 > threads for wednesday september 8
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
report header and footer missing.
Posted by Asha at 9/8/2004 10:39:02 PM
hiye, i'm doing a drill down report (group type) everytime the reoprt loads
the headr and footer is missing untill i click on the plus (+) sign and then
only the headr and footer will be display. any idea?
thanks in advance.... more >>
ReportingService.GetServerDateTime Missing???
Posted by Marten Engblom at 9/8/2004 9:16:21 PM
It seems like the ReportingService.GetServerDateTime method is missing on
the webservice API, although it should be there according to the
documentation.
Any help appreciated!
Thanks,
Marten
... more >>
Improving Rept. Svcs. Charts
Posted by bill at 9/8/2004 6:01:04 PM
We are need of better quality/featured charts than Rept. Svcs. can currently
provide. (dual-Y axis, bigger chart selection, etc.)
I understand that a possible solution to this is to wrap a third-party
charting package with a Rept. Svc. custom assembly.
But before I start hacking out code, ... more >>
Subreports and NoRows
Posted by Dune at 9/8/2004 4:23:02 PM
Hi there,
I have a report that contains several subreports. My main report consists of
a list and within that list, a table. My subreports each reside in a detail
row of this table. Each subreport is set up in the same way, with a table
within a list.
I have set the NoRows property of th... more >>
Error Bad data
Posted by Derek Howard at 9/8/2004 4:01:04 PM
I have been working fine with no problems and just finished my first report
and deployed it with no errors. The next day I get the message below whenever
I try to run the report thru the report server or try to delploy from inside
VS.net. I have no encrypted data and only one user on this pc. ... more >>
Dynamic SQL statement
Posted by aplearner at 9/8/2004 2:39:02 PM
Hi all
I want to create a report with dynamic select statement. Does matrix
supports to pass a select statement as a parameter at runtime? I am
wondering[could not understand few reviews] how the matrix will support to
add dynamic columns and rows at runtime. I will have fixed columns of 5... more >>
Linked Reports Custom Code
Posted by Stoma_Kalos at 9/8/2004 1:51:14 PM
I am having problems attaching report parameters to a linked report that I
create programatically. Basically, I want to allow users to create linked
reports and set their own defaults for parameters. I am able to do this with
parameters that are already setup to use default values. For Exam... more >>
Generate Report Export from Stored Procedure
Posted by John A. Prejean at 9/8/2004 1:35:34 PM
I have what should be a simple task, but I cannot find any information on
how to accomplish it. All I want is a stored procedure that I can call on
demand to export a report to a given format, path, and file name. I have
found ways to write a VB.Net application to do this using the "Render" ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How do page breaks work
Posted by Rodrigo Sánchez at 9/8/2004 12:30:38 PM
Can somebody please explain when are page breaks ignored?, if i put a
pagebreak in a rectangle in a table it doesnt work, if i place on inside a
subreport inside of the table it works, if i put one on the group it works
but if i use both at the same time, only one works, can somebody explain how
... more >>
Chart and image rendering problem
Posted by Vemund Haga at 9/8/2004 11:20:30 AM
Hello,
Has anybody found a solution to the problem where images and charts doesn't
show when the report is opened from ../Reports, but is OK in Visual Studio,
.../Reportserver and in subscriptions?
Best regards,
Vemund
... more >>
Data-Driven Subscription Link
Posted by Jerry at 9/8/2004 10:42:33 AM
Hi,
I'm setting up a data driven subscription for a report. I'm using email as
the delivery option, am NOT including the report in the email, instead using
the hyperlink feature to bring the user to the report on the server. I
tested it out and I received the email with the link but the link d... more >>
HTMLviewer format is screwy
Posted by Joe Scalise at 9/8/2004 9:44:24 AM
After i deploy my reports, and use and HTMLviewer to run the reports, some
of the format is wrong. For example, after every textbox with drilldown
capabilities, now has a blank line appear underneath it. Where in RS this
does not happen. Also small amount of white between colored text boxes... more >>
Report Server database advice
Posted by Matt at 9/8/2004 9:38:42 AM
Hi,
is there likely to be any problem with us adding our own custom tables and
stored procedures to the report server database?
We will not be modifying any of the existing objects. Our objects are just
to add some of our own functionality.
thanks
Matt
... more >>
Can you have a seperate SQL Server and Web server and use SQL Reporting?
Posted by Ed Willis at 9/8/2004 9:02:50 AM
Does anybody out there have a web server and a seperate SQL Server and they
are able to make SQL Reporting work?
I get the following error when trying to deploy my SQL Reporting project:
The underlying connection was closed: Could not establish trust relationship
with remote server
Help... more >>
Dynamically change column width in matrix
Posted by Henry at 9/8/2004 8:52:59 AM
Hi, All,
I am designing a report which will use matrix to show a pivot table. Matrix
in reporting service is wonderful for showing a pivot table. However, when
it is used to show the detail information based on column group, I cannot
change the column width dynamically. The width for column... more >>
Programing: RENDER METHOD and PAGE COUNTS for HTML Rendering
Posted by Dennis Redfield at 9/8/2004 8:42:18 AM
We understand how to use the Render method of the RS web service. And can
successfully render reports in image and PDF formats. I am having a problem
with HTML rendering. we understand how to (and are able to) render HTML
reports as a single "section" (i.e. page) or to generate all sections in ... more >>
Custom Data Extensions Previewing Report
Posted by jblum NO[at]SPAM fusionalliance.com at 9/8/2004 8:27:29 AM
I have created a custom Data extension that returns a dataset through
a datareader. I am attempting to create a report using this extension
as the datasource and am receiving an error when trying to view the
report in Preview. The error is saying it can not find my extension
Datasource.
Any... more >>
DDS Sends multiple emails. Bug??
Posted by Matt at 9/8/2004 8:14:43 AM
Hi,
can anyone tell me what's going on here.
I BCC myself on all data driven subscriptions to ensure people are receiving
their subscriptions and there is no funny business going on.
In one case, the query for my data driven subscription returns one record.
So I should only get one email ... more >>
Rendering formats
Posted by Todd at 9/8/2004 8:07:45 AM
I have a report that incorporates stand alone textboxes and a table and has
25 pages. I want the same textboxes to appear on every page along with the
table that holds dynamic data which changes for each page. When I render to
html everything works fine but when I preview it and render the rep... more >>
Linked Reports?
Posted by fzuma NO[at]SPAM yahoo.com at 9/8/2004 6:52:12 AM
I am trying to replicate the Microsoft way of creating Linked Reports
through custom code. Creating a Linked Report without parameters is
fairly easy, however reports with parameters are creating a challenge.
For reports that have parameters I am trying to retrieve and set
using GetReportParam... more >>
Text Box name displayed when exporting to CSV format
Posted by nidhee NO[at]SPAM gmail.com at 9/8/2004 6:42:25 AM
Hi,
I have a table with a single column. When I export the report in CSV
format. The name of the TextBox of the details row of the table is
displayed on top of the report. How can I avoid this?
Regards,
Nidhee... more >>
Sql Reporting-Freezing the Headers
Posted by Bhavs at 9/8/2004 3:33:08 AM
Hi,
Am creating reports using Sql Reporting Services. If the report has to be
scrolled up and down, the column headers are also moving along with it.
i need to freeze the cloumn headers so that they are visible all the time(
when the window is scrolledup/down).... more >>
how to unsum a column.
Posted by Asha at 9/8/2004 3:09:03 AM
why does it evertime i create a new dataset, my column auto sum the integer
fields? can someone explain this to me and how can i un sum it? thanks... more >>
Filter only a column in a matrix with values from a parameter?
Posted by Martin at 9/8/2004 2:57:02 AM
Hi!
Is it possible to filter only a specific column in at matrix with values
from a parameter? I don't want to filer the whole matrix (i know how to do
that)
/Martin... more >>
Setting bar chart's bar color background to transparent with only markers are visible
Posted by tommytan25 NO[at]SPAM yahoo.com at 9/8/2004 2:32:39 AM
Hi,
From http://groups.google.com/groups?hl=en&lr=&ie=UTF-&safe=off&selm=uQvNYHyYEHA.992%40TK2MSFTNGP10.phx.gbl
I understand we can change the marker color thru RDL file... I wonder
if there's a way to change the background color of the bars in the
graph as well.
I'm using a bar chart dis... more >>
|