Announcement Announcement Module
Collapse
No announcement yet.
CrossTab Jasper Report From Spring Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • CrossTab Jasper Report From Spring

    Hi
    I am creating a crosstab report using jasper from my application. The Spring framework is used for my application.

    To make the template of crossbar report i have used ireport, where i set the report query and subdataset to create the crossbar report. After compilation the jasper file has been created which is in use in my spring application.

    But now the datasource has to be passed to this jasper file from the spring application..

    I have two query. Taking one data as a parameter from first query second query is executing and the second query is there inside the crossbar subdataset..

    Now I am not able to make the crossbardatasource from spring.

    Can anyone help in this regard as soon as possible.


    Code:
    First query:
    ----------
    
    select s.locationstate as state
    
    From bpbillpaymentheader h inner join bpcashdrawer  d on (h.drawerid = d.drawerid)
           inner join systore s on (d.storeid = s.storeid)
           inner join sycompany c on (s.company_id = c.company_id)
    
    where h.transdate between '2007-07-01' and '2007-07-18'
    and s.locationstate <> ""
    group by s.locationstate
    Code:
    Second Query:  
    --------------
    From first query  a parameter say "State" is passing to second query. So this second query is the query of crosstab subdataset
    
    select h.billpaymentheaderid,  h.transdate, d.drawerid, d.drawercode,
    s.storeid, s.description , s.locationstate, c.company_id, c.name
    
    From bpbillpaymentheader h inner join bpcashdrawer  d on (h.drawerid = d.drawerid)
           inner join systore s on (d.storeid = s.storeid)
           inner join sycompany c on (s.company_id = c.company_id)
           
    where h.transdate between '2007-07-01' and '2007-07-18'
    and s.locationstate = $P{State}
    order by d.drawerid
    rgds,
    Sayantani
Working...
X