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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|