Bar Chart

[harding1031]

CR 9.0
My chart is including the data that is being suppressed in my detail section. How can I force the chart to only read data that is displayed in the detail section. The data is coming directly from the data base. I was not able to put my formula in the selection expert because I have to use the DateTime function to exclude the data based on the date and time. The date and time are defined as strings in the database.
Ex.(DateTime({IMITREP.KT42A}+" "+left({IMITREP.KT43A},8)) <
DateTime(ToText({?Pm-@Input Date})+" "+{@Chart Start Time})) or
(DateTime({IMITREP.KT42A}+" "+left({IMITREP.KT43A},8)) >
DateTime(ToText({?Pm-@Input Date}+1)+" "+{@Chart Stop Time}))
TIA.

 

[rosemaryl]

Dear Harding1031,

A. If you define your parameters as Date Time rather then date, the user can populate the date and time and you could use it in the selection formula.

@chart start time and @chart stop time are not defined in you information above .. so I don't know what determines that.

B. Create formulas to replace the fields to be shown in chart, using the criteria of fields to be shown:

If (criteria to match)
then Table.Field
else 0

If you give more detailed information about chart start time and stop time and what the fields you need to display on the chart are ... I may be able to offer more assistance.

Regards,
ro



Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762