Report parameters

I have a datetime parameter. Also I have a listbox with available jobs to
report for. I want to filter the listbox on the selected date. How can I do
that? Thanksuse the date-time parmeter in the sql for the dropdownlist
"Markgoldin" wrote:
> I have a datetime parameter. Also I have a listbox with available jobs to
> report for. I want to filter the listbox on the selected date. How can I do
> that? Thanks|||I am trying that but when I switch to preview I am getitng an error:
The report parameter â'jobâ' has a DefaultValue or a ValidValue that depends
on the report parameter â'RunDateâ'. Forward dependencies are not valid.
And here is my SQL for Job parameter:
select * from udf_GetJobs(@.RunDate)
order by job
"Antoon" wrote:
> use the date-time parmeter in the sql for the dropdownlist
> "Markgoldin" wrote:
> > I have a datetime parameter. Also I have a listbox with available jobs to
> > report for. I want to filter the listbox on the selected date. How can I do
> > that? Thanks|||Switch the order of your parameters. You can do that where it lists the
parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:A2179882-FB0F-4293-98B7-3390E07299BD@.microsoft.com...
>I am trying that but when I switch to preview I am getitng an error:
> The report parameter 'job' has a DefaultValue or a ValidValue that depends
> on the report parameter "RunDate". Forward dependencies are not valid.
> And here is my SQL for Job parameter:
> select * from udf_GetJobs(@.RunDate)
> order by job
> "Antoon" wrote:
>> use the date-time parmeter in the sql for the dropdownlist
>> "Markgoldin" wrote:
>> > I have a datetime parameter. Also I have a listbox with available jobs
>> > to
>> > report for. I want to filter the listbox on the selected date. How can
>> > I do
>> > that? Thanks

Report Pack for Reporting Services

Has anyone seen report-pack for Reporting Services? Similar to one that is
available for IIS, GPS etc.
Or other option is there any database schema description of the "ReportDB"
for Reporting Services 2005?
--
Thanks in advance - Sunil.The closest thing to a report pack for reporting services is the Report
Execution log reports. The package includes a SSIS package, DB and several
reports.
The reports included will tell you about report execution times, parameters
used, etc, etc
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/RSMnRptExPf.asp
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Sunil K" <SunilK@.discussions.microsoft.com> wrote in message
news:8650684C-FBBD-4D94-A662-CAC937654801@.microsoft.com...
> Has anyone seen report-pack for Reporting Services? Similar to one that is
> available for IIS, GPS etc.
> Or other option is there any database schema description of the "ReportDB"
> for Reporting Services 2005?
> --
> Thanks in advance - Sunil.
>

Report of Reports

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.so build a standard report that queries against the SQL Database Named
'Catalog'
-Aaron
Jim Breffni wrote:
> 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.|||It is possible to drillthrough different reports. Your 2nd and the 3rd
sentence are contradictary. correct me if I have understood wrongly..
ie. you said
in 2nd
I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line
in 3rd
Is that possible? It looks like the navigate tab can only take a
static
reference to a single report.
Amarnath
"Jim Breffni" wrote:
> 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.sql

Report Object Model?

Hi
I am looking for an object model to learn how to access report items an
conections (if available?) in code. Because the code window on report
properties is THAT programmer-friendly I have no idea where to start
accessing the items.
Thanks.
MarkusThe code window you are refering is used for writing small functions to be
used inside the report something like converting Dollar to pounds etc.
If for using connection and report items or anyother things, I suggest use
the RS web services, there are good samples available in SS online help to
start with.
Amarnath, MCTS
"MarkusPoehler" wrote:
> Hi
> I am looking for an object model to learn how to access report items an
> conections (if available?) in code. Because the code window on report
> properties is THAT programmer-friendly I have no idea where to start
> accessing the items.
> Thanks.
> Markus

Report Model Data Source other than SQL Server?

Hello, is this a true statement: "The only Data Sources available to a Report Model are SQL Server 2000, SQL Server 2005, and SQL Server Analysis Services 2005".

I had read somewhere that there was going to be an ability to specify a "custom" query processors so that you could use data sources in addition to the items listed above.

Thanks!

It is true statement in this release.
MS people may know about future releases.
Philippe

Report Manager: SHow only reports, not the stuff above?

Is it possible to add parameters to the URL for the Report Manager, to get
rid of the stuff over the available reports? Like what shows up in the RS
Web Part "Report Explorer". We're trying to view RS reports through a
HummingBird portal, and are trying out different ways of viewing RS reports.
All help appreciated!
Kaisa M. Lindahl"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:OwfmzIqwFHA.720@.TK2MSFTNGP10.phx.gbl...
> Is it possible to add parameters to the URL for the Report Manager, to get
> rid of the stuff over the available reports? Like what shows up in the RS
> Web Part "Report Explorer". We're trying to view RS reports through a
> HummingBird portal, and are trying out different ways of viewing RS
> reports.
> All help appreciated!
> Kaisa M. Lindahl
I figured it out. With Reporting Services sp 2, there's a new ListMode:
WebPartList.
So if you add ViewMode=WebPartList to your URL, you will get a nice list,
web part style.
http://localhost/Reports/Pages/Folder.aspx?ItemPath=/&viewmode=webpartlist
This means that all reports are opened in a new window, without the
navigation pane on top. Could be usefull for some scenarios.
Kaisa M. Lindahl