all groups > sql server reporting services > september 2004 > threads for monday september 27
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
Advise on Forms Authentication
Posted by JiaN at 9/27/2004 9:37:03 PM
ok i am doing a system in asp.net and also using reporting services to
generate some reports for user to view.
My system consists of two parts which is the Suggestor and the Evaluator.
Firstly the suggestor will go to a aspx page whereby they can submit new
suggestions by filling up the page... more >>
Could IIS and SQL Server in two machine
Posted by ad at 9/27/2004 8:52:18 PM
I install my Reporting in a server of Sql server and IIS together.
I found the server is too busy.
Could I install reporting service in another server that without Sql server.
... more >>
Standard headers across all reports
Posted by Stuart at 9/27/2004 7:35:04 PM
Is it possible to create a user control (or some such object) that is dropped
onto all reports to provide standard consistent layout of elelments such as
headers and footers? I would like the company logo, report title, current
date etc to appear precisely the same on all reports. (Naturally ... more >>
getting data from another machine
Posted by Jasonymk at 9/27/2004 6:23:03 PM
hi all, my report server is installed in machine 1 , after i made a report
which the source is from machine 2, the broswer hanged and report the
following error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set '(myDB... more >>
Generate Executed Subscriptions Report.
Posted by Carlos E. Mosquera at 9/27/2004 4:47:03 PM
Hi
Now i need a report of executed subscriptions in specific shared schedules,
Someone have something to parse Subscriptions table or only way is consuming
webservice???
Someone have an idea???
I program a module to get subscriptions (with lastexecution, emails, report
name, etc.) b... more >>
Supress blank subscription reports
Posted by Noah Hart at 9/27/2004 4:28:13 PM
Is there a way of telling RSS to only mail reports which have data on
them? Currently, reports are delivered even if there is nothing on
them. This is causing many complaints.
Thanks,
Noah... more >>
Reporting Service ReportRendering Error
Posted by BrianDQ at 9/27/2004 4:25:03 PM
After running a report using reporting services, when trying to Export to a
..pdf format we are receiving the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Cannot find font '?'.
Has anyone experienced this problem?
... more >>
Disappearing point labels
Posted by O8 at 9/27/2004 4:18:00 PM
I have deployed a number of reports with bar charts. Most of these bar
charts have numeric point labels. On some charts the upper most and lowest
bars do not display the point labels in preview or report manager. I have
experimented with font size and style, point label position as well as char... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
impersonation / authentication
Posted by Marc Miller at 9/27/2004 4:02:29 PM
Hi,
We moved our dev work to a staging server. On the staging server
I am a Windows user and I am the Report Manager administrator.
I have impersonated my userid and password for the staging server
in a .NET web config. And have set my userid up to browse the
report in the Report Manager.... more >>
Browser Refresh
Posted by Sean Edwards at 9/27/2004 3:05:04 PM
The browser refreshes every 2 seconds when
"Render this report with the most recent data"->"Cache a temporary *" is
selected.
It also refreshes around every 30 seconds when nothing is selected. Has
anyone had an similar issue, I've done a little searching, is their a way to
disable auto-b... more >>
plus/minus icon
Posted by Emmanuel at 9/27/2004 2:18:27 PM
hi,
the plus/minus icon is showing the inverse of the current state of the group
i.e. if the group is open (meaning that the sub rows are visible) the icon
shows as plus instead of minus, and vice versa.
my report is defaulting to the hidden=false option, and probably this is
why. So how ca... more >>
user store for forms authen
Posted by jbmeeh at 9/27/2004 1:29:11 PM
I have my report server database deployed on a separate server from reporting
services. Can I deploy the forms authentication user store on the same server
as the report server database? I'm assuming that I would need to use sql
authentication to connect to the user store.... more >>
Setting Report Parameters
Posted by Lee at 9/27/2004 1:25:02 PM
I have a report parameter called "ReportDate" which is a date
1. How can I default the date to be today's date minus 1, i.e. yesterday?
2. How can I do the same with subscriptions?... more >>
The language of user interface become to English
Posted by ad at 9/27/2004 1:06:02 PM
I using a Tranditional Chinese version of Repporting Service.
The user's interface was Chinese in the pass.
But it become English today.
How can I do?
... more >>
upgrading error
Posted by ad at 9/27/2004 11:40:15 AM
Hi,
When I upgrading to sp1, it result in an error message "Can't stop W3C
service."
How can I do?
... more >>
Error clicking on My Subscriptions
Posted by Mike Kruchten at 9/27/2004 10:55:36 AM
I get the following error after clicking on My Subscriptions. There is
plenty of space on the server where RS is installed. I'm stumped where to
start looking.
Server Error in '/Reports' Application.
----------------------------------------------------------------------------
----
There ... more >>
Dynamic Parameter
Posted by SAcanuck at 9/27/2004 10:19:01 AM
I have created the following two parameters:
DateRange Parameter with available values:
1. label = today, value = 1
2. label = yesterday, value = 2
StartDate with Default Value (Non Queried) = =
iif(Parameters!PMDateRange.Value = "1",
now(),
iif(Parameters!PMDateRange.Value = "2",
Tod... more >>
Forms authentication question
Posted by j_a5 at 9/27/2004 10:07:35 AM
Hi,
The forms authentication works fine. However, after the prescribed timeout
period specified in the report server web.conifg report server autmatically
logs you off even when you are constantly using the report server.
To reproduce:
1. Set the forms auth timeout to a small number say 5 min
... more >>
CAS
Posted by Jason MacKenzie at 9/27/2004 9:59:49 AM
I'm having a difficult time wrapping my head around Code Access Security.
We have just installed Sharepoint Portal Server 2003. I have a web part that
uses the obc.net dataprovider that is causing me a security error when I try
to upload the web part.
I'm just not understanding what I need... more >>
prompted for username and password
Posted by gearoid_healy NO[at]SPAM yahoo.com at 9/27/2004 8:59:37 AM
hi,
I've a .net app written to view reports. The app is set up in iis
with the anonymous access checked and integrated windows
authentication checked for the default web site (my app - it's a
dedicated web server) and the same with the Reports and ReportServer
virtual directories within the ... more >>
Deault location for RSTempFiles
Posted by troark at 9/27/2004 8:55:48 AM
I currently have RS installed on my C: drive. Unfortunately, I did not
realize how much free space I was going to need for temp files, so now I'm
running out of space on my C: drive and RS restarts several times during a
schedule. Is it possible for me to point RSTempFiles to another drive
let... more >>
matrix problem!!!
Posted by Laura at 9/27/2004 8:47:04 AM
I created a matrix and everything looks good except that when I do a preview
the first page is ok but the second to the last pages my matrix shifts a bit
to the right. Anyone has an idea what's causing this? I can't seem to
reproduce this in my other report so I'm wondering what's up with thi... more >>
Cumulating
Posted by jcredk at 9/27/2004 8:37:10 AM
hi,
I have a table that gives me lets say : DateReachingPlace, PlaceCityName,
MilesSincePreviousPlace
How could I have a cumulative field for Mileage ?
DataSet:
17:00 Paris 5
17:30 Clichy 7
17:45 LaDefense 11
Expected report:
17:00 Paris 5 5 //(assuming it... more >>
Subscription Owner
Posted by Greg - NEOS at 9/27/2004 8:29:01 AM
Hi,
If i'm not wrong, there is no way to change a subscription's owner through
the Report Manager website.
I haven't found a way to do this programmaticaly too.
I'm actually performing this operation by updating "SUBSCRIPTIONS" table...
Is there any link to a website explaining how to easi... more >>
2nd request: group visibility issue
Posted by Stads at 9/27/2004 8:13:04 AM
Hi,
I have a report with a SP datasource. The groups have drilldown
capabilities. I have conditional expressions on groups 1 and group 2 that
when a flag in the proc is one value then something like this is displayed:
region 1
district 1
facility A data data data
facility ... more >>
not seeing fields using stored procs
Posted by Lee Hopkins at 9/27/2004 8:04:25 AM
I do not see the fields to drag them to the table when
using a stored procedure.... more >>
Getting Top 20 of multiple groups(filter for top 20)
Posted by Lee Hopkins at 9/27/2004 7:51:34 AM
I have a query that is grouped by Site, bringing back 50+
lines per site, my mgr. wants to see only the top 20 for
each is there a way to do this in the query or is there a
way to filter the report for the top 20?... more >>
Add group or user name..Bug or not?
Posted by SteffoS at 9/27/2004 7:47:02 AM
Hi.. I just want to know if anybody else has experienced this problem.
When i try to add group [xx\yyyYYYY Datakontakter] to a role on a folder the
response is "The user or group name 'xxYYYY Datakontakter' is not recognized.
(rsUnknownUserName) ". However, when it is [xx\xxxYYYY Filialchefer... more >>
Adding Values in a Text Box
Posted by TrussworksLeo at 9/27/2004 6:53:03 AM
I have multiple values in text boxes based on Summed values. I would like to
add the values that are in the text boxes. What is the ref for Boxes? I
know fields are Fields!.
Here is an example of what I am running it the text boxes. They are in the
group footer. I would like to add the... more >>
Cannot Delete or Overwrite reports
Posted by Hyper at 9/27/2004 6:23:06 AM
I cannot delete the first report I created. The Server CPU goes to 100%
utlisation and practically cripples the server (simple sql queries take
forever). Eventually the delete operation times out. I have managed to delete
other reports with success. I see some other people are having the same ... more >>
Excel rendering crash with parameters. Ok as HTML.
Posted by colin_overton NO[at]SPAM hotmail.com at 9/27/2004 4:35:52 AM
Hi,
I am trying to render report I have with a matrix on it using the web
service.
It works fine if I render to excel format with no parameters provided
to the report.
It also works fine if I use the exact same code and just change the
render format to "HTML4.0" instead of "EXCEL".
As... more >>
Export to PDF trims leading spaces
Posted by George Kousis at 9/27/2004 4:29:04 AM
Hi,
I have a simple report that displays a table with text fields. The data
source is a Stored Procedure that returns two nvarchar fields. These fields
include in some cases leading spaces, i.e. the value of the field may be:
" here is the value"
The report works fine for other f... more >>
Cannot connect to the report server db.
Posted by Veronica at 9/27/2004 2:53:01 AM
After I reboot the server, the following error message show on:
"Schedule and delivery process cannot connect to the report server
database"
Before I reboot the server, I try to set a new subscription.
I think this is boot sequence problem.
Anyone have any ideas.... more >>
Error: Key not valid for use in specified state
Posted by Virginia at 9/27/2004 12:32:18 AM
Hi there,
I got this error when I try to open report manager //
{servername}/reports.
An internal error occured on the report server. See the
error log for more details. (rsInternalError)
The server is win 2003 SP1, sql 2000 sp3 and report server
SP1
Thanks,
Virginia
... more >>
|