Hi,
I think the OrdersReport.jrxml under the /demo/samples/crosstab folder
of our project distribution show what you are looking for.
I hope this helps.
Teodor
Marty Phee wrote:
> Thanks! I've been away for a while and forgot about that syntax.
>
> Can you answer my other question? Can I change the background color on
> crosstab query results by line? Like even/odd rows.
>
> Teodor Danciu wrote:
>
>> Hi,
>>
>> You need to use the P!{param_name} syntax.
>> Check the supplied "/demo/samples/query" sample.
>>
>> If you have furter questions, please log into www.jasperforge.org forums
>> and post them there.
>> Soon this mailing list will be made read-only as we moved our project
>> home to JasperForge.
>>
>> Thank you,
>> Teodor
>>
>>
>> Marty Phee wrote:
>>
>>
>>> I have a query like below:
>>>
>>> select *
>>> from table1
>>> where field1 in( $P{subselect} )
>>>
>>> I'd like to pass in the $P{} a select field2 from table2, but it's not
>>> working. I'm guessing that it's putting in "select field2 from table2"
>>> with the quotes and it's failing.
>>>
>>> Is there a way to pass in a string that won't be quoted?
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys -- and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> jasperreports-questions mailing list
>>> jasperreports-questions@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
>>>
>>>
>>>
>>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys -- and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> jasperreports-questions mailing list
>> jasperreports-questions@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
>>
>>
>>
>>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> jasperreports-questions mailing list
> jasperreports-questions@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
>
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
