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 > march 2006 > threads for thursday march 30

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

Suppressing Lines
Posted by JustMe at 3/30/2006 10:00:12 PM
I have a report where the information is not always filled in so I want to supppress the blank lines. For example if you have Address 1 and Address 2. If you do not have information in Address 2, I want the city, state and Zip to move up a line.. So if I have both Add1 and Add2 it would look li...more >>


POPUP
Posted by Raz at 3/30/2006 2:16:01 PM
I am trying to open a popwindow from the data field in a matrix using the url below. The pop-up window opens and displays the report but the parent window/report get "[object]" displayed on it. How can I keep this from happening? ="'javascript:void(window.open('http://dev1/ReportServer?%...more >>

Landscape: Page dimensions on screen are 11x11, prints as 11x8.5
Posted by Mark S. Milley, MCAD (BinarySwitch) at 3/30/2006 12:14:29 PM
After a long struggle, I was finally able to print out landscape (11x8.5) reports; however, when the report is displayed on screen, it's displayed as (approximately) 11x11. This really screws up page numbers--the number of pages on screen is less than the number of printed pages, so if someone i...more >>

Printing Error
Posted by Jeffrey Jones at 3/30/2006 12:13:59 PM
Hello All, One of my clients is having an issue printing a report using the print button on the report viewer. The exact behavior: once the user presses the print button, nothing happens except showing a broken script error in the lower left-hand corner of the screen. When I click on the er...more >>

Unistalling SQL 2005 Reporting Services?
Posted by BATMAN at 3/30/2006 11:25:52 AM
How do you go about uninstalling SQL 2005 Reporting Services? Do you have to uninstall the entire instance or can you just uninstall the Reporting Services components?...more >>

Printer Icon Missing in RS2000
Posted by BrettVP at 3/30/2006 10:55:02 AM
I have to RS servers (1 test, 1 prod). If I view a report from the TEST server I have a Printer Icon available and can print with no issues (therefore the activeX control [RSClientPrint] is installed and working correctly thru my browser). When accessing a report (same report) on my PROD s...more >>

Exporting to Multiple Excel worksheets
Posted by ironryan77 NO[at]SPAM gmail.com at 3/30/2006 10:29:17 AM
I am having trouble exporting my SRS data to multiple Excel worksheets. I have four tables. I want each of these tables to appear on a different worksheet even if there is no data for it. For one of my queries, there was only data for 3 of these tables. First I selected "Insert a Page Break ...more >>

Excel Drill Down not showing all details
Posted by dachrist at 3/30/2006 8:21:01 AM
In my report, I have one group and details. The group has two rows, with the 2nd row's visibility toggled by one of the textboxes in the first row. The detail row is also toggled by the texbox in the top group row. (the second row of the group has the titles above the detail row). Anyways,...more >>



get rid of repeating text in (report descrition)textboxes in csv
Posted by msdnuser at 3/30/2006 7:53:03 AM
Hi All, We have to export our Reporting Services reports developed using Reporting Services 2005 RTM to CSV format. We are converting to ASCII Encoding and hence CSV export comes out good but we still have a flaw. We have some descriptive text in the textboxes above the table with data in t...more >>

parsing out duplicate data in fields
Posted by Steve at 3/30/2006 7:49:03 AM
I have an issue where one of the fields in my report concatenates to contents of the previous record into it - this is a limitation of the database where the data resides. I want to remove the duplicate data, and I want to find out if this can be done using RS or if I will need to write curs...more >>

Customizing colors in Reporting Services
Posted by jdyer521 NO[at]SPAM hotmail.com at 3/30/2006 7:09:17 AM
Hello. I have a textbox in which I want to customize the color of the text. When you go to Properties->Color, the pull-down lets you choose from a pre-defined list of colors by name (Black, DimGray, Gray, etc.) You can also enter an expression. What I want to do is customize a color that is diff...more >>

Show time as hours and minute
Posted by Markgoldin at 3/30/2006 6:24:02 AM
I have a textbox where I am showing time as a result of T1 - T2. The result comes in hours, minuts, and seconds. How can I show it as nn hours, mm minutes and no seconds? Thanks...more >>

RS 2000 Enabling Client Side Printing
Posted by DotNetNow at 3/30/2006 6:06:02 AM
Can sombody send me instructions (screen shots of what this looks like) of how to get to Management Studio (refered in the instructions below) to do the following: Report server administrators have the option of disabling the print feature by setting the report server system property Enable...more >>

help!!...sp1 or sp2
Posted by bevarg at 3/30/2006 6:05:03 AM
After I install SP1 of SP2 for reporting services, I get the following error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.54'. The expected version is 'C.0.6.43'. To continue, update the version of the r...more >>

Report Parameter Display Problem
Posted by Alp Eren at 3/30/2006 1:28:22 AM
Hi, I am developing several reports, I want to pass one parameter from Report1 to Report2 and also make the same parameter selectable on Report2. However I figured out that if I pass the parameter from Report1 to Report2 and Report2 has the same report parameter, then the parameter bar on the t...more >>

URGENT: Error while executing the report
Posted by preeth at 3/30/2006 12:24:29 AM
Hi, Please Help........ Im having problem with report creation.I tried creating a report with the Stored Procedure and its gives me the following error. "An error occured while retriving parameters in the query DeriveParameters requires an open and available connection.The connections current...more >>

Iff OtherValue = 0 then MyFont = Bold
Posted by Pieter Coucke at 3/30/2006 12:00:00 AM
Hi, For one of my reports I should have a given field getting a Bold font, when another value in the DataSet = 0 (or whatever value). How can I set the Font/Bold-proeprty at runtime? Via an expression? Thanks a lot, Pieter ...more >>


DevelopmentNow Blog