Data Extension Parameters

Hi,
I've implemented a data extension to use a custom business class to return a
dataset. This all works fine but I cannot seem to get parameters working. Has
anyone got any code snippets of creating parameters and the parameters being
available at run-time & design time.
All the examples I've seen don't use parameters so any help would be much
appreciated as I've got to produce this ASAP.
RegardsHi,
OK - I've worked out how to get the parameters in designer mode via the
GetParameters method. However, how do I get the parameters that I add via the
Report Dialog in VS.NET?
I've tried passing the parameter collection object but this comes back with
no items although there is one displayed in the preview.
Regards
"MikeD" wrote:
> Hi,
> I've implemented a data extension to use a custom business class to return a
> dataset. This all works fine but I cannot seem to get parameters working. Has
> anyone got any code snippets of creating parameters and the parameters being
> available at run-time & design time.
> All the examples I've seen don't use parameters so any help would be much
> appreciated as I've got to produce this ASAP.
> Regardssql

Data Extension - Parameters ?

Hi,
I've just created a custom data extension for Reporting Services, which
works fine. Now, I want to support parameters. I correctly implemented
IDbParameter and IDbParameterCollection but they don't seem to be
called at anytime...
Any sample about implementing parameter support ?
Thanks in advance.
Best regards,
JulienNote that in order to support using parameters in your data extension (in
the report designer), you must also implement the IDbCommandAnalysis
interface, which parses the command text and returns the list of parameters
contained in the query.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1117728338.575235.15190@.g49g2000cwa.googlegroups.com...
> Hi,
> I've just created a custom data extension for Reporting Services, which
> works fine. Now, I want to support parameters. I correctly implemented
> IDbParameter and IDbParameterCollection but they don't seem to be
> called at anytime...
> Any sample about implementing parameter support ?
> Thanks in advance.
> Best regards,
> Julien
>|||Thanks, now I implemented IDbCommandAnalysis, parameters are now
correctly passed to my data extension. I thought IDbCommandAnalysis
wasn't mandatory, since it is called by the Reporting Services designer
to know which params are to be asked to the user.
Thanks,
Julien

data driven subscription not available

Hi,
I am trying to create a data driven subscription. I have stored the
credentials and custom data source in the report. My account has site
administrator and content manager permissions, yet the "New Data Driven
Subscription" button is not available. I have multiple reports like this.
Any ideas?
MarcusAre you on Enterprise Edition of Reporting Services, it's an EE only
feature.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> Hi,
> I am trying to create a data driven subscription. I have stored the
> credentials and custom data source in the report. My account has site
> administrator and content manager permissions, yet the "New Data Driven
> Subscription" button is not available. I have multiple reports like this.
> Any ideas?
> Marcus|||That explains it... Thanks!!
"Jasper Smith" wrote:
> Are you on Enterprise Edition of Reporting Services, it's an EE only
> feature.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > Hi,
> >
> > I am trying to create a data driven subscription. I have stored the
> > credentials and custom data source in the report. My account has site
> > administrator and content manager permissions, yet the "New Data Driven
> > Subscription" button is not available. I have multiple reports like this.
> >
> > Any ideas?
> >
> > Marcus
>
>|||That might explain my problem...where does it state that it's an EE only
option? The developer edition supports it as well (obviously I suppose) but I
hadn't realised it wouldn't work in production!!
"Jasper Smith" wrote:
> Are you on Enterprise Edition of Reporting Services, it's an EE only
> feature.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > Hi,
> >
> > I am trying to create a data driven subscription. I have stored the
> > credentials and custom data source in the report. My account has site
> > administrator and content manager permissions, yet the "New Data Driven
> > Subscription" button is not available. I have multiple reports like this.
> >
> > Any ideas?
> >
> > Marcus
>
>|||If you go to the SQL Server site then navigate to the reporting services page
and then find the feature compairison it is listed there.
For us the only thing we need EE for is the data driven subscriptions and I
can't get the boss to come off the hip with 10x the money for that one
feature.
I am going to try and write some code to run reports from the reporting
server using .net and sql statements.
"Paul Hasell" wrote:
> That might explain my problem...where does it state that it's an EE only
> option? The developer edition supports it as well (obviously I suppose) but I
> hadn't realised it wouldn't work in production!!
> "Jasper Smith" wrote:
> > Are you on Enterprise Edition of Reporting Services, it's an EE only
> > feature.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> > http://www.sqldbatips.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> > news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > > Hi,
> > >
> > > I am trying to create a data driven subscription. I have stored the
> > > credentials and custom data source in the report. My account has site
> > > administrator and content manager permissions, yet the "New Data Driven
> > > Subscription" button is not available. I have multiple reports like this.
> > >
> > > Any ideas?
> > >
> > > Marcus
> >
> >
> >

Dashboard Custom Report Error : The 'version_string' parameter ismissing a value

I get errors like this " Report Parameter 'sql_handle' was not found.
I can not find anything in newsgroups or web. Anyone else get this or
have an idea. Here are my install details:
Downloaded and installed Performance Dash Board
Installed setup.sql in MSDB on server to be monitored
@.@.VERSION = Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
All standard reports work just fine. These custom reports a AWESOME
and I can't wait to see them.
Thank you!
Erik
Reading instructions is always good..DUH... You have to go through the
main dash board RDL and then its all cool.
This is SOO COOL!!!!
Are there any other custom RDL files out there on websites to
download?
Erik

Dashboard Custom Report Error : The 'version_string' parameter is

I get errors like this " Report Parameter 'sql_handle' was not found.
I can not find anything in newsgroups or web. Anyone else get this or
have an idea. Here are my install details:
Downloaded and installed Performance Dash Board
Installed setup.sql in MSDB on server to be monitored
@.@.VERSION = Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
All standard reports work just fine. These custom reports a AWESOME
and I can't wait to see them.
Thank you!
ErikReading instructions is always good..DUH... You have to go through the
main dash board RDL and then its all cool.
This is SOO COOL!!!!
Are there any other custom RDL files out there on websites to
download?
Erik

Customizing the Reporting Services UI

I want to make custom changes to the Report Manager and ReportViewer (i.e.
background color, adding the customers logo, etc.). Where are the UI for
these reporting UI located.
If its not advisible to change them, I want to clone them and make my own
customized UI.On Aug 1, 1:56 pm, Mike Johnson <Mike
John...@.discussions.microsoft.com> wrote:
> I want to make custom changes to the Report Manager and ReportViewer (i.e.
> background color, adding the customers logo, etc.). Where are the UI for
> these reporting UI located.
> If its not advisible to change them, I want to clone them and make my own
> customized UI.
For the Report Manager, this link may be of assistance.
http://msdn2.microsoft.com/en-us/library/ms345247.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Customizing Report Viewer Webpart of SQL Reporting Services in integration mode in MOSS200

Hi All,
I do have a question about the report viewer web part in SharePoint 2007 /
SharePoint Services 3.0. We like to have a custom report parameter section,
is it possible to modify or extend the SharePoint Report Viewer web part? Or
do we have to create one ourselves. If so, have can we do that, how does the
webpart technically work.. I need some hints on how to start.If I wrote my
own Report Viewer webpart, how must it connect to the Report List web part
etc?
Kind regards,Petersee this at :
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
Not sure whether its has a parameter section
But this one should have at : http://aspalliance.com/729
Hope that helps
Patrick
"Peter Bons" <Peter@.giessen.nl> wrote in message
news:EE1C71F9-931C-48F8-A916-613F2AABD5C5@.microsoft.com...
> Hi All,
> I do have a question about the report viewer web part in SharePoint 2007 /
> SharePoint Services 3.0. We like to have a custom report parameter
> section, is it possible to modify or extend the SharePoint Report Viewer
> web part? Or do we have to create one ourselves. If so, have can we do
> that, how does the webpart technically work.. I need some hints on how to
> start.If I wrote my own Report Viewer webpart, how must it connect to the
> Report List web part etc?
> Kind regards,
>|||As far as I can tell, the Report Viewer web part simply creates an IFRAME
and creates a URL to render the report within it.
It implements the web part interface that allows it to accept connections
and when you connect the Report List web part to it, it gets the report name
from the Report List web part to use in creating the URL.
Creating your own Report Viewer web part should be fairly simple. You just
need to build a URL and render it in the IFRAME. There are examples of this
on the web - I think one was referenced in another post.
The options you can set in a URL can be found here:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
"Peter Bons" <Peter@.giessen.nl> wrote in message
news:EE1C71F9-931C-48F8-A916-613F2AABD5C5@.microsoft.com...
> Hi All,
> I do have a question about the report viewer web part in SharePoint 2007 /
> SharePoint Services 3.0. We like to have a custom report parameter
> section, is it possible to modify or extend the SharePoint Report Viewer
> web part? Or do we have to create one ourselves. If so, have can we do
> that, how does the webpart technically work.. I need some hints on how to
> start.If I wrote my own Report Viewer webpart, how must it connect to the
> Report List web part etc?
> Kind regards,
>