| Groups | Blog | Home |
|
June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
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 31 Parameters on Reporting Services 2005 REPOST Posted by Fabian von Romberg at 10/4/2006 9:12:48 PM Hi, I experiencing some problems to access the Parameters collection inside
a custom code to build a sql statement.
Below is my code (very simple):
DataSet:
=Code.SQL(Parameters)
Custom Code:
Public Function SQL(ByRef pars As Object) As String
Dim stmt as String
stmt = "SELEC...more >>
Help with Query Field Parameters Posted by Tarun Mistry at 10/4/2006 5:37:28 PM Hi everyone,
within one of my reports I would like to take an input parameter, feed this
into a dataset which is then used to populate the dataset of the query used
in the main body of the report. It won't allow me todo this, could you guys
offer any advice on how this may be possible?
E...more >>
Any easy way to create SQL on the fly with RS? Posted by antonyliu2002 NO[at]SPAM yahoo.com at 10/4/2006 4:08:38 PM I am very new to reporting services. I am using reporting services
with Visual Web Developer and my database is Oracle 10g.
I have successfully created reports using the MS reporting services.
Data were pulled out from Oracle 10g through pre-defined SQL.
I would like to display on the web a...more >>
Firefox browser support Posted by SeventhSense at 10/4/2006 3:29:01 PM Hi all,
We are trying to use SQL RS 2005 at our Company. We have a mix of MAC and
Windows users and I am trying to see whether RS 2005 can work with FireFox. I
created a simple matrix report and the rendering is quite bad, fields dont
have the right widths (IE shows correctly).
How do I...more >>
bug in focus Posted by aaron.kempf NO[at]SPAM gmail.com at 10/4/2006 1:51:45 PM so i've got 5 parameters; a couple of booleans
refer to them as
1 2
3 4
5
#2 is the date parameter.. and I keep on getting the date prompt / drop
down...
a) select value for 1, 3, 5
b) enter #2; the value 4/1/06 in the date dropdown
c) mouse focus to #4
d) hit enter when I'm ...more >>
Flash inside a report Posted by psychodad71 at 10/4/2006 1:09:45 PM Is it possible to show flash inside a report. I would like to call my report
which calls a php-Script that shows a flash animation. Then it would be
possible to use animatet charts like php/swf chart from http://www.maani.us.
psychodad
--
Message posted via SQLMonster.com
http://www.sqlm...more >>
underline with checkbox Posted by aaron.kempf NO[at]SPAM gmail.com at 10/4/2006 11:46:10 AM I was hoping to be able to use an underline to make it look like a line
with a big X on it.. I can't get it to line up.
I originally had it as an underscore, instead of space.. in this
funciton.. but I can't get it to look perfect.
=" " & IIF(Parameters!AdHoc_Check5.Value<>0, "X", " ") & "...more >>
Report of Reports Posted by Jim Breffni at 10/4/2006 11:27:02 AM I have a report listing all my available reports.
On that report I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line.
Is that possible? It looks like the navigate tab can only take a static
reference to a single report....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
HTML formatted field Posted by news.microsoft.com at 10/4/2006 11:05:05 AM I have a notes field in a database which contains notes in HTML format, is
there a way to print that while keeping the format?
I'm using SQL Server 2000 but I can change to 2005 if that would solve my
problem.
...more >>
Reporting Services 2000 Document Map Does not appear in IE7 RC1 Posted by nat.caserta NO[at]SPAM telelogic.com at 10/4/2006 10:56:39 AM Hello Microsoft,
When I installed IE7 RC1, i've noticed that the RS 2000 Document map
does not appear on the reports that I have. Is there any way to fix
this? I've tried everything that I can.
Thanks.
...more >>
Session setting in IIS.. Posted by sitexcite NO[at]SPAM hotmail.com at 10/4/2006 10:46:39 AM Guys,
I've installed Reporting Services 2005 on IIS 6.0 and WSS 2003. I've
noticed that Sessions are disabled by default in the ReportServer
virtual root in IIS.
By that I mean that in the ASP.NET tab in IIS - Session State is "Off"
(so there for its off in the ReportServer's web.config fil...more >>
Filter (Where?) in an Expression Posted by rbyers01 at 10/4/2006 10:06:02 AM I have an expression in SSRS that I need some help with. I am trying to just
filter off of a date that is passed from another expression and return all
the Db results where the date is = to the Date in the other expression.
Basically something like this
=Sum (Fields!TransactionAmount.Valu...more >>
Fixed reports in Reporting Services using SSAS Posted by sk at 10/4/2006 9:39:12 AM I am quite new with Reporting Services so appologies if I'm asking a
really simple question without relaising it.
I have a Analysis Services cube that I'm querying from Reporting
Services 2005, I'm wondering how I can create a fixed style report that
has specfic members from one dimension in o...more >>
SRS Version Query? Posted by Travich at 10/4/2006 9:01:31 AM Is there a way to query the report server to determine what version of
RS is installed? SQL Server has the @@VERSION variable, but this is
not reliable since RS 2005 can be installed on a 2000 box. Any help is
appreciated.
...more >>
Get a total on rows that are filtered using the Group Filter in a Table Posted by heyvinay NO[at]SPAM gmail.com at 10/4/2006 2:26:03 AM Is it possible to get a sub total for a Top N filter?
I've got a group that contains that contains a top N filter.
This filters properly for example, I see only 3 rows per group.
However, I cannot get a sub total for only those 3 rows. It calculates
all
of the rows with the main group.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |