Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
Thanks George,
I'm trying to build a flexible report that can be used for a number of situations. For example, they are able to choose whether the objects (all or none) will print on the report by selecting a heading from a listbox. Let's say that they choose a heading called *Section One.* Are you saying that I should pass variables to a UDF for what I know to be all the objects within Section One? If the report changed, I would have to recode for the UDF? Could I build a cursor from the FRX and use it as part of my control for the listbox?
Just trying to find the cleanest, most flexible way to do this...
Renoir
>>Anyone know how I could replace the SupExpr field in a FRX table for a specific report grouping? I want to programatically change whether objects appear in a specific grouping based on user input. I couldn't find where the group header was referenced for the objects it contains.
>>
>Hi Renoir,
>
>There's no direct reference other than position that can be drawn between the data grouping and the detail line. For example, a report with a single grouping will probably have and objtype of 9 objcode 3 for the group header and obtype 9 objcode 5 for the group footer. If you examine the report after opening it as a table, you'll not that neither of these has a horizontal or vertical position in the HPOS and VPOS fields, but does have a height.
>
>About the only thing that I can think of here would be to replace the Print When condition with a call to a UDF. As long as any variables that the user would be entering were in scope, they could be passed as parameters to the UDF and evaluated there. This, I think, would be a much cleaner solution, if I understand what you're trying to do correctly.
>
>hth,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only