I want to give users the ability to move fields around a screen (in an edit box?) then when done save the format into a report. I know I would have to write the rules for each field but want to know if anyone has tried creating a "report writer". I need this for users that can't use(which means most) modify report.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
build a report in code
- Thread starter vfpgolfer
- Start date
I haven't done a report writer, but I have done a screen layout where the user could move items using drag and drop to add, remove or reposition 'things' on a floor layout.
Here are some of the fundementals:
Start by subclassing a text box.
Create a table containing your field names, types, sizes, etc by maybe using COPY STRUCTURE EXTENDED. Then alter the table to include X and Y coordinates.
You can then have a page, image, whatever you want to draw the text boxes on with which to use ADDOBJECT() to drop and position your subclassed text boxes sizing them to the width of the data as a default. You could update the table with a larger size if needed.
Toggle .Dragmode to move them around, updating X and Y coordinates of the table using the parents' MouseMove event.
That's all I can think of right off hand. But that's some general ideas.
-Dave Summers-
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
Even more Fox stuff at:
Here are some of the fundementals:
Start by subclassing a text box.
Create a table containing your field names, types, sizes, etc by maybe using COPY STRUCTURE EXTENDED. Then alter the table to include X and Y coordinates.
You can then have a page, image, whatever you want to draw the text boxes on with which to use ADDOBJECT() to drop and position your subclassed text boxes sizing them to the width of the data as a default. You could update the table with a larger size if needed.
Toggle .Dragmode to move them around, updating X and Y coordinates of the table using the parents' MouseMove event.
That's all I can think of right off hand. But that's some general ideas.
-Dave Summers-
Even more Fox stuff at:
Olaf Doschke
Programmer
Bye VFP9, deliver the report.apps and any user can use modify report.
Bye, Olaf.
Bye, Olaf.
- Thread starter
- #4
We do that now - but most users are not able to modify - they can move around but adding and deleting is problem. I want ability to give them simple list of fields that they can pick from to put on report (I know is in modify report commands but format is not user friendly - more programmer friendly)
ChrisRChamberlain
Programmer
vfpgolfer
How can a user modify a report without using the FoxPro report designer faq184-157
may help.
![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
PDFcommandertm.net
PDFcommandertm.co.uk
How can a user modify a report without using the FoxPro report designer faq184-157
may help.
FAQ184-2483 - answering getting answered.
Chris PDFcommandertm.net
PDFcommandertm.co.uk
TamarGranor
Programmer
- Status
