all groups > sql server reporting services > april 2005 > threads for wednesday april 6
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 Server Installation Issue
Posted by ejswanson at 4/6/2005 5:15:02 PM
Hi,
I followed the article, here is the error I am still recieving:
Server Error in '/REPORTSERVER' Application.
--------------------------------------------------------------------------------
Security Exception
Description: The application attempted to perform an operation not allowed ... more >>
Access denied reports on http://localhost/Reports/
Posted by culam at 4/6/2005 3:55:03 PM
When I access report on:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fWebCast1%2fLoanMatrix
I got error as follow:
You are not authorized to view this page
But I could acess report on http://localhost/ReportServer OK.
Notes: After everything installed, we changed the computer n... more >>
Hiding a row in a table based on whether another row is hidden
Posted by PD at 4/6/2005 2:59:10 PM
Is it possible to determine whether or not another row in a table is visible?
The example is in a multiple detail row table, where I want to display a
'header' row (really just another detail row), if any of the other detail
rows in the 'section' are visible. Is there some syntax like
Repo... more >>
Can't deliver reports in Web Archive format
Posted by spp at 4/6/2005 2:35:30 PM
I can't deliver reports in web archive format using subscriptions.
If I choose to send only the link it's working.
I used to have SP1 for Reporting Services but I was forced to unintall it
because I am using Romanian lang for my reports and all reports with date
fields where not working when I... more >>
Delivering expanded reports using Report Manager scheduling
Posted by David Swanson at 4/6/2005 2:31:04 PM
I have a report that in its default state has detail rows hidden. You click
the little plus sign and they are visible as expected.
The problem is that if you schedule this report, the report is delivered
unexpanded which is of very little use for this particular report. Is there
a way to ... more >>
How to get non-html format data to open in a new window
Posted by lisa.bogart NO[at]SPAM eds.com at 4/6/2005 2:08:52 PM
I am totally new to reporting services and am struggling with how to
accomplish something. I have an aspx page that needs to display the
html format version of a report on the bottom portion of the page and
then provide a drop down list from which the user can select another
format and an expor... more >>
Stacked Bar Chart - Making first stack not appear
Posted by deniseamat at 4/6/2005 1:57:03 PM
I have a stacked bar chart. I have 2 values. My data looks like:
VehicleID: 110
Total Hours: 10
Start Hour: 7
My Y axis is 0-23, which represent hours of the day. So what i'm trying to
do is start my bar at 7 and go out 10 hours. i didn't see a way to do that.
So I thought as a work around, ... more >>
RENDERSTREAM - What am I doing wrong?
Posted by IraD at 4/6/2005 1:45:02 PM
I'm writing my own app that calls the RS Web Service.
So far, pretty good, but I can't seem to make RENDERSTREAM Work.
Do you have any idea what is wrong with this code?
The error I get is that RenderStream can not find the stream....
RenderedReport = myReportService.Render
(myReport, Forma... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Even driven Scheduling of report
Posted by Ramdas at 4/6/2005 12:39:06 PM
I would like to run a data driven scheduled report based on an event that
happened outside reporting services. How to achieve this?
I would like to use some kind of batch program or exe that i can run in my
DTS package that could trigger the Schedule.
Any suggessions welcome.
Thanks
Ram... more >>
new to put the parameter in report
Posted by chad at 4/6/2005 12:35:05 PM
Have a report with two datasets. One has the list for the parameter
(salesperson_list). The other is a grouped by age / count result that
populates the table in the report.
Age Group Count
0 - 9 2344
10 - 19 588
etc...
How do I put the parameter ... more >>
ReportDesigner.config wrong?
Posted by MJ Taft at 4/6/2005 12:21:04 PM
according to what I read, in order to enable custom assemblies you have to
enable them by changing the ReportDesigner.config setting which by default is
disabled? I looked in my config file which was installed with whatever
defaults because I didnt change anything - I dont see the section in ... more >>
subscriptions/schedules don't run at all, why?
Posted by SteveM at 4/6/2005 11:59:24 AM
I have a number of subscriptions and shared schedules that I set up as a
test, but none ever run. Can anyone give me a potential clue as to why?
For instance, I set up the shared schedules to a date/time a few minutes
into the future, and the "Shared Schedules" page lists the proper date/tim... more >>
Stored Proc parameter name change leads to duplicate variables
Posted by twbanks at 4/6/2005 11:48:06 AM
When I changed the parameter variable names in my stored procedure that
is my data source, upon going to preview in Visual Studio, it asks for
both the old and new parameters, and will not preview unless all are
filled out. How do I remove the old ones?
Thanks,
Trevor
... more >>
Rendering Extensions
Posted by Deyvisson Oliveira at 4/6/2005 11:27:01 AM
Hello everybody,
I need to render my report in a MSWord .doc format, but the default
rendering options are only HTML, Excel, Web Archive, PDF, TIFF, CSV and XML.
How can I export it to .doc, is there any extension available from Microsoft?
The SQL Server Reporting Services SP1 has this extens... more >>
Running reports over the Internet for Anonymous Users
Posted by Nate Dogg at 4/6/2005 10:07:02 AM
I need to have reports available to Internet Users but I keep running into
permission problems. I have links to the reports that will allow the user to
download the report in PDF form. However it asks them to login. I do not
have AD accounts for these users. They are just logged into my we... more >>
URGENT!!!!!! Sarbanes-Oxley says we can't use SA to pass to serve
Posted by Erin at 4/6/2005 9:39:08 AM
Our DBA's have to restrict all SA access. We set up a new sqlrptsvr user
which has dbowner to both report server and report temp. We used rsconfig to
set the userid to sqlrptsvr / password.
I ran iisreset and refreshed the sites. We still get an error of not being
able to connect to the da... more >>
How to change SMTP server after installation
Posted by dean at 4/6/2005 9:21:02 AM
How do you change the SMTP server in Reporting Services after installation
is complete?
Thanks
Dean
... more >>
Export to Excel with Mutiple Sheets
Posted by Nat at 4/6/2005 8:37:06 AM
Hi,
I have encountered this problem of not being able to export my different sub
reports to individual work sheets within excel. I have tried to put Page
breaks after each table, as this is all the sub reports contain. Thus after
each table a page break is inserted. If I preview the Report,... more >>
Change the default navigation bar
Posted by Bryan Avery at 4/6/2005 7:34:24 AM
Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.
... more >>
SRS Service pack 2.0
Posted by Ajay Kumar at 4/6/2005 7:31:09 AM
Hi All,
Can any one tell me the tentative date for Relese of SRS Service Pack 2.0
Beta version.
As i have to release product which is dependent on the Release of SRS
service Pack 2.0 .
Pls update me .
Thanks in advance
Ajay kumar... more >>
SRS Service Pack 2.0
Posted by Ajay Kumar at 4/6/2005 7:27:05 AM
Hi All,
Can any one tell me the Tentative release date for SRS service pack 2.0
This is urgent as i have to release a product base on the release of SRS
Service Pack 2.0 beta version.
Please help
Thanks,
Ajay kumar... more >>
Connection error after copying an rdl
Posted by Jody Z at 4/6/2005 7:23:04 AM
Whenever I make a copy of an existing report (.rdl) in order to use it as a
template for a new report, I get the following error message when I try to
preview it:
An error has occurred during report processing.
Cannot create a connection to data source 'Prospect'
Login failed for user '(nul... more >>
Using Passport Authentication.
Posted by Ajay Kumar at 4/6/2005 7:09:01 AM
Hi All,
I have created reports and deployed to reporting server. The Report
Server is using Anonymous Acess for Internet Access.
Now i had a complain from my client that reports is acessiable from any
where and they want to Lock down the access to all users who doesn't use the
tool... more >>
Store Procs, Temp Tables
Posted by Vanessa at 4/6/2005 4:07:02 AM
Can one run either of these from RS?... more >>
Summing distinct values...
Posted by Vanessa at 4/6/2005 4:05:07 AM
Is there a way of doing this in RS?... more >>
FileShareDelivery Problem - String not a valid boolean
Posted by Dhericean at 4/6/2005 3:19:01 AM
I have a data driven subscription for FileShare delivery. The query supplies
all but the UserID, Password, and Write Mode. The test should run 10 reports
but when it executes I get (eventually):
- Done: 10 processed of 10 total; 10 errors.
The ReportServerService_<date>.log file contain... more >>
|