all groups > sql server reporting services > november 2006 > threads for thursday november 9
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
Can't find Report Designer
Posted by Dan Cooperstock at 11/9/2006 2:04:52 PM
I think I've installed all of the required pieces (SRS, already had VS.NET
2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
appear on a menu anywhere, and the desired project type for reports doesn't
appear in VS.NET.
What might I have done wrong?
Thanks.
--... more >>
DataAdd narrowing conversion error
Posted by Debralous at 11/9/2006 12:48:37 PM
I am simply trying to take a date and add the value from another field
to it using the following expression:
=dateadd("d", " & Fields!new_tgddatefrom.Value & ",
Parameters!HolidayDate.Value)
new_tgddatefrom.Value is an int data type
HolidayDate.Value is a date
The expression works fine... more >>
Intellisense for custom assemblies?
Posted by Chris G. at 11/9/2006 12:35:02 PM
SSRS 2005
I am using a custom assembly with my reports.
When I reference my custom assembly using the =Code.<assembly reference>
syntax in the expressions in my report, Intellisense only shows the methods
(that I guess are) associated with the standard System.Object:
Equals
GetHashCode... more >>
SSRS 2005 Metadata
Posted by Terry at 11/9/2006 12:08:02 PM
In Report Manager, where is the parameterized data and/or user selections
stored?... more >>
help
Posted by Ben Watts at 11/9/2006 11:36:55 AM
When you have two parameters on a report, how do you get to where you can
choose one and not the other.
... more >>
SQLH2 Reports
Posted by shawn.dba at 11/9/2006 11:13:03 AM
Hello, and thank you for your generous time with my thread.
I'm using the SQLH2 tool to generate SQL Server health reports for my SQL
admin intranet site. I'm VERY pleased with this tool. I've been asked to
generate a new page similiar to the SQL Availability Report, but one that
shows to... more >>
Stored Procedure ------> Excel Spreadsheet
Posted by pichula at 11/9/2006 11:09:19 AM
I have a stored proc. that returns a variable number of fields and I
would like to be able to save it into an Excel spreadsheet (.xls). I
tried using reporting services but you cannot display fields (columns)
dynamically in the report (unless you have some method to hide and show
some of the col... more >>
Reporting Services Service Pack 2
Posted by gv at 11/9/2006 11:05:48 AM
Ok,
How do I get what Service Pack if any is installed for Reporting Services?
Version?
SQL query?
I see there is a Service Pack 2 for Reporting Services. Should everything be
fine with my reports after I
install this or is this going to be a mess? Break everything?
thanks
gv ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Extract Text from RDL file
Posted by rogsilver NO[at]SPAM gmail.com at 11/9/2006 11:00:09 AM
I am looking for a way to extract the text from a label into a text
file or even better an excel spreadsheet. I have messed arounf with
XQuery but have failed in achieving a clean extract.
Can anyone help that may have done this before. SSRS 2005.
Ryan
... more >>
Wake Up Reporting Services
Posted by David at 11/9/2006 9:13:02 AM
I noticed the first time I run a report after Reporting Services has
timed-out, it takes around 2 minutes for the report to run. My timeout
setting is currently set to 8 hours. I was thinking that I could add a
subscription to a report to take care of the first run of the report so when
a ... more >>
Can I handle variable columns returned from a stored procedure?
Posted by pichula at 11/9/2006 6:47:19 AM
I recently started with SQL Reporting Services. I was able to call a
report from a web page passing some parameters through the URL, then
calling a stored prcedure to get the results and rendering the results
in an Excel spreadsheet.
All that works fine. Now, my problem is that some of the fie... more >>
Order Group in specified order
Posted by JH at 11/9/2006 6:11:02 AM
Hi all,
We have recently migrated from Crystal Reports to SSRS. We are converting
all our company reports from one format to another. Some of our reports have
groupings in a specified order. When you sort order in Crystal you can select
"Specified Order" and then pick the names of the group... more >>
alter table
Posted by 00KobeBrian at 11/9/2006 12:00:00 AM
I am using MS SQL server 2005 management studio. When I go to the "script
table as", the "alter to" is grey out but the other options such as "create
to", "select to" and etc ... are all available. I already login as sa. Can
anyone please help? Thanks.
... more >>
|