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 2004 > threads for tuesday august 24

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

Font Color Problem upon export to excel.
Posted by bench_five NO[at]SPAM yahoo.com at 8/24/2004 8:03:24 PM
I am implementing an expression in the color of the font I am using for a certain textbox in my report. This is the expression I am using for the color property: =IIF( Fields!Plan_Approval_Deadline_Count.Value < 0,"Red","Black"). In preview and upon viewing the report on the report manager, the ...more >>


Bug when a table is adjacent to a matrix
Posted by Michael Carr at 8/24/2004 7:21:45 PM
I am trying to create a report that has a table adjacent to a matrix, with the tops of each aligned together. I am trying to create a report where the rows of the table and the matrix "line up" with each other. I have included an example below where I have selected the customerID, orderID, and sh...more >>

Stylesheet problems
Posted by Bradley Plett at 8/24/2004 6:55:06 PM
I can't seem to get the stylesheet to work. I've followed the instructions in http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_new_url_access_parameters (and other documents like it) to the letter, and still no luck. I've tried this now on two...more >>

data processing extension sample
Posted by JL at 8/24/2004 5:43:02 PM
I'm trying to write some code to retrieve a reports list from a report folder. Is it possible to create data processing extension in old asp? Either yes or no, could someone post a link to some sample code, aspx samples would be just fine? ...more >>

Chart, drawing a line across all value for one value
Posted by Tibor Karaszi at 8/24/2004 4:37:16 PM
Can I specify an expression somewhere so a horizontal line is drawn for a particular row in the dataset? This would be easier to draw than explain, but I'll try: Imagine you have a bar chart displaying both detailed information (say sales per month for each department) and also sales per month...more >>

Page Break in Detail Section
Posted by Samuel at 8/24/2004 4:16:22 PM
Hi, How I can insert a manual page break between two Detail Rows in a Table? TIA, Samuel ...more >>

Slow PDF Rendering
Posted by dachrist at 8/24/2004 3:15:09 PM
Hello all. I have a report that consists of 10 subreports. When I run this report in Report Manager, it renders very quickly to HTML. The query itself takes less than 1 second, and the HTML render takes about 5 seconds. When I render the report to PDF, it takes approx 3.5 minutes. This is...more >>

DeviceInfo issue...
Posted by Renato Aloi at 8/24/2004 3:14:53 PM
Did anyone have problems using HTMLFragment or JavaScript element within DeviceInfo parameter? I am passing the deviceinfo parameter as below : result = rs.Render(Me._reportPath, Me._renderingFormat, Nothing, _ "<DeviceInfo><HTMLFragment>True</HTMLFragment><JavaScript>False</JavaScript> <Secti...more >>



An error occurred while attempting to verify the user. Invalid attempt to read when no data is present.
Posted by Phil Winstanley [ASP.NET MVP] at 8/24/2004 2:44:17 PM
Hi there, I've impliented my own Forms Authentication, I've got it working all bar the web service. I've added the Assemblies to the right CodeGroups as per this MSDN Article. http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/dngrfCodeAccessSecurityInSQLServer2000Reportin...more >>

UDL connections
Posted by Roberto Souza at 8/24/2004 2:11:40 PM
Hi, I'm trying to use an UDL file to make easier to manage my connections on RS like I'm using on SQL DTS packages. Problem is: RS is not reading the password stored at the UDL file. Did anybody did it with sucess? I'd like RS to read all the connection info (server, db, user and password) from ...more >>

Idea: Release Html Viewer as code sample
Posted by Ibexx at 8/24/2004 1:49:06 PM
Microsoft, Here is an idea that would greatly benefit customers of Reporting Services (RS). Release the Html Viewer (HV) code to the public as a sample application. Right now customers who want to integrate RS into web apps must either: 1) Design custom pages to gather parameter information...more >>

install of Report Designer onto a machine w/just VS 03 & VB.Net
Posted by steve at 8/24/2004 1:33:12 PM
Hi: I recently got Reporting Services and am trying to install it. Microsoft's web site says: Additional Software Required to Use Specific Features in Reporting Services a.. Microsoft Visual Studio® .NET 2003 (any edition) or the standard edition of Visual Basic® .NET, Visual C#® .NET, Vi...more >>

SP Problems
Posted by Sangfroid at 8/24/2004 11:17:52 AM
Hi I have a SP that I use for report generation. In the SP I use a temp table and I use #TrxTemp as the table name, the SP seems to be fine but in the IDE I get a message saying that #TrxTemp is not allowed. Doesnt RS allow use of #<Temp Table Name> ???? ...more >>

Error Log for Failed DataDriven Subscriptions - Where is it???
Posted by TrussworksLeo at 8/24/2004 10:13:02 AM
> First I have to say SQL reporting Services is the slickest thing since > sliced bread......If you work with reporting in Access and hit a SQL > server > MOVE to REPORTING SERIVCES.......Awesome...... > > Well now why I am here. I need to find the error log for the DataDriven > Subscrption...more >>

Render as Excel and Subreports with tables
Posted by jchanyae NO[at]SPAM hotmail.com at 8/24/2004 7:45:21 AM
Currently my reports use subreports with tables inside. The reports render correctly in PDF which is what they were designed to do. However, when I render the same reports in Excel I get the message that subreports with tables cannot be rendered to Excel. Is there a workaround for this or is t...more >>

probs w/ displaying labels on x-axis of bar graph
Posted by barmanvarn at 8/24/2004 7:42:00 AM
I'm needing to create a bar graph for a manager. The x- axis is group on 3 different fields. I've got the report created just fine, my problem is that since the lables are horizontal on the page, their being truncated. Is there any way to force the labels to print vertical? thanks...more >>

how to create / edit / modify multiple linked reports efficiently
Posted by info NO[at]SPAM vanoordt.nl at 8/24/2004 5:58:26 AM
Hi, On a given report I create linked reports with a specific parameter instantiation. This is a MSFT prescribed method to obtain the required security. This is a lot of click-work though, especially if you have a considerable number of different parameter values. I wonder: - where and ...more >>

Filter option to retrieve the top N records from an MDX query data
Posted by Lenti at 8/24/2004 3:19:01 AM
Reporting Services: Can you please tell me how do I use the filter option from the DataSource tab in order to retrieve the top N records from an MDX query dataset. I tried several ways, see below, none of them work, I keep getting the error that "cannot evaluate filterx expression/filter va...more >>

Performance Testing Using ACT
Posted by tommytan25 NO[at]SPAM yahoo.com at 8/24/2004 1:40:19 AM
I'm using MS ACT to test RS URL access performance but the results were very confusing... The parameters I used in ACT: - 500 simultaneous browser connections - .dat file containing 500 reference IDs to be append to the URL - 1 iteration to run the test My script contains a procedure that ...more >>

Reporting Service on MAC
Posted by Karine at 8/24/2004 12:29:02 AM
Is it possible to export report on a Mac ? Which configration minimum (OS, Navigator...) ? I try on a old Mac and nothing append. I can't modify parameters (in a text box). I can't export. I can only actualize the report. Can you Help me plese ? ...more >>

Customize toolbar
Posted by Karine at 8/24/2004 12:07:01 AM
I want to customize the toolbar (change color, button...). Is it possible ? How ?...more >>


DevelopmentNow Blog