Crystal Reports - Suppressing Entire Group Conditionally

Hi Brian,

If you use a "No Exceptions" label to identify those records/groups - I assume that you'd create some sort of formula to determine that it qualifies as "No Exceptions" - and then couldn't you use that formula in the section suppression?

Just asking - I certainly may have missed something in the complexity of your design -

L.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> If you want, send me a copy of your XML data sample and your RPT file
> directly and I may be able to better visualize a solution for you using
> Crystal.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Thursday, December 09, 2010 3:56 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Reports - Suppressing Entire Group
> Conditionally
>
>
>
>
>
> Yes I am on MSSQL, but that's a whole new set of issues and I wouldn't
> call myself a TSQL expert. That would I think be a step backwards in
> terms of getting this project done at least for me.
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Vic Drecchio
> Sent: Thursday, December 09, 2010 3:52 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Crystal Reports - Suppressing Entire Group
> Conditionally
>
> Brian,
>
> You should be able to do it with global var's. It will be tricky and
> laborious. Have you considered creating a SQL view and perform the
> exception analysis upon the view generation? It would make suppression
> logic much easier on the front-end. (I think you're a SQL customer from
> previous chats...)
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Brian W. Spolarich
> Sent: Thursday, December 09, 2010 2:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Reports - Suppressing Entire Group
> Conditionally
>
> We're implementing Time & Attendance tracking in Vantage (finally!).
> I'm in the midst of writing reports to address various needs not
> anticipated by Vantage.
>
> So first I wrote a daily time and attendance report. The underlying
> BAQ is essentially LaborHed->LaborDtl with some ancillary tables brought
> in to flesh out the details. The detail level of the daily report is
> the LaborDtl data, but it is suppressed since they're just interested in
> daily time punches, lunch info, shop warnings, and indirect. Then I
> include a summary at the bottom showing totals. Lots of little
> formulas, running totals, etc. but not a rocket science report.
>
> The grouping is by employee, then by date, and then by TimeIn punch,
> so three levels before the detail section (suppressed).
>
> Now I want to generate an exception-only report. This isn't too bad
> since I have various group header/footer sections that contain the
> various information that would potentially be exceptions (late/early
> clock punch, not enough lunch, indirect/vacation/personal time, etc.) so
> I can use conditional suppression to get what I want.
>
> Here's the rub - what if there are *no* exceptions? I don't know
> until I get to the end of GroupFooter 2b whether or not there are any
> exceptions for the day. I don't know until I get to the end of Group1
> whether or not there are any exceptions for that employee at all for the
> report period.
>
> Perhaps I'll have to resort to Global variables and lots of
> state-keeping, but I'm thinking that might not even work with the
> multi-pass reporting model as I understand it.
>
> Anyone get what I'm wrestling with and have any ideas?
>
> I suppose I can be lame and display a "No Exceptions" label for each
> bottom-level date section of the report so that at least its not blank,
> but that's obviously a cop-out. Ideally the report should just include
> the potentially-actionable info and I'm stumped.
>
> -bws
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
> [Non-text portions of this message have been removed]
>
> [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/.
> <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
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
We're implementing Time & Attendance tracking in Vantage (finally!).
I'm in the midst of writing reports to address various needs not
anticipated by Vantage.



So first I wrote a daily time and attendance report. The underlying
BAQ is essentially LaborHed->LaborDtl with some ancillary tables brought
in to flesh out the details. The detail level of the daily report is
the LaborDtl data, but it is suppressed since they're just interested in
daily time punches, lunch info, shop warnings, and indirect. Then I
include a summary at the bottom showing totals. Lots of little
formulas, running totals, etc. but not a rocket science report.



The grouping is by employee, then by date, and then by TimeIn punch,
so three levels before the detail section (suppressed).



Now I want to generate an exception-only report. This isn't too bad
since I have various group header/footer sections that contain the
various information that would potentially be exceptions (late/early
clock punch, not enough lunch, indirect/vacation/personal time, etc.) so
I can use conditional suppression to get what I want.



Here's the rub - what if there are *no* exceptions? I don't know
until I get to the end of GroupFooter 2b whether or not there are any
exceptions for the day. I don't know until I get to the end of Group1
whether or not there are any exceptions for that employee at all for the
report period.



Perhaps I'll have to resort to Global variables and lots of
state-keeping, but I'm thinking that might not even work with the
multi-pass reporting model as I understand it.



Anyone get what I'm wrestling with and have any ideas?



I suppose I can be lame and display a "No Exceptions" label for each
bottom-level date section of the report so that at least its not blank,
but that's obviously a cop-out. Ideally the report should just include
the potentially-actionable info and I'm stumped.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
Brian,



You should be able to do it with global var's. It will be tricky and
laborious. Have you considered creating a SQL view and perform the
exception analysis upon the view generation? It would make suppression
logic much easier on the front-end. (I think you're a SQL customer from
previous chats...)







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, December 09, 2010 2:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally





We're implementing Time & Attendance tracking in Vantage (finally!).
I'm in the midst of writing reports to address various needs not
anticipated by Vantage.

So first I wrote a daily time and attendance report. The underlying
BAQ is essentially LaborHed->LaborDtl with some ancillary tables brought
in to flesh out the details. The detail level of the daily report is
the LaborDtl data, but it is suppressed since they're just interested in
daily time punches, lunch info, shop warnings, and indirect. Then I
include a summary at the bottom showing totals. Lots of little
formulas, running totals, etc. but not a rocket science report.

The grouping is by employee, then by date, and then by TimeIn punch,
so three levels before the detail section (suppressed).

Now I want to generate an exception-only report. This isn't too bad
since I have various group header/footer sections that contain the
various information that would potentially be exceptions (late/early
clock punch, not enough lunch, indirect/vacation/personal time, etc.) so
I can use conditional suppression to get what I want.

Here's the rub - what if there are *no* exceptions? I don't know
until I get to the end of GroupFooter 2b whether or not there are any
exceptions for the day. I don't know until I get to the end of Group1
whether or not there are any exceptions for that employee at all for the
report period.

Perhaps I'll have to resort to Global variables and lots of
state-keeping, but I'm thinking that might not even work with the
multi-pass reporting model as I understand it.

Anyone get what I'm wrestling with and have any ideas?

I suppose I can be lame and display a "No Exceptions" label for each
bottom-level date section of the report so that at least its not blank,
but that's obviously a cop-out. Ideally the report should just include
the potentially-actionable info and I'm stumped.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Yes I am on MSSQL, but that's a whole new set of issues and I wouldn't
call myself a TSQL expert. That would I think be a step backwards in
terms of getting this project done at least for me.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 09, 2010 3:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally

Brian,



You should be able to do it with global var's. It will be tricky and
laborious. Have you considered creating a SQL view and perform the
exception analysis upon the view generation? It would make suppression
logic much easier on the front-end. (I think you're a SQL customer from
previous chats...)







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, December 09, 2010 2:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally





We're implementing Time & Attendance tracking in Vantage (finally!).
I'm in the midst of writing reports to address various needs not
anticipated by Vantage.

So first I wrote a daily time and attendance report. The underlying
BAQ is essentially LaborHed->LaborDtl with some ancillary tables brought
in to flesh out the details. The detail level of the daily report is
the LaborDtl data, but it is suppressed since they're just interested in
daily time punches, lunch info, shop warnings, and indirect. Then I
include a summary at the bottom showing totals. Lots of little
formulas, running totals, etc. but not a rocket science report.

The grouping is by employee, then by date, and then by TimeIn punch,
so three levels before the detail section (suppressed).

Now I want to generate an exception-only report. This isn't too bad
since I have various group header/footer sections that contain the
various information that would potentially be exceptions (late/early
clock punch, not enough lunch, indirect/vacation/personal time, etc.) so
I can use conditional suppression to get what I want.

Here's the rub - what if there are *no* exceptions? I don't know
until I get to the end of GroupFooter 2b whether or not there are any
exceptions for the day. I don't know until I get to the end of Group1
whether or not there are any exceptions for that employee at all for the
report period.

Perhaps I'll have to resort to Global variables and lots of
state-keeping, but I'm thinking that might not even work with the
multi-pass reporting model as I understand it.

Anyone get what I'm wrestling with and have any ideas?

I suppose I can be lame and display a "No Exceptions" label for each
bottom-level date section of the report so that at least its not blank,
but that's obviously a cop-out. Ideally the report should just include
the potentially-actionable info and I'm stumped.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]





[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
If you want, send me a copy of your XML data sample and your RPT file
directly and I may be able to better visualize a solution for you using
Crystal.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Thursday, December 09, 2010 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally





Yes I am on MSSQL, but that's a whole new set of issues and I wouldn't
call myself a TSQL expert. That would I think be a step backwards in
terms of getting this project done at least for me.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 09, 2010 3:52 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally

Brian,

You should be able to do it with global var's. It will be tricky and
laborious. Have you considered creating a SQL view and perform the
exception analysis upon the view generation? It would make suppression
logic much easier on the front-end. (I think you're a SQL customer from
previous chats...)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Thursday, December 09, 2010 2:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports - Suppressing Entire Group
Conditionally

We're implementing Time & Attendance tracking in Vantage (finally!).
I'm in the midst of writing reports to address various needs not
anticipated by Vantage.

So first I wrote a daily time and attendance report. The underlying
BAQ is essentially LaborHed->LaborDtl with some ancillary tables brought
in to flesh out the details. The detail level of the daily report is
the LaborDtl data, but it is suppressed since they're just interested in
daily time punches, lunch info, shop warnings, and indirect. Then I
include a summary at the bottom showing totals. Lots of little
formulas, running totals, etc. but not a rocket science report.

The grouping is by employee, then by date, and then by TimeIn punch,
so three levels before the detail section (suppressed).

Now I want to generate an exception-only report. This isn't too bad
since I have various group header/footer sections that contain the
various information that would potentially be exceptions (late/early
clock punch, not enough lunch, indirect/vacation/personal time, etc.) so
I can use conditional suppression to get what I want.

Here's the rub - what if there are *no* exceptions? I don't know
until I get to the end of GroupFooter 2b whether or not there are any
exceptions for the day. I don't know until I get to the end of Group1
whether or not there are any exceptions for that employee at all for the
report period.

Perhaps I'll have to resort to Global variables and lots of
state-keeping, but I'm thinking that might not even work with the
multi-pass reporting model as I understand it.

Anyone get what I'm wrestling with and have any ideas?

I suppose I can be lame and display a "No Exceptions" label for each
bottom-level date section of the report so that at least its not blank,
but that's obviously a cop-out. Ideally the report should just include
the potentially-actionable info and I'm stumped.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]

[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/.
<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





[Non-text portions of this message have been removed]