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 > april 2006 > threads for monday april 3

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

Fields in page header...
Posted by Pradeep at 4/3/2006 6:00:05 PM
Hello, In my sales quotation report, I need to display the name of the customer on every page of the report. The customer name is passed as a data source. However, Reporting Services does not let you apply dataset fields in a page header. >From googling, it seems this is a common problem t...more >>

Subscribe a report with Include Report option fail.
Posted by Terrence Chan at 4/3/2006 4:32:02 PM
What I am trying to do is subscribe a report and send it as Excel. I created two users under my SQL Server 2005. They both got sysadmin privilege in SQL server. 1) user1 2) mydomain\user1 I have tried to use each of them and still getting different error messages. Test1 ====...more >>

How can I send the report to printer directly?
Posted by Manda Ho at 4/3/2006 4:01:08 PM
I preview the report by URL, but I'd like to know how can I send the report to printer directly without preview? Thanks! ...more >>

Performance Benefits of Using Multiple Servers
Posted by blabore at 4/3/2006 3:14:02 PM
My SQL Database and Reporting service are installed on the same server. I've noticed that occasionally, the server gets pretty sluggish, which is likely from reports being run. I have another server available which isn't really being used much. Would there be any significant performance benefi...more >>

Is it possible to custom format the parameter dropdownlist?
Posted by ReportDesigner at 4/3/2006 2:41:46 PM
I have a reporting services 2000 report that has only one string report parameter with a prompt 'Select a Project'. The project list contains project names that are so long that they take up about 95% of the page width and the View report button becomes a partially visible button with a horizon...more >>

Accessing table cell
Posted by appu at 4/3/2006 2:24:09 PM
I have a simple table that has a couple of fixed number of columns and the rows are populated from the database. I have a need to get the value from the cell which i know will always be the second column and third row. Is there a way to access that cell by maybe using indexes or is this even p...more >>

will Report Services for sqlsvr2k work on .Net Framework 2.0?
Posted by Rich at 4/3/2006 2:18:02 PM
Hello, We are using VS2005 (and VS2003) at my place with sql server 2000. All the workstations have .Net Framework 2.0, but the server is still on .Net framework 1.1. Reporting services is working fine so far from VS2003 and the server on .Net Framework 1.1. The only thing that isn't wo...more >>

Formatting a Text box
Posted by E at 4/3/2006 1:50:04 PM
I need to format a phone number parameter the user enters. Currently when I print the parameter it displays like this ##########. I want to format it to look like ###-###-####. It can't be done with SQL, it must be done in the VB of that textbox. Does anyone have any ideas?? It would save ...more >>



Hidden parameter
Posted by Markgoldin at 4/3/2006 12:47:02 PM
I am trying to set one of report parameters to hidden. When I run the report I am getting an error that the hdden parameter is missing a value. Can someone help?...more >>

Missing Borders
Posted by Patrix317 at 4/3/2006 12:37:03 PM
Hi, All! I've searched through this group and cannot find a similar question. I have a very simple report that I need to draw borders in the cells. For example, a box around the entire report in the page or a line that goes across the middle. However, when I do a print preview, I can see...more >>

adding various fonts/weights to values in a string
Posted by Susan R at 4/3/2006 12:34:03 PM
HI I am creating a form that needs to have strings of text in the text box. The strings have numbers included and the numbers need to be a different font. The form is built in a table, so splitting the row will not work. Example: Textbox 10 has the following value: 8. Fax Number ...more >>

visibility of an image
Posted by JIM.H. at 4/3/2006 11:53:02 AM
I was trying to make visibility of an image in the header true or false as shown below. =IIF(Fields!HeaderOnOff.Value = 0,true,false) It seems in the heather I could not use a database field. Is there anyway I can accomplish what I need? ...more >>

Page Breaks
Posted by David at 4/3/2006 11:45:02 AM
I want to force a page break at the end of a page at a logical place. How can I do this?...more >>

Visibility Formula in a Matrix Report?
Posted by _Stephen at 4/3/2006 10:18:16 AM
How do I compare columns values in the report? The Dataset options in the editor show "First" I want to show only when the data's value in column 2 is > the value of column 1. = (First(Fields!status.Value, "ECDBProd") < Second(Fields!status.Value, "ECDBProd"), "true", "false") That use of...more >>

simple IIF
Posted by Suresh at 4/3/2006 6:15:01 AM
Hi, I have a field in which the data can come in as -1 or any other number >=0. In my field, I have this following expression: =iif(Fields!Feb_Result.Value,Fields!Feb_Result.Value," - ") For -1, I want an "hyphen" in the field, otherwise whatever number that comes in. The expression ...more >>


DevelopmentNow Blog