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 2005 > threads for tuesday september 27

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

Unable to preview
Posted by CSQL at 9/27/2005 8:37:05 PM
I have Reporting Services on my personal laptop with XP SP2, MS Visual Studio ..Net, and SQL Server 2000. I can start a report project, connect to server, connect to database, when it come to previewing the report in the designer, I get one of two messages: Unable to connect to datasource ...more >>

Changing the color of the series label
Posted by Todd at 9/27/2005 4:19:04 PM
I am able to change the colors of the series inside the graph, however I would like to make one data point stand out based on a parameter that is passed in. I have already set up the color schemes for the series to do this inside the chart but would like the label to make that distinction as ...more >>

Deployment: SRS2005 can use SQL2K as ReportDatabase
Posted by JDS at 9/27/2005 3:04:03 PM
Can the SQL Server 2005 Reporting Services configured to use the SQL2K Server as reporting database server? Rationale: So that I can put the 2005 reporting services in the DMZ and use exisitng sql2K server behind the DMZ to store the reporting database. Another reason is that , I don't hav...more >>

PDF Margins
Posted by Kevin Karlin at 9/27/2005 2:49:25 PM
I have searched through out this newsgroup and seen several people pose the question without response. I am trying to output some reports to PDF from the standard RS interface (http://localserver/reports/.....) The report generates a PDF perfectly except that the margins are 1 inch on each side ...more >>

Conditional Sum trouble
Posted by rs_newbie at 9/27/2005 2:35:04 PM
Can someone help me figure this out? I'm trying to total up 4 columns which have been X'd to indicate inventory types: RAWX, NSFGX, BUYX and SFGX. I've tried: =iif( Fields!RAWX.Value = "X", Sum(Fields!BKIC_PROD_AVGC.Value * Fields!BKIC_PROD_UOH.Value), 0) =iif( Fields!NSFGX.Value = "X"...more >>

Page Cannot be Displayed
Posted by Joe Hoggood at 9/27/2005 12:26:40 PM
When I try to run any of my reports from a non-domain member client PC I get "the page cannot be displayed" message. I am authenticated on the SSRS server because it lets me see the available reports but when I try to open the report it fails with this message. Any ideas? This works fine from ...more >>

ReportServer Error - Please help!
Posted by Terry at 9/27/2005 11:59:06 AM
How should I resolve the following error message when attempting to access ReportServer? (i.e. http://wardteserv/reportserver or /reports) 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.8.38'. The ex...more >>

Setting default value for a Multi-value parameter
Posted by isaak at 9/27/2005 11:22:02 AM
I want the default value for a muti-value parameter to be the equivalent of <Select All>. How can this be accomplished? Thanks in advance ...more >>



Showing custom aggregates in Group Footers
Posted by isaak at 9/27/2005 10:19:06 AM
In my group footer I want to show a string that was built by concatenating some data from individual records within a group. For example, Group 1 10 AB 20 CD 30 EF Group 1 Footer 60 for AB,CD,EF I wrote a custom code function that bui...more >>

New Installation Error
Posted by Brian Ackermann at 9/27/2005 7:22:03 AM
Hello all. After suffering a complete RAID failure, I am now tasked with the responsibility of setting up reporting services again, on a new and different machine. I had been successful getting it running last time, so I figured this wouldn't be too much problem. The installation goes fine,...more >>

Percent on a Matrix
Posted by anthonysjo at 9/27/2005 7:09:02 AM
Well, I finally got my first percentage on a Pie chart but when I went to use the same technique on a Matrix report with the Pie being created for each new row (Vice_President) then I started getting funny numbers. I think I have figured out that I need to use the IN SCOPE function but I am a...more >>

Table visibility based on expression - Bug
Posted by capricorn at 9/27/2005 6:46:11 AM
Using MS SQL Server 2000 Reporting Services: I have multiple tables on my report. Each one is visible based on report parameters. 2 of the tables had the same expression on the Table Visibility property: =IIF( Parameters!group_by.Value = 5, False, True) One of the tables appears on the re...more >>

Progress Bar in Table Cell
Posted by rSmoke at 9/27/2005 5:39:03 AM
I'm creating a report with several columns. One of which is a percentage value. The business people have asked that that column show a progress bar of sorts to give a visual indicator of the percentage complete, in addition to the textual %. I have tried to figure out how to do this in a table...more >>

Location of error log?
Posted by Nicola Jones at 9/27/2005 3:52:01 AM
Hopefully this will be a simple question. Where is the error log located? I am looking in program files\microsoft sql server\mssql\reporting services\LogFile at a file called ReportServer__09_27_2005_11_38_23.log inside that file is a message: e ERROR: Throwing Microsoft.ReportingS...more >>

Windows Authentication
Posted by Tim Poynter at 9/27/2005 2:58:04 AM
I have a report that uses the Windows Username to filter the data in the report, i.e. when a particular manager runs the report they only see the information relevant to there department. Is there a way to prompt the users for their Windows Account every time they run the report? Users are con...more >>

Calculation with Excel rendred values
Posted by Niklas at 9/27/2005 1:08:02 AM
We have a problem with Excel rendering. The target of Excel rendering should be, that end users could use the rendered values for further calculations. But, independent of the format of the values, we assigned within the report, all cells have to be converted manually after excel rendering in ...more >>

Report export to pdf
Posted by andrei at 9/27/2005 12:00:00 AM
Hi Group, We have an application that generates reports for one or more facilities selected by the user. The reports are generated in PDF format and are displayed in the browser using something similar to : report = rs.Render(...) .... Response.BinaryWrite(report) .... Most of the tim...more >>

Display Parameters/Global variables
Posted by Zean Smith at 9/27/2005 12:00:00 AM
I am trying to display this in TextBox in the Footer: This is Page =Globals!PageNumber However, it doesn't work. It only works if I remove the "This is Page". Is there any way so that I can use one text box to display both my text and the variable? Thanks. ...more >>


DevelopmentNow Blog