Crystal Group on WhilePrintingRecords

Yahoo Archive
1
Maybe there is a better way to do what I am trying to do. I have a
report that Shows all open jobs for a particular Resource. My
tables are JobHed, JobOpDtl, JobMtl & JobProd. Each job head has a
unique number (JobHed.Number15)& this report is sorted by that
number. I need to add a subtotal of JobMtl.Qty at each change in
JobHed.PartNum while still keeping the order of (JobHed.Number15).
I do not want to bunch every JobHed.PartNum together for summary, I
only want to add the summary at each change. If a Job has that same
part number but is further down the list to start over and add the
summary before the partnum changes again. I can do this in excel by
just using subtotals . I sort by JobHed.Number15 and then Subtotal
Qty at each change in JobHed.JobNum. Why I can make it work in
excel & not in crystal is beyond me.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> You can't. This event fires after grouping occurs.
>
> Share a variable among the subreport and container report? Yes.
See
> below.
>
>
http://www.datamanagementgroup.com/Resources/TrainersTalk/trainerstal
k_h
> owto_share_subreport_data_with_main_report.asp
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Tuesday, December 09, 2008 2:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Group on WhilePrintingRecords
>
> Well I come to find out that you cannot group based on
> WhilePrintingRecords formula. I did read that it is possible if
you
> create a subreport of the same report & then pass the
> WhilePrintingRecords as a string parameter to the subreport. Has
> anyone done anything like this, or maybe they know a way to group
> based on the WhilePrintingRecords formula.
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > That worked. I just cant group based on the formula. Though I
> was
> > able to group using a formula before just can't remember how.
> > --- In vantage@yahoogroups.com, "Dale Schuerman"
> > <dale.schuerman@> wrote:
> > >
> > > This is from one of my reports that is working correctly
> > > (@InvoiceNumAndLine is just the Invoice and Invoice line
> together)
> > >
> > >
> > >
> > > Header
> > >
> > >
> > >
> > > WhilePrintingRecords;
> > >
> > >
> > >
> > > CurrencyVar InvGrossSales := 0;
> > >
> > >
> > >
> > >
> > >
> > > Detail
> > >
> > >
> > >
> > > WhilePrintingRecords;
> > >
> > >
> > >
> > > CurrencyVar InvGrossSales;
> > >
> > >
> > >
> > > If (OnFirstRecord or
> > >
> > > {@InvoiceNumAndLine} <> Previous({@InvoiceNumAndLine})) then
> > >
> > > InvGrossSales := InvGrossSales +
> > > {BAQReportResult.InvcDtl.DocExtPrice};
> > >
> > >
> > >
> > > Hope this helps
> > >
> > >
> > >
> > > Dale E. Schuerman
> > >
> > > Senior Consultant
> > >
> > > RAM Software Systems, Inc.
> > >
> > > 972-669-0763 x233 (voice)
> > >
> > > 972-669-9603 (fax)
> > >
> > > mailto:dale.schuerman@
> > > <BLOCKED::blocked::mailto:dale.schuerman@> (email)
> > >
> > > http://www.ramsys.com
<BLOCKED::blocked::http://www.ramsys.com/>
> > > (website)
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
> On
> > Behalf
> > > Of Michael McWilliams
> > > Sent: Tuesday, December 09, 2008 10:22 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] (unknown)
> > >
> > >
> > >
> > > I am trying to create a grouping based on formulas.
> > >
> > > I have this in the header//
> > > WhilePrintingRecords;
> > > Global NumberVar schedGroup;
> > > schedGroup := 0;
> > >
> > > I have this in the details//
> > > Global NumberVar schedGroup;
> > > If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
> > > schedGroup := schedGroup + 1 ;
> > >
> > > I am trying to add this to the details//
> > > If {@PrevVal} = "Repeated Value" Then
> > > schedGroup;
> > >
> > > For all the items that are repeated values I get a 0 but all
the
> > > ones that are "New Grouping it is adding one to the next
record.
> > > Any clue what I am doing wrong?
> > >
> > >
> > >
> > >
> > >
> >
>
#####################################################################
> > ###
> > > Attention:
> > > This email message is privileged and confidential. If you are
> not
> > the
> > > intended recipient please delete the message and notify the
> > sender.
> > > Any views or opinions presented are solely those of the author.
> > >
> > > This email message has been scanned for Viruses and Content
and
> > cleared
> > > by MailMarshal SMTP
> > >
> > > For more information go to http://www.ramsys.com
> > >
> >
>
#####################################################################
> > ###
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
2
I am trying to create a grouping based on formulas.


I have this in the header//
WhilePrintingRecords;
Global NumberVar schedGroup;
schedGroup := 0;


I have this in the details//
Global NumberVar schedGroup;
If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
schedGroup := schedGroup + 1 ;


I am trying to add this to the details//
If {@PrevVal} = "Repeated Value" Then
schedGroup;


For all the items that are repeated values I get a 0 but all the
ones that are "New Grouping it is adding one to the next record.
Any clue what I am doing wrong?
3
This is from one of my reports that is working correctly
(@InvoiceNumAndLine is just the Invoice and Invoice line together)



Header



WhilePrintingRecords;



CurrencyVar InvGrossSales := 0;





Detail



WhilePrintingRecords;



CurrencyVar InvGrossSales;



If (OnFirstRecord or

{@InvoiceNumAndLine} <> Previous({@InvoiceNumAndLine})) then

InvGrossSales := InvGrossSales +
{BAQReportResult.InvcDtl.DocExtPrice};



Hope this helps



Dale E. Schuerman

Senior Consultant

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Tuesday, December 09, 2008 10:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] (unknown)



I am trying to create a grouping based on formulas.

I have this in the header//
WhilePrintingRecords;
Global NumberVar schedGroup;
schedGroup := 0;

I have this in the details//
Global NumberVar schedGroup;
If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
schedGroup := schedGroup + 1 ;

I am trying to add this to the details//
If {@PrevVal} = "Repeated Value" Then
schedGroup;

For all the items that are repeated values I get a 0 but all the
ones that are "New Grouping it is adding one to the next record.
Any clue what I am doing wrong?




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
4
That worked. I just cant group based on the formula. Though I was
able to group using a formula before just can't remember how.
--- In vantage@yahoogroups.com, "Dale Schuerman"
<dale.schuerman@...> wrote:
>
> This is from one of my reports that is working correctly
> (@InvoiceNumAndLine is just the Invoice and Invoice line together)
>
>
>
> Header
>
>
>
> WhilePrintingRecords;
>
>
>
> CurrencyVar InvGrossSales := 0;
>
>
>
>
>
> Detail
>
>
>
> WhilePrintingRecords;
>
>
>
> CurrencyVar InvGrossSales;
>
>
>
> If (OnFirstRecord or
>
> {@InvoiceNumAndLine} <> Previous({@InvoiceNumAndLine})) then
>
> InvGrossSales := InvGrossSales +
> {BAQReportResult.InvcDtl.DocExtPrice};
>
>
>
> Hope this helps
>
>
>
> Dale E. Schuerman
>
> Senior Consultant
>
> RAM Software Systems, Inc.
>
> 972-669-0763 x233 (voice)
>
> 972-669-9603 (fax)
>
> mailto:dale.schuerman@...
> <BLOCKED::blocked::mailto:dale.schuerman@...> (email)
>
> http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
> (website)
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Tuesday, December 09, 2008 10:22 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] (unknown)
>
>
>
> I am trying to create a grouping based on formulas.
>
> I have this in the header//
> WhilePrintingRecords;
> Global NumberVar schedGroup;
> schedGroup := 0;
>
> I have this in the details//
> Global NumberVar schedGroup;
> If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
> schedGroup := schedGroup + 1 ;
>
> I am trying to add this to the details//
> If {@PrevVal} = "Repeated Value" Then
> schedGroup;
>
> For all the items that are repeated values I get a 0 but all the
> ones that are "New Grouping it is adding one to the next record.
> Any clue what I am doing wrong?
>
>
>
>
>
#####################################################################
###
> Attention:
> This email message is privileged and confidential. If you are not
the
> intended recipient please delete the message and notify the
sender.
> Any views or opinions presented are solely those of the author.
>
> This email message has been scanned for Viruses and Content and
cleared
> by MailMarshal SMTP
>
> For more information go to http://www.ramsys.com
>
#####################################################################
###
>
>
> [Non-text portions of this message have been removed]
>
5
Well I come to find out that you cannot group based on
WhilePrintingRecords formula. I did read that it is possible if you
create a subreport of the same report & then pass the
WhilePrintingRecords as a string parameter to the subreport. Has
anyone done anything like this, or maybe they know a way to group
based on the WhilePrintingRecords formula.

--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> That worked. I just cant group based on the formula. Though I
was
> able to group using a formula before just can't remember how.
> --- In vantage@yahoogroups.com, "Dale Schuerman"
> <dale.schuerman@> wrote:
> >
> > This is from one of my reports that is working correctly
> > (@InvoiceNumAndLine is just the Invoice and Invoice line
together)
> >
> >
> >
> > Header
> >
> >
> >
> > WhilePrintingRecords;
> >
> >
> >
> > CurrencyVar InvGrossSales := 0;
> >
> >
> >
> >
> >
> > Detail
> >
> >
> >
> > WhilePrintingRecords;
> >
> >
> >
> > CurrencyVar InvGrossSales;
> >
> >
> >
> > If (OnFirstRecord or
> >
> > {@InvoiceNumAndLine} <> Previous({@InvoiceNumAndLine})) then
> >
> > InvGrossSales := InvGrossSales +
> > {BAQReportResult.InvcDtl.DocExtPrice};
> >
> >
> >
> > Hope this helps
> >
> >
> >
> > Dale E. Schuerman
> >
> > Senior Consultant
> >
> > RAM Software Systems, Inc.
> >
> > 972-669-0763 x233 (voice)
> >
> > 972-669-9603 (fax)
> >
> > mailto:dale.schuerman@
> > <BLOCKED::blocked::mailto:dale.schuerman@> (email)
> >
> > http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
> > (website)
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > Of Michael McWilliams
> > Sent: Tuesday, December 09, 2008 10:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] (unknown)
> >
> >
> >
> > I am trying to create a grouping based on formulas.
> >
> > I have this in the header//
> > WhilePrintingRecords;
> > Global NumberVar schedGroup;
> > schedGroup := 0;
> >
> > I have this in the details//
> > Global NumberVar schedGroup;
> > If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
> > schedGroup := schedGroup + 1 ;
> >
> > I am trying to add this to the details//
> > If {@PrevVal} = "Repeated Value" Then
> > schedGroup;
> >
> > For all the items that are repeated values I get a 0 but all the
> > ones that are "New Grouping it is adding one to the next record.
> > Any clue what I am doing wrong?
> >
> >
> >
> >
> >
>
#####################################################################
> ###
> > Attention:
> > This email message is privileged and confidential. If you are
not
> the
> > intended recipient please delete the message and notify the
> sender.
> > Any views or opinions presented are solely those of the author.
> >
> > This email message has been scanned for Viruses and Content and
> cleared
> > by MailMarshal SMTP
> >
> > For more information go to http://www.ramsys.com
> >
>
#####################################################################
> ###
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
6
You can't. This event fires after grouping occurs.

Share a variable among the subreport and container report? Yes. See
below.

http://www.datamanagementgroup.com/Resources/TrainersTalk/trainerstalk_h
owto_share_subreport_data_with_main_report.asp



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Tuesday, December 09, 2008 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Group on WhilePrintingRecords

Well I come to find out that you cannot group based on
WhilePrintingRecords formula. I did read that it is possible if you
create a subreport of the same report & then pass the
WhilePrintingRecords as a string parameter to the subreport. Has
anyone done anything like this, or maybe they know a way to group
based on the WhilePrintingRecords formula.

--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> That worked. I just cant group based on the formula. Though I
was
> able to group using a formula before just can't remember how.
> --- In vantage@yahoogroups.com, "Dale Schuerman"
> <dale.schuerman@> wrote:
> >
> > This is from one of my reports that is working correctly
> > (@InvoiceNumAndLine is just the Invoice and Invoice line
together)
> >
> >
> >
> > Header
> >
> >
> >
> > WhilePrintingRecords;
> >
> >
> >
> > CurrencyVar InvGrossSales := 0;
> >
> >
> >
> >
> >
> > Detail
> >
> >
> >
> > WhilePrintingRecords;
> >
> >
> >
> > CurrencyVar InvGrossSales;
> >
> >
> >
> > If (OnFirstRecord or
> >
> > {@InvoiceNumAndLine} <> Previous({@InvoiceNumAndLine})) then
> >
> > InvGrossSales := InvGrossSales +
> > {BAQReportResult.InvcDtl.DocExtPrice};
> >
> >
> >
> > Hope this helps
> >
> >
> >
> > Dale E. Schuerman
> >
> > Senior Consultant
> >
> > RAM Software Systems, Inc.
> >
> > 972-669-0763 x233 (voice)
> >
> > 972-669-9603 (fax)
> >
> > mailto:dale.schuerman@
> > <BLOCKED::blocked::mailto:dale.schuerman@> (email)
> >
> > http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
> > (website)
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > Of Michael McWilliams
> > Sent: Tuesday, December 09, 2008 10:22 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] (unknown)
> >
> >
> >
> > I am trying to create a grouping based on formulas.
> >
> > I have this in the header//
> > WhilePrintingRecords;
> > Global NumberVar schedGroup;
> > schedGroup := 0;
> >
> > I have this in the details//
> > Global NumberVar schedGroup;
> > If {@PrevVal} = "" Or {@PrevVal} = "New Grouping" Then
> > schedGroup := schedGroup + 1 ;
> >
> > I am trying to add this to the details//
> > If {@PrevVal} = "Repeated Value" Then
> > schedGroup;
> >
> > For all the items that are repeated values I get a 0 but all the
> > ones that are "New Grouping it is adding one to the next record.
> > Any clue what I am doing wrong?
> >
> >
> >
> >
> >
>
#####################################################################
> ###
> > Attention:
> > This email message is privileged and confidential. If you are
not
> the
> > intended recipient please delete the message and notify the
> sender.
> > Any views or opinions presented are solely those of the author.
> >
> > This email message has been scanned for Viruses and Content and
> cleared
> > by MailMarshal SMTP
> >
> > For more information go to http://www.ramsys.com
> >
>
#####################################################################
> ###
> >
> >
> > [Non-text portions of this message have been removed]
> >
>



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links