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



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


DevelopmentNow Blog