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 > october 2004 > threads for thursday october 14

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

when is a custom assembly instance created?
Posted by klumsy NO[at]SPAM xtra.co.nz at 10/14/2004 9:26:32 PM
Does anyone know when a custom assembly instance is created? i had thought once per report. however i have some custom code using the custom assembly inside parameters name and values list, and it seems that whenever a earlier cascading parameter is changed (and thus the dependand parameters wil...more >>

Deploy Error - URGENT PLEASE
Posted by bob at 10/14/2004 7:59:01 PM
Hi, While deploying my report recently, I am getting following error. Previously I was able to deploy sucessfully. I am seeing this error recently. Can anyone help. Error says to look into documentation, but I could not get any clue. "The report server cannot decrypt the symmetric key used...more >>

No "From" field on the subscriptions page
Posted by TJ at 10/14/2004 5:02:09 PM
We are starting to use data-driven subscriptions for multiple applications and would like to change the From address for each subscription. There isn't a "From" field on the "Delivery extension settings for Report Server Email" page in the Data-driven subscriptions section of Reporting Manager. L...more >>

Multiple tables in a report?
Posted by Jerrad at 10/14/2004 4:05:13 PM
I have 2 datasets defined and 2 tables in my report. I want to have the results of one dataset in one table, and the results of the other dataset in the other table. Is there a way to specify which dataset I want the table to use? The report designer only lets me use an aggregate (= First(Fi...more >>

Changing Data Sources
Posted by alien251 at 10/14/2004 3:04:22 PM
If I have a dataset that uses a certain data source, if I change the data source do I have to redefine my dataset and replace the fields from the dataset in my designer...? Dan...more >>

Urgent: The page you requested cannot be displayed - after 1 hour of running
Posted by harshwardhan NO[at]SPAM mailcity.com at 10/14/2004 2:56:07 PM
I have a report that takes over 2 hours to execute. I have set the "report execution timeout" at "do not time out"... However - after 1 hour the report automatically says: "The page you requested cannot be displayed".. What could this be related to? I was looking at the settings in RSRe...more >>

Expression help
Posted by repalley at 10/14/2004 2:55:04 PM
i have a dropdownlist(it is filled with cities) as parameterin my report i have matrix and table in my report matrix shows data for all cities Table shows data for one city i want to write exprssion or custom code to hide table or matrix. when user selects ALL in dropdown list then i want to ...more >>

Item count in collapsed region
Posted by Marcus Phass at 10/14/2004 2:54:40 PM
Initially I have collapsed regions on my report with drill-down possibility. How can I show the number of items that are directly beneath that region? Something like: + Beverages (4) + Cigarettes (6) .... ...more >>



The item '' cannot be found.
Posted by Matt at 10/14/2004 1:50:25 PM
Hi, I have a report that compiles and runs find. However, when I try to deploy, I get the error The item '' cannot be found. What does this mean? thanks ...more >>

browser
Posted by jos at 10/14/2004 1:33:04 PM
I have a customer who wants to start using repsvcs but is unable at the moment to go to IE6, they have IE5. Any chance of getting (parts of) svcs working? Thanks a lot...more >>

Parameter dependency on other params
Posted by Dude at 10/14/2004 1:29:01 PM
Hi, I have a param in my report which depends on the other two parameters. So every time I change either Param1 or Param2 the list for Param3 is automatically refreshed. While this works fine in one of the reports, I am having following problems in the another report - 1. A "Tab" after modif...more >>

Getting report chart images from reports with parameters...not wor
Posted by Brian Parker at 10/14/2004 12:51:10 PM
I've been rendering chart images successfully for a report using the ReportingService web services for a few weeks now. Today I had to add a parameter to the report and now after I call my render method and loop through the returned streamId's to get the images, I get the exception: "rsStr...more >>

Cannot create new roles for users or groups as well as folders
Posted by Peter Capazzi at 10/14/2004 12:47:12 PM
Good afternoon, I cannot seem to create or modify both roles and folders in Report Manager. When I click on OK in the form to create or modify existing items nothing happens. Am I forgetting something? I had an issue during the installation or RS that may weigh in... the installation of...more >>

Conditional formatting on a text box
Posted by Kelly at 10/14/2004 11:41:52 AM
Hi all - I have a report that I need to duplicate in RS. What I'm trying to do is put some conditional formatting on my detail textboxes. I want the text to be bold if the field = certain things. ie. If the line detail on the report = "Invoiced Sales", "Trade Sales", "Net Sales"..etc I need...more >>

Custom Assemblies & ADO.NET
Posted by Javier Catala at 10/14/2004 11:35:31 AM
Hi everyone, I have a problem with custom assemblies. I have a report which uses a custom assembly. This custom assembly access a SQL Server database using ADO.NET. The report runs ok in the Report Designer, but I get a error (#Error) in the Report Manager. I don't know if I have to mak...more >>

Combine two or more reports into one PDF Report
Posted by Bryan E. at 10/14/2004 11:23:07 AM
We are building a "Annual Statement" which will include a series or Reports that will be bound into a Booklet. We will need a table of Contents (With Page Numbers) and also need the pages to be continuous throughout. Our question is what is the best approach to build this dynamically in Rep...more >>

Date Parameter ERROR
Posted by doug at 10/14/2004 11:13:03 AM
My RS has two date parameters setup as a date data type. If the user was to key in 01102004 instead of 01/10/2004 they get this error; Reporting Services Error "The value provided for the report parameter 'P_FromDate' is not valid for its type. (rsReportParameterTypeMismatch)" How can se...more >>

Background Image in Table Cell - Inconsistent Rendering
Posted by apotter NO[at]SPAM mindspring.com at 10/14/2004 11:06:08 AM
I am calling reports via URL and displaying them within an iFrame on an .aspx page. My report tables use background images in the header cells for a decorative effect. The images used as the background are embedded into each report. The rendering of these images is very inconsistent. If th...more >>

Hiding Field if Data is Null
Posted by jason_sweet NO[at]SPAM earthlink.net at 10/14/2004 10:23:41 AM
I'm simulating a mailing label-type format that contains mailing address information: Name Title Company Address Address2 City, State Zip Since not all customers have an address2 line, I want to suppress the Address2 field if it is null. This way, I don't have a blank line: Jason Sw...more >>

CSV Export Bug
Posted by mharoon at 10/14/2004 9:47:19 AM
Hello, I have a report that displays data from SQL Server, and it also has a subscription that exports the report as a CSV file to a network share on specified schedule. There is another external app that picks up the CSV file and imports it into a proprietary database. The report uses ...more >>

There is an error in xml document (0,0)
Posted by Jerrad at 10/14/2004 9:47:11 AM
when I open any reporting solution in VS.net or try to create a new one I get the above error. I've googled for an answer and it appears that vs.net is trying to bring up some invalid xml file. So where can I find this file and how do I go about fixing this? Any ideas would be helpful...more >>

Form Authentification and Automatic Signon
Posted by davidbjunk NO[at]SPAM gmail.com at 10/14/2004 9:39:03 AM
Hello, I have deployed the sample security extension and everything is working well. I am new to web services programming and am not for sure how to make an addition. We would like for requests from one ip address to be automatically logged on to reporting services. My question is how and whe...more >>

Retrieve the .rdl file from the reporting services server
Posted by akardell NO[at]SPAM home.se at 10/14/2004 9:24:17 AM
Is it possible to retrieve the ".rdl" file published on the Reporting Services server... I made a stupid mistake and renamed a report from let say a.rdl to b.rdl and started to revise the report. Then later on I needed to do some changes to the published report a.rdl... Though, this file (a.r...more >>

MSRS SP1 text field parameters
Posted by Brian Parker at 10/14/2004 9:23:02 AM
Using MSRS SP1, if you want a user to hand key in a parameter value in report manager instead of pick the string parameter value from a drop down list...how do you set this up? -thanks, brian parker...more >>

Get label from Parameter
Posted by Matt at 10/14/2004 9:12:51 AM
Hi, where a query has been provided for a parameter (to give a list of value/label pairs), is it possible to use the label value in the report? For instance, if the parameter gives a list of accounts for the user to select from keyed on Account Id with the label of the Account Name, I would ...more >>

Report moving between fields
Posted by Scott M at 10/14/2004 8:55:13 AM
I'm having a strange issue. When moving between parameter fields when viewing a report, it refreshes the report every time I move from field to field. Whether I'm moving with the tab button or just clicking in the next field. The refresh option is off. Anyone have any ideas?...more >>

data set name missing?
Posted by Matt at 10/14/2004 8:52:07 AM
Hi, I have added a paramter which takes it's values from a query. When I compile the report, I get the message The data set name is missing in the data region 'data set name'. What does this mean? thanks ...more >>

Text Box... Width
Posted by MER78 at 10/14/2004 5:51:04 AM
Since RS is building a report based on a dataset from a database... and fields in a database have precise width limits... are there ways to make sure that your text box or whatever can accommodate X characters... other than allowing the text box to wrap... or guessing what size you should make...more >>


DevelopmentNow Blog