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 > august 2005 > threads for wednesday august 17

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

Printing
Posted by Kerrie S via SQLMonster.com at 8/17/2005 8:33:09 PM
Hi all, After I have deployed me reports to the report manager and try to print them out regardless if I do it from the manager itself or export them to pdf or even excel, I sometimes have blank pages throughout my reports. I know if you change the margins and page format that it is suppose to...more >>


Empty Report manager page
Posted by Stijn Verrept at 8/17/2005 6:00:47 PM
When I go to http://localhost/Reports I see the page (subscription, home, ...) but I don't see any tools nor reports. I have anonymous authentication set to off in IIS for that directory, and only have integrated authentication turned on. I logged in with administrator account. Is there an...more >>

Formatting within a Textbox possible??
Posted by Arkiliknam at 8/17/2005 5:06:02 PM
Hi all. Have been coming accross this same issue more and more. I am needed to take in some HTML and print it in a TextBox so that we can render a PDF with custom formatting. Up until now, I've written some custom code that replaces known HTML tags with ascii characters or line breaks, e...more >>

OK button is not working on file upload page
Posted by Edman at 8/17/2005 4:53:01 PM
Hi everybody, I hope than somebody can help me to fix my reporting services server. I can upload reports on my reportin services server i dont know why but when i press the OK button nothings happend everything is working bit i need to to ulpload to new reports but i can't... maybe if sm...more >>

Conditional Coount
Posted by C a r l o s - A n t o n i o at 8/17/2005 4:41:55 PM
Hi, how do I condittionally count the result of a field. Like count if of something like that... thanks... ...more >>

Count Null Values
Posted by C a r l o s - A n t o n i o at 8/17/2005 4:15:54 PM
Hi How do I count Null and non null values in reporting services....???? Thanks Carlos Antonio ...more >>

Displaying the available values for a parameter from the database
Posted by pmud at 8/17/2005 2:28:03 PM
hI, My report has 4 report parameters: @manufacturer , @brand, @Start Date, @EndDate . I want the @manufacturer , @brand to hsow the drop down list with distinct values from the db. Now when in these 2 report parameters I do , Available Values as Non Queried and the Value and lable a...more >>

Problems with Custom Delivery Extension
Posted by NO[at]SPAM at 8/17/2005 12:51:06 PM
I am working on putting together a custom delivery extension (fax delivery) based on the built-in File Share delivery extension. Most of the functionality I need already exists in the File Share delivery extension so I used the Lutz Roeder's .NET Reflector to disassemble the ReportingServic...more >>



Problem Viewing reports in Report Manager
Posted by Jon at 8/17/2005 12:42:05 PM
I have successfully installed the sql server reporting services on a windows 2003 server. I have been able to deploy several reports to the report server. I have even been able to schedule a report to execute and send out via email every morning of the week. Here's the problem. When I ...more >>

Intergrating SQL Server Reporting Services into an ASP.NET app
Posted by Brendan Reynolds at 8/17/2005 11:58:51 AM
I'm trying to integrate SQL Server Reporting Services reports into an ASP.NET app (SRS 2000, ASP.NET 1.1). I know how to do this using direct URL addressing, but this exposes in the query string parameters that should not be exposed. Each user is associated with a school, and should see only...more >>

Subscription disallowed if more than one parameter
Posted by jcomba at 8/17/2005 11:48:49 AM
I'm running SR SP2 Standard Edition on Win 2003 with the DB local. It appears that I can only create subscriptions on reports that use no more than one parameter. At this piont all of my reports use the same shared data source with credentials stored in the server. All reports with 1 or 0 ...more >>

Production server error
Posted by fassmann NO[at]SPAM gmail.com at 8/17/2005 11:31:27 AM
Hello, I have reports that have embedded code from a custom assembly. In design, they work fine. When I deploy them and run them via the Report Manager on production I get the following error in the cells where I have this code running: "Error in method xxxxxx - Request for the permission of ...more >>

Allow anonymous access?
Posted by Stijn Verrept at 8/17/2005 11:23:07 AM
I've been trying with lots of different settings but to no avail. Can someone tell me what I need to do to allow everybody access to report XYZ? Both settings required on IIS and RS. Thanks in advance! Stijn Verrept....more >>

Data Set returns but Report doesn't display
Posted by patty at 8/17/2005 11:02:03 AM
I'm returning a data set from a stored procedure. When I go to preview the report I'm getting an error: An error has occured during report processing. Invalid attempt to read when no data is present. I made a minor change (added a parameter) to the stored procedure that wouldn't impact the...more >>

Request for a feature for MS Reporting Services GUI
Posted by Roy Assaly at 8/17/2005 10:39:30 AM
Dear Microsoft, You know when click "View Report" and that cute green circle comes on reassuring the user that it's working? Well I would like something similar to that for when you're selecting cascading parameters. Let's say you have Country, Province, City as parameters for a report. ...more >>

EDITING DATA when report is displayed
Posted by pmud at 8/17/2005 9:29:06 AM
Hi, Is there any way that when users view the reports, then they can also EDIT the data in the report ao that the new updated data goes back to the db ? -- pmud...more >>

VS.NET Required for Reporting Services Server install?
Posted by Budman at 8/17/2005 9:11:05 AM
When I start the install for Reporting Services Enterprise Ed. on a W2K3 server, it says I cannot proceed without first installing Visual Studio .NET. I've seen some posts that say I only need to install VB.NET, but I'm still curious as to why need to install any development tools on a server...more >>

Display RTF String
Posted by Afaq at 8/17/2005 9:05:11 AM
Hi, I have a rtf string saved in a SQL Server Db which i want to display on the report. The string is forumlated as:{\rtf1\ansi\ansicpg1252\uc1 aaa} Is this possible in SSRS? If yes then kindly provide some help on the implementation. ...more >>

limit export formats
Posted by mollyp at 8/17/2005 8:58:36 AM
Hello, I was wondering if anyone knows of a simple way to limit the formats that a user can export to (e.g. not allowing certain users to export to Excel)? Are there any permissions settings that can be altered? Thanks much, ...more >>

Distinct document map labels
Posted by Heather M at 8/17/2005 8:36:55 AM
Here is what my document map tree looks like know.... Plant 1 Product Type 1 Product Code 1 Plant 1 Product Type 2 Product Code 1 Plant 1 Product Type 2 Product Code 2 Plant 1 Product Type 2 Product Code 3 What I would like the tree to look like is....more >>

Multiple datasets
Posted by KimB at 8/17/2005 8:26:33 AM
I have an area of my report that needs multiple data sets to be used to populate the area. I keep getting the error "Report item expressions can only refer to fields wtihin the current data set scope". Does anyone know how to make the area allow me to use one data set in one row and one in dat...more >>

Error in a Sinmple Function
Posted by pmud at 8/17/2005 7:58:09 AM
Hi, I am using the following Code in the Report Properties. This function displays the manufactuere logo when brand parameter is null and when brand is not null it should display the brand logo. Function ImageDisp(byVal a as String)as String Select Case a case "" return ...more >>

A Template for Reports???
Posted by lwoodyiii at 8/17/2005 7:55:53 AM
Hi, Does anyone know how to create a template for reports that can be linked to every report. Changes in the template would then be automatically reflected in every report connected to the template. This is a similar paradigm as a css style sheet. There is a description of way to do this in "...more >>


DevelopmentNow Blog