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.
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]
>