Reports and date fields

Try doing your record selection and sorting in Maximizer first, before running the report.

I was hoping to avoid that and be able to do ot all in one step within the report. Also I want the date range available for the report. One reason I am looking at moving away from ACT and towards max is because this is what I had to do in act and I was hoping the report variables would allow me to achieve this. Is this not possible to do directly in the report? I would ideqally like to have one button on the toolbar run the report and request the date range within the report.

>Is this not possible to do directly in the report?

I'm no expert on the ReportSmith Explorer app that ships with Maximizer, but my understanding is that the fields are exported from Maximizer as a text file and then ReportSmith slurps them in. Certainly if Maximizer uses its default date format (e.g., "September 24, 2001") then ReportSmith will likely insist on treating it as text. If Maximizer's alternate date format is chosen (a butchered version of the system short format, e.g. "1/9/24") then ReportSmith might be convinced to treat it as a date, but I don't have enough experience with that component to say for sure.

Thanks for your 2 cents Gord. I now realize that as you say max simply exports a csv file to a temp directory that reportsmith reads and it appears it is not reading data directly from the db. I was hoping to link a report directly to my max db and be able to pull up info in the report based on a date range defined at report runtime. Back to the drawing board i guess.

Not sure what you attempting with your report, but it seems to me a simple Crystal Report with Date parameters would do. A Crystal run-time report will respond to a button on Max's toolbar. Any parameters defined will pop-up for user input. I have also heard of a custom utility that will allow Crystal reporting on the current list in Max. No details at my fingertips, but could check into it if you like.