all groups > sql server reporting services > april 2006 > threads for monday april 10
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
report subscription unable to due file write operation - even when run under local administrator ID
Posted by astro at 4/10/2006 10:20:06 PM
I'm running some VB code to fire off a report subscription that generates a
pdf file. Even when run under local admin I get a "AccessDenied" exception.
How can this be?
I setup the credentials for the report as follows:
rs.Credentials = New NetworkCredential("administrator", "mypasswo... more >>
q: formating number
Posted by JIM.H. at 4/10/2006 2:51:01 PM
How can you format number in 1,234 format without decimals in detail section
of a report... more >>
Tables with 0 Detail Rows Do not Export
Posted by JStandard at 4/10/2006 2:42:02 PM
Greetings,
I have a Report with a Table Object in it that is tied to a particular
dataset ( a query). I have a date parameter for the query, so the user can
view the dataset over different periods.
If a user runs the report and the query returns no rows, the report will
simply show a th... more >>
IE 7.0.5335.5 Beta 2 and SSRS 2000
Posted by TTU at 4/10/2006 12:57:02 PM
Hi,
I'm trying to track and issue with IE 7 and reporting services.
First off, the report export to Excel works fine using IE 6
In IE 7 when I initially generate the report from a link in our website, the
report comes up correctly, but when I attempt to export that report to xls,
PDF... more >>
Hiding Parameters
Posted by David at 4/10/2006 12:17:02 PM
I want to hide 2 of the 5 parameters in my report. I figured out how to do
this by clearing out the Prompt in the Report Parameters and by setting my
default value. When I view my report via Report Manager, the parameters are
hiden like expected. When I try to override the parameter at run ... more >>
Sorting problems
Posted by Justin30519 at 4/10/2006 12:08:02 PM
Hello. I am using DevStudio 2003 to develop a report in Reporting Services
2000. I am having a hard time getting sorting to work. When I move my mouse
over a column name, it becomes a hand to indicate that it is a link. When I
click on it, there are two problems:
1. It opens a new report in... more >>
Is there a way to subtotal or total data from subreports?
Posted by Kyle Jedrusiak at 4/10/2006 11:59:59 AM
Kyle Jedrusiak
... more >>
Finding credientials to connect to RS database
Posted by Scott M at 4/10/2006 11:50:43 AM
First of all sorry that the message is so skatty. I have a lot on my plate
right now :)
When I installed our instance of Reporting Services on our report box I
cannot remember if I rsactivate-ed and rsconfig-ed the installation with a
windows user or a DB user. I need to know b/c we rece... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Request Length Exceeded
Posted by Mark Lauser at 4/10/2006 10:43:02 AM
I am working in Visual Studio 2005. I have a Report Model project with a
data source, a data source view which contains all of the tables in my
database (SQL Server 2005), and a Report Model that contains the items that I
want the users to be able to work with.
When I deploy the project, I... more >>
Machine Rebuild - restored ReportServer database
Posted by epperlys NO[at]SPAM gmail.com at 4/10/2006 10:17:40 AM
I recently had to rebuild my local machine. As such, I backed-up all
of the relavent local databases that I needed (including the RS dbs).
After the rebuild, I have attempted to connect my new instance of RS to
a restored version of the ReportServer database. The instance
initialized after I g... more >>
Parameter in Order By?
Posted by David at 4/10/2006 9:22:02 AM
How do you pass a parameter from Reporting Services to SQL query (Dataset)
for ORDER BY clause?... more >>
Xbar Chart
Posted by John Wright at 4/10/2006 8:55:14 AM
Is is possible to create an X-Bar chart with the standard tools for
reporting services? If not, does someone know of a reporting package for
Reporting Services that does have X-bar chart abilities. Thanks.
John
... more >>
Initial Login ignores security settings
Posted by Stan at 4/10/2006 8:44:02 AM
Hi all,
have a weird one.
I'm using Reporting Services 2000 and we're on Active Directory.
I have two folders in my reports default page, “Folder 1" and "Folder 2".
Both of these contain reports. I add a new role only to Browse and view
Reports on "Folder 1". The first time the user ... more >>
ReportViewer (.NET 1.1) can't pass in the parameter...sometimes!
Posted by Roy Assaly at 4/10/2006 8:42:57 AM
Here's my problem:
I have 4 web sites in 4 environments. Let's call them A, B, C, and D.
Reporting Server is installed on A, and on another server, let us
called it Z.
There are 4 website, also installed on A, B, C, and D.
When I run the website on my localhost machine, all my paramters ... more >>
Can we build Web UIs with SSRS?
Posted by Water Cooler v2 at 4/10/2006 8:33:14 AM
If all one needs is a bunch of reports, then, instead of going the
whole hog writing a UI in a bespoke ASP.NET application, can one take
the sole refuge of SQL Server 2005 Reporting Services to do a neat UI
along with the reports?
As in, one of the parameters for a report may be a period range... more >>
Error Accessing Server Report from VS2005
Posted by Ross at 4/10/2006 8:22:55 AM
I've tried 2,505,767 things to get this to work and still can't. I
imagine there are others having a similar issue.
Get the following unhandled IOE from Visual Studio using a ReportViewer
control on a Server Report:
Client found response content type of '', but expected 'text/xml', The
req... more >>
Formatting a textbox
Posted by E at 4/10/2006 8:14:16 AM
I need to format a phone number parameter the user enters. Currently
when I print the parameter entered it displays like this ##########. I
want to format it to look like ###-###-####. Does anyone have any
ideas for making it look like that?
... more >>
reduce the table height when NORows in table having a footer control
Posted by Rajesh.jain25 NO[at]SPAM gmail.com at 4/10/2006 8:00:53 AM
hi,
i am using two header ,three grouping level and in a table and there is
a one Report Footer in report.
when there is no data present then the report hide all groups and
Detail rows but the Report Footer still remains at same position. i
want that the Footer should also aligned to top when t... more >>
load balanced scale out deployment issues
Posted by HC at 4/10/2006 7:06:03 AM
Hello,
I have a scale out deployment of Reporting Services consisting of 2 Report
Servers in a load balanced cluster using an F5 BigIP setup in RoundRobin
mode, and the report catalog db sits on on a separate sql server. We use a
vIP with a DNS name that hits the F5. The F5, in turn, is s... more >>
Problem with using report parameters in SQL query function, SSRS 2
Posted by Jouni at 4/10/2006 6:06:01 AM
Using Visual Studio to build reports for Reporting Services 2000: is it
allowed to pass a report parameter to a FUNCTION in dataset defintion. Like:
select function(@variable) from table where ..
I get "syntax error or access violation" when trying.
Regards, Jouni... more >>
Problem connecting to ReportingServices (SQL2005)
Posted by Nicolas Nickisch at 4/10/2006 12:00:00 AM
Hi NG,
the installation of SQL2005 went o.k.
Whenever I try to connect to the ReportingServices module using Management
Studio, I get the following error message (the original messages is in
german):
Der Server hat eine Protokollverletzung ausgeführt.. Section=ResponseHeader
Detail=Au... more >>
|