Hi Gurus,
Thanks for ur replies for previous post. here the another one.
i would like to design a chart with 3 fields. here am putting an example.
in my chart i need 3 fields, that are region sales , time ( between two particular dates)
for that i have taken value prompt to select region & date prompt to select 2 particular dates.
when we run the report how can generate a chart dynamically to the output? and also please make me clear how to select the data between two particular dates? ( it need one date prompt or two) please give me an example.
thanks in adv
In Your Chart Query Put a filter :
[region] = ?regionPrompt?
If you want two dates then you have to put two date prompts.
[Date Dataitem] between (?fromdate? and ?todate?)
It may help you.