Home > Archive > Visual Basic Crystal Reports > January 2006 > Summary fails
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Alison Givens 2006-01-25, 7:19 pm |
| In a report with several subreports, I add up these Shared Variables.
{@SharedBonnen} + {@SharedContract} + {@SharedImproductief} +
{@SharedProject} + {@SharedRelatie}
This works as long as no of the values is 0. When one of the values is 0, I
get no result at all.
I made the Shared Variables simmilair like here:
Shared NumberVar SharedBonnen := Sum ({AlleGeboekteUrenProductieKps.Bonnen})
What am I doing wrong?
Alison.
| |
| Iain Sharp 2006-01-25, 7:19 pm |
| On Wed, 25 Jan 2006 17:00:10 +0100, "Alison Givens" <info@cross-it.nl>
wrote:
>In a report with several subreports, I add up these Shared Variables.
>{@SharedBonnen} + {@SharedContract} + {@SharedImproductief} +
>{@SharedProject} + {@SharedRelatie}
>
>This works as long as no of the values is 0. When one of the values is 0, I
>get no result at all.
>
>I made the Shared Variables simmilair like here:
>Shared NumberVar SharedBonnen := Sum ({AlleGeboekteUrenProductieKps.Bonnen})
>
>What am I doing wrong?
>
>Alison.
>
>
I bet it's not 0, it's null. Which version of Crystal?
Iain
| |
| Shariq 2006-01-25, 7:19 pm |
| It is NULL that's causing your variable not to print any values; you need to
test for the Nulls like the following and it will be nested in your case:
IF IsNull ({#RT_Body_BUKT1}) then
{#RT_H3}
ELSE
{#RT_H3} + {#RT_Body}
"Alison Givens" wrote:
> In a report with several subreports, I add up these Shared Variables.
> {@SharedBonnen} + {@SharedContract} + {@SharedImproductief} +
> {@SharedProject} + {@SharedRelatie}
>
> This works as long as no of the values is 0. When one of the values is 0, I
> get no result at all.
>
> I made the Shared Variables simmilair like here:
> Shared NumberVar SharedBonnen := Sum ({AlleGeboekteUrenProductieKps.Bonnen})
>
> What am I doing wrong?
>
> Alison.
>
>
>
>
| |
| Alison Givens 2006-01-26, 4:01 am |
| It is NULL that causes it, but I have no idea what your formula is about.
Can you enhance that with my variables? I have no clue with the 'Body' that
you enclosed in your formula.
"Shariq" <Shariq@discussions.microsoft.com> wrote in message
news:78AB58C2-62C0-429A-995D-F405F909690B@microsoft.com...[color=darkred]
> It is NULL that's causing your variable not to print any values; you need
> to
> test for the Nulls like the following and it will be nested in your case:
>
> IF IsNull ({#RT_Body_BUKT1}) then
> {#RT_H3}
> ELSE
> {#RT_H3} + {#RT_Body}
>
>
> "Alison Givens" wrote:
>
|
|
|
|
|