Acces to Data Set Parameters in Report Body [message #88012] |
Mon, 07 November 2005 03:29 |
Eclipse User |
|
|
|
Originally posted by: pcasey.earthlink.net
I have a report (purchases by date) that gets run from the web. The report
has a data set that takes two parameters startDate and endDate and then does
a query bounded by those markers. It works fine.
I want, however, to use those two parameters within the report e.g. print a
title that says:
'All Purchases between ' + startDate + ' and ' + endDate
The only problem is that startDate and endDate appear null during report
render :(. Is there a different javascript expression I should be using to
get at them? Is there a global DataSet.parameters.startDate or some such I
could use?
Alternately, how would you suggest working this out?
--- Pat
|
|
|
Re: Acces to Data Set Parameters in Report Body [message #88028 is a reply to message #88012] |
Mon, 07 November 2005 04:40 |
Eclipse User |
|
|
|
Originally posted by: none.none.none
Hi Patrick,
If I understand you correctly, I think you want to do this:
'All Purchases between ' + params["startDate"] + ' and ' + params["endDate"]
"Patrick Casey" <pcasey@earthlink.net> wrote in message
news:dkmhnb$isp$1@news.eclipse.org...
>
> I have a report (purchases by date) that gets run from the web. The report
> has a data set that takes two parameters startDate and endDate and then
> does a query bounded by those markers. It works fine.
>
> I want, however, to use those two parameters within the report e.g. print
> a title that says:
>
> 'All Purchases between ' + startDate + ' and ' + endDate
>
> The only problem is that startDate and endDate appear null during report
> render :(. Is there a different javascript expression I should be using to
> get at them? Is there a global DataSet.parameters.startDate or some such I
> could use?
>
> Alternately, how would you suggest working this out?
>
> --- Pat
>
|
|
|
Re: Acces to Data Set Parameters in Report Body [message #88378 is a reply to message #88028] |
Mon, 07 November 2005 18:02 |
Eclipse User |
|
|
|
Originally posted by: pcasey.earthlink.net
I think that would work if I was using a report parameter, but I'm
trying to access a dataSet parameter. When I use the syntax you describe, I
get:
There are errors on the report page:
- There are error(s) in Data:null
Error0 : data.engine.JSScriptInvalid(2times)detail: Invalid Javascript
expression. Source: , line: 0, Expression:Script engine error: startDate not
found I tried using report parameters, but I could not, for the life of
me, get the data binder to bind a datatime report parameter (with default
value) to a datetime dataset parameter. So right nowI'm using only dataset
parameters. --- Pat"chris" <none@none.none> wrote in message
news:dkmlrn$mce$1@news.eclipse.org...
> Hi Patrick,
> If I understand you correctly, I think you want to do this:
>
> 'All Purchases between ' + params["startDate"] + ' and ' +
> params["endDate"]
>
> "Patrick Casey" <pcasey@earthlink.net> wrote in message
> news:dkmhnb$isp$1@news.eclipse.org...
>>
>> I have a report (purchases by date) that gets run from the web. The
>> report has a data set that takes two parameters startDate and endDate and
>> then does a query bounded by those markers. It works fine.
>>
>> I want, however, to use those two parameters within the report e.g. print
>> a title that says:
>>
>> 'All Purchases between ' + startDate + ' and ' + endDate
>>
>> The only problem is that startDate and endDate appear null during report
>> render :(. Is there a different javascript expression I should be using
>> to get at them? Is there a global DataSet.parameters.startDate or some
>> such I could use?
>>
>> Alternately, how would you suggest working this out?
>>
>> --- Pat
>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03241 seconds