RS/AS 2005 Reports on Cube datasource, drilldown not working

I have an AS 2005 cube created.
I am able to generate reports in RS 2005 by setting the report datasource to
point to my cube.
I have tried to setup a report to drillthrough to another report ( also
based on the same cube datasource ) via the TextBox Navigation/Jump To Report
setting.
I am able to select the report to which I need to jump. The parameters for
that report appear in the navigation setup dialog, and I am able to set the
parameter values e.g. =Fields!Product_Type.Value.
However, whenever I run the report ( in BIDS preview, via Report Manager, or
in a Report View web control ) and click the navigation text box, I always
get the message "The 'PRODUCTProductType' parameter is missing a value "
When trying to do this via a Report Viewer web control, I can look at the
parameters in the report being drilled into by examining the
DrillThroughEventArgs in my DrillThroughEventHandler of my Report Viewer web
control.
ServerReport serverReport = (ServerReport)e.Report;
ReportParameterInfoCollection parms = serverReport.GetParameters();
There are 3 parameters as expected, but for each of them, parms[i].state = "MissingValidValue"
I see that this exact same setup works when the datasource for the report is
relational, and I hope that I'm just missing something simple to make it work
when the data source is a cube.
Any help is greatly appreciated!If you are using the Analysis Services provider (the one that comes
with a UI for you to drag and drop), any query parameters are bound to
another dataset by default. The parameter value passed/received need
to be a member of the "available" list.
I got similar message ""The 'PRODUCTProductType' parameter is missing a
value " when the value is not found in the available list of values.
So, you may want to check this first?
Looking at the parameter name, its value should be of the format of
[PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
value is passed in this format.|||One more thing:
RS has the behaviour of changing the query parameter to be
"multi-valued" enabled. So you need to make sure the parameters
defined at both main and sub reports are of the same type, either both
multi-valued or both single-valued.
Multi-valued requires a different format e.g.
=Fields!Product_Type.Value(0)|||Thanks for your help, I'm getting closer with this now.
For now, I've removed the product type parameter, because it's a calculated
field, adn I'm trying to use a parameter called FACDESC that is a straight
database column value.
When I literaly past in the value
[PRODUCT].[FACDESC].&[IMACS General Hospital]
the parameter is passed to the drill through report perfectly.
However, I'd like it to use the current value of the report fields in the
cell I'm drilling through. I've tried these:
[PRODUCT].[FACDESC].&[Fields!FACDESC.Value]
[PRODUCT].[FACDESC].&[Fields!FACDESC.Value(0)]
and it goes back to the missing parameter problem.
If I pass in as the drillthrough parameter
=[PRODUCT].[FACDESC].&[Fields!FACDESC.Value]
but then I get the build error:
[rsCompilerErrorInExpression] The Value expression for the textbox
â'DischargeQuarterâ' contains an error: [BC30451] Name 'PRODUCT' is not
declared.
"Rose" wrote:
> If you are using the Analysis Services provider (the one that comes
> with a UI for you to drag and drop), any query parameters are bound to
> another dataset by default. The parameter value passed/received need
> to be a member of the "available" list.
> I got similar message ""The 'PRODUCTProductType' parameter is missing a
> value " when the value is not found in the available list of values.
> So, you may want to check this first?
> Looking at the parameter name, its value should be of the format of
> [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> value is passed in this format.
>|||Finally got this to work.
To set up a report in RS2005 that is based on an AS2005 Cube data source, so
that it will drill through to another report, also based on an AS2005 Cube
data source, passing parameter values to the subreport:
Pass the report parameters like this:
= "[PRODUCT].[FACDESC].&[" + Fields!FACDESC.Value + "]"
Thanks to Rose for pointing me in the right direction.
"Rose" wrote:
> If you are using the Analysis Services provider (the one that comes
> with a UI for you to drag and drop), any query parameters are bound to
> another dataset by default. The parameter value passed/received need
> to be a member of the "available" list.
> I got similar message ""The 'PRODUCTProductType' parameter is missing a
> value " when the value is not found in the available list of values.
> So, you may want to check this first?
> Looking at the parameter name, its value should be of the format of
> [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> value is passed in this format.
>|||=Fields!Product_Type.UniqueName
should also work, exept when its part of a hierchy in the master-report and
not in the sub-report
"DTK" wrote:
> Finally got this to work.
> To set up a report in RS2005 that is based on an AS2005 Cube data source, so
> that it will drill through to another report, also based on an AS2005 Cube
> data source, passing parameter values to the subreport:
> Pass the report parameters like this:
> = "[PRODUCT].[FACDESC].&[" + Fields!FACDESC.Value + "]"
> Thanks to Rose for pointing me in the right direction.
>
> "Rose" wrote:
> > If you are using the Analysis Services provider (the one that comes
> > with a UI for you to drag and drop), any query parameters are bound to
> > another dataset by default. The parameter value passed/received need
> > to be a member of the "available" list.
> >
> > I got similar message ""The 'PRODUCTProductType' parameter is missing a
> > value " when the value is not found in the available list of values.
> > So, you may want to check this first?
> >
> > Looking at the parameter name, its value should be of the format of
> > [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> > value is passed in this format.
> >
> >

RS.EXE SCRIPT TU AUTOMATE REPORT EXECUTION

Hi,
I am searchig RSS script for RS.EXE to automate excution/run of reports.
I would like to be able to generate reports both in PDF and Excel and store
them in a predefined Server Folder.
There is 2 RSS samples even in SP1 and none of them is doing such job.
I think it could be useful to a lot of people.
Many ThanksJean-Marc,
If you want to automate report deliviery, you don't have to use rs.exe. In
report manager, check out data-driven subscriptions.
Jon Jahren
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am searchig RSS script for RS.EXE to automate excution/run of reports.
> I would like to be able to generate reports both in PDF and Excel and
store
> them in a predefined Server Folder.
> There is 2 RSS samples even in SP1 and none of them is doing such job.
> I think it could be useful to a lot of people.
> Many Thanks
>|||Jon,
I know this Reporting Services features.
BUT, I have to do it in automatically in our company Product independently
of any Reporting Services User Interface.
Best Regards.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Jean-Marc,
> If you want to automate report deliviery, you don't have to use rs.exe. In
> report manager, check out data-driven subscriptions.
> Jon Jahren
> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I am searchig RSS script for RS.EXE to automate excution/run of reports.
> >
> > I would like to be able to generate reports both in PDF and Excel and
> store
> > them in a predefined Server Folder.
> >
> > There is 2 RSS samples even in SP1 and none of them is doing such job.
> >
> > I think it could be useful to a lot of people.
> >
> > Many Thanks
> >
> >
>|||Have you checked out web services. It would surprise me if that didn't have
the capability to do what you are talking about. Use web services to setup
the data driven subscriptions. I think you still want to do that, why
reinvent the wheel.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
news:uGtWbTLyEHA.1396@.tk2msftngp13.phx.gbl...
> Jon,
> I know this Reporting Services features.
> BUT, I have to do it in automatically in our company Product
> independently
> of any Reporting Services User Interface.
> Best Regards.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:%23CzFczJyEHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Jean-Marc,
>> If you want to automate report deliviery, you don't have to use rs.exe.
>> In
>> report manager, check out data-driven subscriptions.
>> Jon Jahren
>> "Jean-Marc PUGIN" <jmpugin@.mobileworkers.com> wrote in message
>> news:OTmF9jIyEHA.824@.TK2MSFTNGP11.phx.gbl...
>> > Hi,
>> >
>> > I am searchig RSS script for RS.EXE to automate excution/run of
>> > reports.
>> >
>> > I would like to be able to generate reports both in PDF and Excel and
>> store
>> > them in a predefined Server Folder.
>> >
>> > There is 2 RSS samples even in SP1 and none of them is doing such job.
>> >
>> > I think it could be useful to a lot of people.
>> >
>> > Many Thanks
>> >
>> >
>>
>

RS and J2EE High Level Architecture Question

I am looking for a tool that allows me to generate lists, mailmerged letters
and reports from a J2EE application. Are there strong reasons in favor or
against RS, specifically in regard to integrating via the Web Service API?
Can I wrap RS in a J2EE-based interface and stream reports through the
application server, as opposed to exposing the RS management interface to
the end users?
Thanks for your input.Christian,
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
This is one of the RS strongest points because with RS reports are
web-enabled by default. In other words, once you deploy your report to the
report catalog there is nothing you have to do to expose it over the web.
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
You bet. You can generate RS reports on the server-side your J2EE
application by calling the RS Render SOAP API. In addtion, the Report Server
supports URL addressibility where a HTTP-GET request is generated on the
client side of the application. You should carefully evaluate both SOAP and
URL addressibility to find out which one meets your app requirements better.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>|||Christian,
I don't see why not. the web service methods for RS include the RENDER
method. Since this is a SOAP call which returns a byte array (representing
the rendered report) RS is client agnostic. have at it.
hope this helps.
dlr
"Christian Donner" <stealthcdonner@.stealthmolecular.comremovestealth> wrote
in message news:esT536OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> I am looking for a tool that allows me to generate lists, mailmerged
letters
> and reports from a J2EE application. Are there strong reasons in favor or
> against RS, specifically in regard to integrating via the Web Service API?
> Can I wrap RS in a J2EE-based interface and stream reports through the
> application server, as opposed to exposing the RS management interface to
> the end users?
> Thanks for your input.
>