I haven't done a good job documenting this, but its happened enough, and I do have a specific example to show, that I thought I would make this post.
Yesterday I was creating a report based on a dynamic view. I went through a few cycles of editing the view and editing the report. Each time, entering the reports desing mode would give a message stating the columns have been updated / new column(s) added. However once I did that I could no longer control the sequence of the fields on the drill down form, that is, they did not appear on the form in the sequence I specified in the list. Twice I had to delete the report and start over to fix this.
Just now I was creating a drill-down to another report. I couldn't get it to work and then realized my relation between the data sources was wrong. My tables, created with Dataflex, used overlap fields for the Dataflex relationship. Since these fields don't exist in SQL, I appended a computed filed to my DAI view (thinking adding it to the end might avoid the aforementioned problem).
My drill-down from report to report now worked perfectly. But I decided I wanted to drill down to the second report from the first report's form instead. When I went to form details the form fields that exist on the form no longer appear.
- Edited_View.gif (8.67 KiB) Viewed 7798 times
- Form_Fields_List.gif (18.11 KiB) Viewed 7798 times
- Form_Fields_Options_Fields.gif (11.1 KiB) Viewed 7798 times
Did I do something wrong, or miss a step?
Bob
