Re: realigning totals in anothers

You could also use

if p1f1"@" = "10@" then p1f3 endif

Should work the same.


Paul Durban



At 7/23/2007 05:18 AM, you wrote:
> Hi Victor,
>
> DP evaludate string comparisons against the shortest 
> field...  consequently you need to pad beyond the last expected 
> string with a dummy value, or also compare the string lengths...
>
> I would try this
>
> If cat.t[p1f1;"@"] = "10@" then p1f3 endif
>
> Regards
> Brian
>
>
>
> ----- Original Message ----- From: "Victor Warner" 
> <vwarner-0bo+QMkBU69BDgjK7y7TUQ@xxxxxxxxxxxxxxxx>
> To: "Dataperfect Users Discussion Group" 
> <dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx>
> Sent: Monday, July 23, 2007 6:57 PM
> Subject: Re: [Dataperf] realigning totals in anothers
>
>
> > Brian,
> >
> > Thank you. The numbers were out of sync because they had been 
> > exported and imported. Your outline brought back what commands I 
> > needed to enter into the report definition.
> >
> > I have another issue which I would be grateful for some guidance:
> >
> > I have a field which is formatted as A2, and contains 1, 2, 3, 4, 
> > 5, 6, 8, 9, 10
> >
> > In a second field I wish to select information from a third field 
> > based on whether the second field has a 1, 2, etc in it , but when I enter
> >
> >          If p1f1 = "10" then p1f3 endif
> >
> > I get the selection for the A2 field whether it is "1" or "10". Is 
> > it possible to set up the If statement that only "10" entries are selected?
> >
> > Victor Warner.
> >
> >
> > Brian Hancock wrote:
> > > Hi Victor,
> > >
> > > There are a couple of ways, one way is:
> > >
> > > Run a report on the panel that holds the total and in the Report 
> > > body include:
> > >
> > > *Zeroing a Report Variable to act as an accumulator
> > > *Include a Sub Report(s) with the panel(s) containing the totals 
> > > linked to the parent panel
> > > *Add/Subtract whatever the values to be totalled to the accumlator
> > > *Exit the subreport
> > > *Store the accumlator RV into the Totals field on the parent panel
> > >
> > > You shoud check to see why the values are out of sync, if it just 
> > > because you exported and imported all the records from a table but 
> > > made a mistake regarding the totals, then not so bad... but if it 
> > > from a logic error, (not easy to do but can happen) then you 
> > > should try to rectify it
> > >
> > > Bye
> > > Brian
> > >
> > >
> > >
> > > ----- Original Message ----- From: "Victor Warner" 
> > > <vwarner-0bo+QMkBU69BDgjK7y7TUQ@xxxxxxxxxxxxxxxx>
> > > To: <dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx>
> > > Sent: Sunday, July 22, 2007 9:17 AM
> > > Subject: [Dataperf] realigning totals in anothers
> > >
> > >
> > > > I have a database with some fields in one panel being added to 
> > > > added to a field in another panel (keep a total).
> > > >
> > > > The totals in the other panel for some records are no longer accurate.
> > > >
> > > > I would like the other panel fields which hold the totals to be 
> > > > set to zero and then the totals added back. I asked this question 
> > > > a number of years ago but cannot find the answer anymore. I would 
> > > > be grateful on knowing how to do this again.
> > > >
> > > > Victor Warner.
> > > > _______________________________________________
> > > > Dataperf mailing list
> > > > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > > > http://lists.dataperfect.nl/mailman/listinfo/dataperf
> > >
> > > _______________________________________________
> > > Dataperf mailing list
> > > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > > http://lists.dataperfect.nl/mailman/listinfo/dataperf
> > _______________________________________________
> > Dataperf mailing list
> > Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> > http://lists.dataperfect.nl/mailman/listinfo/dataperf
>
> _______________________________________________
> Dataperf mailing list
> Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> http://lists.dataperfect.nl/mailman/listinfo/dataperf