Groups | Blog | Home


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 > february 2005 > threads for tuesday february 22

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

Fields List in designer not getting populated
Posted by srinivas at 2/22/2005 6:43:05 PM
Hi everyone, I'm facing a weird problem in Reporting services. I've worked on reports and everything went successfully. But now when I try to change the layout of the reprots, I'm not able to see the Fields in the fields panel. When seen in the Data view Tab, I could able to get the da...more >>


Error accessing report
Posted by shahab at 2/22/2005 6:17:02 PM
I am trying to use the render webmothod to render the report in PDF..I have forms based authentication in place. The follwoing code is mainly to get rid of open save dialog box when the report is running in a webbrowser. The follwing is the code: ===============================================...more >>

Report Viewer and FireFox 1.0
Posted by James Woo via SQLMonster.com at 2/22/2005 3:49:16 PM
I have a report and added the RS report viewer as a control. when I run the Asp.net pasge I created in IE 6.0 I have no problem seeing the report, However When using Firefox, the RS report viewer control looks way distorted!! Is anyone aware of this problem or am I doing anything wrong. Most of ...more >>

Display Red, or Yellow or Green ".GIFs" based on a field value in RS!
Posted by James Woo via SQLMonster.com at 2/22/2005 3:33:22 PM
Have a report in RS as follows: New ATMs Locations Hardware Software Installation Overall "Dallas" 40% 80% 90% | 70% "Houston" 20% 70% 85% | 58% "Austin" 60% 60% 90% | 70% "...more >>

Date Format problem for drill down
Posted by Harry at 2/22/2005 3:17:08 PM
Please help me. I have two reports(lets say Report1 and Report2) and both have filter parameters as start date and end date. Report1 has drilldown ability and opens up Report2 using date parameters from Report1. Upto here it works fine no problems with date format because when I pass dat...more >>

Toolbox grayed out
Posted by Jerry at 2/22/2005 2:53:05 PM
I have a report to which I want to add a text box but the toolbox is grayed out. Anyone have any ideas as to why? Thanks, -- Jerry...more >>

setting up a parameterized subscription
Posted by Aaronous at 2/22/2005 2:50:22 PM
HELP!! I asked this earlier but got no response. I am adding some additional detail in hopes that someone would have an idea how to do this. I have a report that I just created that is supposed to show information about the number of calls that individual sales people have made each month ...more >>

Error in FormAuthentication
Posted by simmi at 2/22/2005 2:31:04 PM
I'm using Microsoft Forms Authentication sample to implement custom security extension. Everything works fine except the following: (1) After i registerd the user ,i cannot log into the Report Manager.It is saying like "The request failed with HTTP status 401: Access Denied." (2) Bu...more >>



conditional color property based on date
Posted by ladydi_1226 at 2/22/2005 2:19:03 PM
I want to use an IIF statement to set the color property for a text box. Here is my code that is not working: =IIf(DateAdd('m', -6, Fields!Orig_expireDate.Value) < Now(), "red", "black")...more >>

Install Error
Posted by Pandi at 2/22/2005 2:17:03 PM
Hello, I'm trying to install report services on windows 2003 server. I'm getting this error message "System Check Results IIS is wither not installed or not configured for a server componenet installation." I already registed using aspnet_regiis –i this command and also given read-w...more >>

Expand/collapse view on Report Viewer
Posted by TechnoSpyke at 2/22/2005 1:54:16 PM
The expand +/collapse - view does not work on reports viewed using the ReportViewer.dll (MS example). Any tips/help would be greatly appreciated. Thank you. Marlon ...more >>

RS Backup
Posted by A.M at 2/22/2005 1:52:47 PM
Hi, I have SQL Reporting Services SP1 standard edition and I am trying to develop a disaster recovery process. The challange that I have is I don't know how to restore a new server using exsting backup. The Reporting Services installation program always try to create a new database. How can...more >>

DATABASEPROPERTYEX is not a recognized function name?
Posted by Luis Esteban Valencia at 2/22/2005 12:44:32 PM
Hi, I just made a report with the wizard when I swith to preview I got that message and I cant see my report. Thanks in advance -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIEMBRO ACTIVO DE ALIANZADEV http://spaces.msn.com/members/extremed/ ...more >>

Reportviewer and Treeview control help needed
Posted by RemoteDeploy at 2/22/2005 12:33:53 PM
hello i have been trying to use a treeview control to provide navigation for the reports. but when i click a report in the treeview, it renders on the whole page instead of rendering in in a table where I have the reportviewer control. basically i am not able to connect the reportviewer to t...more >>

just started - an error
Posted by Ciekawy at 2/22/2005 12:33:28 PM
Hell everybody, I have just installed Reporting Services (the server part). I did it preciously according to the instructions and completed it successfully. As a test I opened IE and prompted http://<ServerName>/Reports and I got something like that: (any help appreciated) Server Error i...more >>

Config Help for Server2003/sql2000/iis6 Reporting Services
Posted by janetb at 2/22/2005 12:19:03 PM
Newbie alert. Need some configuration help please. Have web server with 3 websites on box above with same ip using host headers (well-established sites working fine). Installed reporting services, went to one website and created virtual directories with IIS to same folder/name as items unde...more >>

Reporting Services is loosing stores credentials during connecting to Analysis Services
Posted by mkiewra NO[at]SPAM mail.fujitsu.es at 2/22/2005 10:51:57 AM
Hi, experts. I have another strange problem with Reporting Services. There are two machines: -machine A with ReportingServices +IIS but without SQL SERVER nor Analysis Services -machine B with SQL Server and Reporting Services. There is a web application in the machine A that colle...more >>

decimal precision of number output
Posted by david boardman at 2/22/2005 10:51:01 AM
I have a field on my report that is getting a number back from the supporting stored proc. This number is sometimes a whole number, sometimes a decimal number. I want the number output to have 2 decimal places, no matter what the input. I have tried the conditional formatting on the textb...more >>

Page Break at End throws unwanted additional blank page in PDF
Posted by Matt at 2/22/2005 10:49:22 AM
Hi, Originally posted as "Extra Page Break thrown in Export to PDF" - however I thought this might be misinterpreted as a page size issue. We have a report which has a group. The "Page Break at End" option is checked for the group. The report renders correctly in the report manager with t...more >>

Crump Links
Posted by Rajan at 2/22/2005 8:55:11 AM
I would like to add crump links feature to my drill down reports. Anybody has an lead on this ? Thanks for your time in advance....more >>

Handheld Devices
Posted by Steve at 2/22/2005 8:21:13 AM
Just wondering has anyone every tried viewing reports on handheld devices. I can to the report server but if the report has parameters they don't show up. Any thoughts?...more >>

RSException on Matrix report rendering to PDF
Posted by Lance at 2/22/2005 7:54:28 AM
I'm receiving the following exception (+stack trace) when trying to render to PDF, but it works fine when rendering to all other formats. Ideas? ~Lance ---- Error/Stack trace---- System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Exception of type...more >>

Calculating percent of total
Posted by Martha at 2/22/2005 7:11:04 AM
I have a table which has two groupings in it. I am subtotalling a field in each groups footer and would like to show the % to total on the first footer. Essentially, I need total qty for group 1 divided by total qty for group 2. How do I create an expression to do this? thanks! Martha...more >>

Open stream Error
Posted by Matt at 2/22/2005 6:11:02 AM
Hi Has anyone come across this error before? and if so do you know what's causing it. "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Found 1 open streams. All streams must be closed at this moment. " It occurs whe...more >>

Subscription Settings
Posted by Chris at 2/22/2005 12:00:41 AM
Can subscriptions be setup using file share and an email? Sending a confirmation to the users that the output file has been posted to a share? This setup would be setup via a data driven subscription. The database holds all information about the user and share information. As well as holds the e...more >>


DevelopmentNow Blog