Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can Anybody Pls Help Me ??
Message
From
14/07/1999 08:37:47
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00240611
Message ID:
00241209
Views:
23
Pls note that Vpos values is always nil in the detail band record....

Infact for all the band records only height is given...So its not possible to calculate position of a particular band...

Do u know how many points Horizontal and how many points vertical are used in report... Based on that maybe we can calculate..

I've done lot of testing in this and looked everywhere where I can find any info. but it is not mentioned anywhere....


>IF what you are trying to do involves the objects in the detail band, the VPOS for all the detail band objects is relative to the height of the detail band, not the Title plus the Detail band heights. The detail objects are ObjTyp = 8 and there VPOS is less than the Height of ObjTyp = 4, which is the height of the Detail band. I would think you have to add the VPOS of the detail band object to the height of the Title band to get the overall report position of the detail object.
>
>>yes, this is the problem i'm facing...
>>
>>I can use sum for instead of sum while but as u can see Vpos values are exceeding then endrange values.... which shud not happen...
>>
>>Even if u try to do totals manually still it is not falling in the range where it shud be...
>>
>>Do u know any solution for this ???
>>
>>Is spacing field has to do anything with this ???
>>
>>Pls help....
>>
>>
>>>I just tested your code and it works as expected. The problem is that all my VPOS values that were greater than nStRange were also greater than nEndRange. So when I applied the filter, I got no records.
>>>
>>>I would also do a SUM FOR instead of a SUM WHILE because the report file is so small. You are also assuming all these records are in some sort of order by using a WHILE clause.
>>>
>>>I opened the debugger and had it run your code step-by-step so I could watch the values of each variable.
>>>
>>>>I've posted this question more then 2-3 times but still didn't got any answer, with the last hope, I'm posting it again....
>>>>
>>>>I want to get list of fields/labels in any particular report band (detail, title etc..). After getting replies from here and chking frx files structure and help at Eps site..
>>>>
>>>>i made this routine to test it... But it is not working properly... Is anybody having any routine to get that or if somebody can advs. me why it is not working...
>>>>
>>>>Pls Help..
>>>>
>>>>********************************
>>>>* What this routine is doing ??
>>>>*
>>>>* 1. Going on the first Band Record
>>>>* 2. Starting a Counter which adds height of band in a variable upto * detail band (i.e. starting Range)
>>>>* 3. Total height is then added with height of detail band (which *gives the end range)
>>>>* 4. Then i'm checking what are the elements in these two ranges...
>>>>
>>>>
>>>>use imtr.frx in 0 Alias TestRep
>>>>Sele TestRep
>>>>Go Top
>>>>
>>>>Local nStRange, nEndRange, nBand
>>>>
>>>>nBand=4 && i.e. For Detail Band
>>>>
>>>>Locate for ObjType = 9 && Locates 1st band record
>>>>
>>>>Sum TestRep->height to nStRange ;
>>>>while ObjType = 9 and ObjCode <> nBand
>>>>
>>>>nEndRange=nStRange+TestRep.Height
>>>>
>>>>set filt to TestRep.VPos >= nStrange and ;
>>>>TestRep.VPos < nEndRange
>>>>
>>>>go top
>>>>
>>>>Disp all Expr
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform