all groups > sql server reporting services > november 2004 > threads for wednesday november 3
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
Errow whilst initializing report server!!!
Posted by Jared Smith via SQLMonster.com at 11/3/2004 8:55:01 PM
I have an urgent problem which I hope someone can help me with.
After installation, I was told by the wizard that I needed to initialize the report server manually...
So I went to:
http://uacl-sql2/reports
It redirects to:
http://uacl-sql2/reports/Pages/Folder.aspx
And I get the foll... more >>
Problem on hiding toolbar when report is being rendered
Posted by Randy Gadingan at 11/3/2004 7:28:02 PM
I'm using url access to preview report and added a rc:Toolbar=false. When I
preview the report, the toolbar still shows. Please help.
... more >>
Error when installing Reporting Services in Virtual PC 2004
Posted by Randy Gadingan at 11/3/2004 7:23:02 PM
When I tried installing Reporting Services in Windows Server 2003 under
Virtual PC 2004 it displays a message "Error!". I have already installed
VS.NET 2003 and SQL Server 2000 with SP3. Please help. ... more >>
Change style for HTML Viewer - toolbar
Posted by Pendula at 11/3/2004 5:58:01 PM
Hi,
Is it possible to change properties such background colour for HTML viewer –
toolbar?
I just want co customise report ‘s look to match our application’s style
where report is displayed (we use frames).
Thanks
... more >>
Setting a parameterValue to Null
Posted by David V at 11/3/2004 5:06:02 PM
I trying to render a report via a web service, and I am unable to set one of
the parameterValues to Null. I've try setting it to Nothing, "Null" and and
an empty string, but nothing seems to work. Does anyone have any suggestions.
David V... more >>
Reporting Services vs Crystal Enterprise
Posted by Sergio Florez M. at 11/3/2004 4:58:33 PM
Is there an article or web page that gives a good detailed comparison of
Reporting Services and Crystal Enterprise? I need some info on this subject
and couldn't find anything on the web other than a comparison table in a ppt
called "SQL Server 2000 Reporting Services For The Impatient" by Kent
... more >>
Report Losses dynamic text formats when export to PDF/Excel.
Posted by Samuel at 11/3/2004 4:43:02 PM
Hi,
Actually I have to dynamically format a text box in a report based on a
database field value. For this I put the following formula in the FontWeight
property of the textbox.
=IIf( Fields!DisplayBitMask.Value AND 2, "Bold", "Normal" ).
This works fine for online view (HTML) howev... more >>
Moving Report Manager
Posted by dachrist at 11/3/2004 4:43:02 PM
I need to move the report manager from one computer to another computer.
Currently the RS database is on a db server, separate from the report
manager. This will stay the same. I need to know what the steps are for
moving the Report Manager to this new server, and keep all my
folders/sche... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Reporting service Installation issues
Posted by andreab at 11/3/2004 3:48:19 PM
Dear all,
i need some help with this problem: i'm trying to install Reporting Services
on a win2k IIS
server and when it asks me the istance of MSSQL i specify SQL login Account,
I insert the sa account with its password.
I received the following message:
"Login failed for user '(null)'. Reaso... more >>
Need help to format matrix report, please
Posted by Kaisa M. Lindahl at 11/3/2004 2:18:59 PM
Hello all.
I have a report showing hours registered for customer and projects, with the
following layout:
Hours registered Amount
+ Hours this period - Customer Project 5
500
Project
2 ... more >>
Error: Subreport could not be shown.
Posted by Microsoft PrivateNews at 11/3/2004 1:51:10 PM
Does anyone have an idea what would cause this error when viewing this in
Report Manager or thru a subscription to be rendered as a PDF attachment?
Subreports view fine through Visual Studio .NET Report project.
Thanks in advance.
... more >>
Running a Stored procedure or a query
Posted by TA at 11/3/2004 12:40:03 PM
Hi Guys
I woud like to run either a stored procedure before runing the actual
report. The stored procedure will create and update a table and on the second
run the report query will run and produce the report.
Is it possible to achieve this?
Regards
Tofigh... more >>
temp tables in SP ? it is bug of RS?
Posted by Ing. Branislav Gerzo at 11/3/2004 12:27:29 PM
Hi pals,
my whole work stops on this problem. I have to join some
results of my stored procedures, so I can't use @table_variable (or don't
know how)
This definitely should work in RS, I really don't know what's going there
(maybe some security issues, or what?):
I tried #temp_table - ... more >>
Multiple select in 2005 Beta 2
Posted by chicagoclone at 11/3/2004 12:13:01 PM
I have heard that the ability to do multi-selects (selecting multiple records
in a drop down prompt) would be possible in the 2005 version of ssas. I have
the Beta 2 version and still do not think it is possible. Any help would be
greatly appreciated.... more >>
Subreport and paging
Posted by dp at 11/3/2004 11:44:04 AM
I am getting an "An unexpected error occurred in Report Processing" error
when attempting to navigate to the next page in a report. The first page of
the report comes up in the browser OK but produces the error when clicking on
the "next" arrow. The main report uses a subreport that accepts ... more >>
Documentation
Posted by MFRASER at 11/3/2004 11:25:21 AM
Where can I get documentation on the reporting services? How can I find out
if I have this installed on my server?
... more >>
maximum limit on results
Posted by Andy S. at 11/3/2004 11:18:47 AM
Is there a maximum limit on results returned? I didn't think so, but I'm
seeing only ~3000 rows of a 100,000+ row table in my report.
... more >>
Max # of columns in Excel Export
Posted by david boardman at 11/3/2004 10:44:16 AM
I am exporting a report which consists of one simple table. The data is
simply exported to excel.
I am noticing that if I add more than 65 columns to the report (i.e. 66 or
more) then, after exporting to excel, there is a problem re-sizing the
columns in excel. For some reason the data ... more >>
404 on Report Manager
Posted by at 11/3/2004 10:05:43 AM
My report server has been in operation for 2 months now and my report
distribution portion works fine. But yesterday I started getting this
message "The request failed with HTTP status 404: Object Not Found." on my
report manager.
1. Any ideas how to fix it.
2. If it is a reinstall how do I s... more >>
Installation Problem. Please Help.
Posted by David at 11/3/2004 9:13:26 AM
We are having issues installing Reporting Services on a Windows 2000 server
with SP4. The database is located on a separate server and is also running
Windows 2000 with SP4. At the end of the installation a warning is displayed
that says "Setup could not initialize the report server. you mus... more >>
HELP! Report Parameters not working.
Posted by cmcdavid at 11/3/2004 8:54:04 AM
I bought a book, seems good, on Reporting Services. Since I am new to this
all, I am on the uphill learning curve. I have a dataset I created and added
parameters. After trying to run the report with the new parameters, I always
get the same error, "The report parameter ‘SystemName’ has... more >>
Question: 2 decimals
Posted by JIM.H. at 11/3/2004 7:59:03 AM
Hello,
I have a number column and I need to show it with 2 decimals, how can I do
that?
Thanks,
Jim... more >>
Format input of date parameter
Posted by Viola at 11/3/2004 7:58:05 AM
I have a report with a datetime parameter. The report users need to be able
to input the date in the format dd/mm/yyyy istead of mm/dd/yyyy. Does anyone
know how this can be done?
Thanks
Viola... more >>
Subscription cannot be created ....
Posted by James at 11/3/2004 7:55:02 AM
...because the credentials used to run the report are not stored, the report
is using user-defined values, or if a linked report....
This is not the first subscription with a parameterized report that I'm
creating, and I cannot figure out why this particular report cannot be
subscribed to:
... more >>
Report Layout depending on Rendering Format
Posted by Niklas at 11/3/2004 7:27:04 AM
Can I vary the layout (visibility) depending on the rendering format?
Example: If 'PDF' add a title page, if 'HTML' no title page.
Thanks... more >>
filtering
Posted by Soan at 11/3/2004 3:54:01 AM
i want to filter one dataset.
So i created a filter:
CDEC(Fields!Open.Value) >= CDEC(iif( Parameters!Value_Min.Value,
Parameters!Value_Min.Value, -10000000))
it seems to work in preview but just there.
Does anyone has an idea... more >>
Hide Toolbar does not work
Posted by Manfred Salomon at 11/3/2004 2:23:01 AM
Hello everybody,
trying to hide toolbar.
&rs:Command=Render&rc:Toolbar=false not works, nothing happens
I tried serveral variations of commands.
It looks like the reporting server ignore any aditional command in browser.
All other things works fine.
What can I do?
Manfred
... more >>
Installation Reporting services on SQL fail-over cluster
Posted by Martijn at 11/3/2004 1:13:03 AM
Hi,
Perhaps a simple question, but I could not find a clear answer in the
deployment guide. I want to install SQL Reporting Services on a SQL fail over
cluster to be used for MOM Reporting. I was wondering where to run the set up
for SRS. Do I run it on the Virtual server or on one (or both... more >>
|