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 > july 2005 > threads for wednesday july 6

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 - SQL RS SP2
Posted by שמעון פ. at 7/6/2005 10:23:02 PM
Hi, I am dealing with reports in hebrew. In my report the cells direction is RTL and right alignment . In the browser view it shows just fine - but when I try to print the report all the cells are aligned to the left - and it doesn't look good. On the other hand - if I align the cells to t...more >>


access rs reports through .aspx
Posted by Alex at 7/6/2005 7:39:01 PM
I'm not sure of what i should do to come up with a web site that allows the users to access the reports that are in my reportserver, I would like to know a step by step instructions on how to access my reports using asp.net web application. Is my problem has anything to do with configuring c...more >>

rotate the x axis labels?
Posted by Marcus K at 7/6/2005 6:36:01 PM
Is there any way to rotate the x axis labels? If I have one long value it turns all my axis labels veritcal. I would rather have them all at 45 degrees. Thanks, Marcus...more >>

Converting Integer Parameter To String!
Posted by Nitin M at 7/6/2005 5:39:10 PM
Hi, I am trying to print the value of the report parameters in the report. I want this because once I print the report I lose the parameters with with the report was run. I have a integer parameter and I am using the following expression to get the parameter's value. ="MyInt: " + Iif ...more >>

HTML4.0 Export - Paging?
Posted by Gastón Pírez at 7/6/2005 4:29:56 PM
How can i obtain the the number of pages in a report when i use the render method of the web service?. I'm using the folowing devInfo: <DeviceInfo> <Toolbar>False</Toolbar> <StartPage>4</StartPage>"; </DeviceInfo> The StartPage parameter is no working. Thanks in adva...more >>

PDF Export - fonts dont show up properly
Posted by D Witherspoon at 7/6/2005 2:42:07 PM
For example the reverse delta character (upside down triangle) (0xD1) from the Symbol font will not show up on reports exported to PDF but other characters from the Symbol font will. The reverse delta character shows up when exporting to a TIFF just fine though. Anyone seen this? or know ...more >>

SQL Bit Data Type parameters
Posted by Support Mechanic at 7/6/2005 2:19:02 PM
I am trying to use a stored procedure that is of data type of bit, however SQL Reporting Services does not have this as a valid data type. I have added the parameters to the report and have tried all the possible combinations but keep getting error about converting string to the bit datatype. ...more >>

ReportItems and Columns - URGENT!!!
Posted by DragonVic at 7/6/2005 2:06:05 PM
I have a textbox in a table with one group, I am using the Switch( ) command to get a numeric result for that textbox. at the end of the report I want to add those values for that text box. I tried using Sum(ReportItems!Textbox1.Value) but I keep getting an error, I need to do this in SRS, ...more >>



Is it possible to customize the look of the parameters form?
Posted by Jaime Stuardo at 7/6/2005 1:49:02 PM
Hi all... When a report is viewed in web browser, a parameters form appear at the top of the screen so that user can enter parameters and then press View Report. Is it possible to display a title before that form? or to customize the colors and fonts for that form? Thanks Jaime...more >>

Multi Select Parameter in RS2005
Posted by RDC at 7/6/2005 1:32:01 PM
I'm using the possibility to define some parameters of my reports having the property multi-select. On all my reports I always give information on the first page on the parameters used to generate the output. For parameters that do not have the property multi-select this works by using express...more >>

SELECT TOP @variable
Posted by agenda9533 at 7/6/2005 1:14:02 PM
I want to do something like this: SELECT TOP @variable . I've read all related topics BUT I cannot use stored procedure for this report, 'cause I do not have access to prod db, I'm just sending rdl for upload. How to make it work on dataset level or through the report layout? I know SQLServe...more >>

Obtaining SQL RSS Developer Addition
Posted by Max Tyack at 7/6/2005 10:52:02 AM
I want to install SQL Reporting Services on my laptop which has Windows XP Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003. Where can I download or obtain the install file for SQL Reporting Services Developer Edition? - Max...more >>

Deserialization failed error
Posted by DigitalVixen at 7/6/2005 10:06:03 AM
Can this be fixed by manually editing the rdl? I have tried however I receive an error stating that Parameter name: Top must be between 0 and 85.33333in, when I change it to .5in, 1.5in I get ...is not a valid value. Anyone, please help, I have created 11 pages and don't want to recreate the...more >>

Report Refresh Problem
Posted by Suresh at 7/6/2005 10:01:06 AM
Hi, I had a report wherein it was taking a single parameter value and outputting the data. In addition I pass other parameters to this report. Now the functionality is that it can take multiple values in addition to the existing params. The multiple value list is not passed into the report ...more >>

Expression for Color property
Posted by Stanley Hammer at 7/6/2005 9:35:22 AM
I keep getting a message when setting the expression for the color property. When I exit the expression builder an error message is displayed showing the expression and "not a valid color". I have tried numerous IIF but cannot get past the error. IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","R...more >>

rc:Linktargetpossible bug
Posted by MadLawt at 7/6/2005 8:35:03 AM
Hi, I have created a report that is displayed in an iframe using the rc:Linktarget to force any links within the report to open in the same frame. This works fine but when in this second report we click on a link it jumps out of the frame and loads as the whole page. Now within the first r...more >>

Multi comboboxes
Posted by Fairfield at 7/6/2005 7:59:12 AM
Hi, My instructions are to add more functionality to current reports by adding a second dropdown. The reports currently have one combobox that lists Application names. When an Application is chosen the report opens with all the data associated with that Application. Now there is a requ...more >>

Conditional Toggle ??
Posted by RP at 7/6/2005 7:54:02 AM
Hi i have a table that look something like this School Class Section studentA 1323 534543 543543 43534 studentB 657 7657567 66 9 Is there anyway i can set up the toggle for all like if there is only 1 ...more >>

Q any group or freeze function
Posted by JIM.H. at 7/6/2005 7:49:02 AM
Hello, I have a rectangle and a few textbox in it, now when I run report, the textbox goes out of rectangle, Is there any way to group and freeze? ...more >>

datasets and parameters
Posted by kowalsky at 7/6/2005 7:33:05 AM
I am trying to put up together a report with several parameters. The first parameter is independent, the second one, though depends of this first one. Is there a way to link them somehow, so that when i pick my first parameter, the second dataset I'm using for my second parameter will be popul...more >>

VS 2003 reports
Posted by jvh_bbb NO[at]SPAM yahoo.com at 7/6/2005 12:39:42 AM
I got a stupid question can anyone explain to me how to force a page break in Visual Studio reports? I'll explain what I have done I created a report with 2 ( or more ) subreports, but i am unable to let the seconde , third subreports start on a new page. Anyone a suggestion?...more >>

re: TOP QUESTION !
Posted by Jack Nielsen at 7/6/2005 12:00:00 AM
I have a problem with this because its sums up the totaldb for every line (posting), how can I make the top 5 with sum only run once and not sum up every time ? In the report group til makes a sum of whole sum for each posting making the top 5 statement wrong, I find this very difficult. I suppo...more >>

Switching Service user
Posted by Daniel Buchholz at 7/6/2005 12:00:00 AM
Hi! I am trying to switch the log on user of the Reporting Services service. Currently it is "NT AUTHORITY\NetworkService" which apparently does not have the right to send mail. But this is what we are required to do for mailing out report subscriptions. When I switch to "Local System Ac...more >>


DevelopmentNow Blog