Need help in generating Gantt Chart

[shivkant84]

Hi All,

I am creating Gantt Chart using jasperreports-3.1.0. But i have below problems

1. I am running the  executing the following query in <queryString> with parameter milestoneList.

<parameter name="milestoneList" class="java.lang.String"/>

<queryString>
        <![CDATA[
             select * from study_milestones_gantt_view where milestone_type in ($P{milestoneList})       
        ]]>
    </queryString>

 

Values coming in milestoneList parameters are like   --- >  'Enrollment','Activation'

But my report is not populating data.  If i remvoe where condition then my report works fine.  I have attached my jrxml file.

 

2. Is it possible that i can modify/timescale of gantt chart ??

 

Please help.

Thanks

Shivkant

[shivkant84]

I was able to solve my query problem by passsing parameter as

 

<queryString>

<![CDATA[

select * from study_milestones_gantt_view where milestone_type in ($P!{milestoneList})

]]>

</queryString>

 

But still looking for help in Time Scale related problem of Gantt. Should i write a customize class if so then how? any link/info that helps please provide me..!!

 

Thanks

Shivkant

[rajesh.sm]

Could you share me Gantt Chart tutorial or sample link.

or share me the how to do step by step approach?.

[syed.cub]

I am also looking for the Gantt Chart link or document. If anyone knows how to create a Gantt chart successfully in Jaspersoft then pls post here. It will be a great step towards educating others and strengthening jasper Community.

 

Thanks,

Syed