Help me in designing a chart

[everlearner]

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

[Gyana]

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.