Hello RMW,
The Jet Data Grid should be saving some of your settings for the next time you drill down. Since it isn't working correctly, there might be something wrong with the files that store the information. They are kept in your application data folder. I always get to it by opening a Windows Explorer and typing in %appdata% then navigating to your Jet Reports folder. You should see a file called something like "GP 10 Drilldown Views.xml" (this is for my GP 10 Data Source). If you see multiples of these - with a (1) after it, there might be something wrong. If you delete this file it will reset the drilldown views. The next time you drilldown and move fields around, it should remember it. Please make sure Excel is closed before deleting the file.
1 comment
-
Jet Reports Historic Posts When you drill down from a report using the datagrid, you get some nice possibilities to view, sort and group the data.
But….
1. Every sort you do has to be done again the next time you use the same drill down
2. You get every field from the record and when only some are needed you can deselect them, but you have to do it again the next time
3. Column order can be rearranged, but you have to do it again the next time
The repeating issue in these items is 'you have to do it again'.
Does anybody know how to avoid that 'do it again' thing?
And another thing: why are numbers displayed with trailing zero's filling up the whole field??
Is it possible to format numbers and get them outlined to the left?
rmw