Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combining Memo Fields
Message
From
16/05/2008 15:53:17
 
 
To
16/05/2008 15:37:56
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01317718
Message ID:
01317733
Views:
6
Thanks. Could you give a little more help to the specifics?
There are no fields in the header of the group nor are there any fields in the detail section.
Not sure how to pull this off in Foxpro.
Easy in Crystal Reports for me.


>There are probably a few ways to do this. You could step through the cursor used for the report and build a string of all the memo data in the group. When you get to the last record in that group, stuff the string into it's memo field. Or add a new 'last' record for that group an put it in there. Or you could create a report variable to store it and then display that variable in the group's footer - reset the variable at the start of each group.
>
>
>>In the report writer is it possible to combine several records of the same memo field and show the contents once at the end of a group?
>>
>>Example:
>>Rec #1 Memo field has abcdef
>>Rec #2 Memo field has ghijkl
>>Rec #3 Memo field has mnopqr
>>
>>At end of group shows abcdefghijklmnopqr
>>
>>In Crystal I would make a var at top of group
>>in detail add to it Var=Var+memo
>>At end of group I would show the contents
>>But I could suppress the field and section in Crystal
>>
>>Not sure how to do it in Foxpro
>>
>>
>>Andy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform