Home > Archive > Visual Basic Crystal Reports > April 2005 > multiple lines are show - but just want one
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]
| Author |
multiple lines are show - but just want one
|
|
| Martin Miethe 2005-04-28, 9:02 pm |
| Hello,
a report gives me multiple hits of database entries which are actually
100% identically.
But of course, I want to show every line just one time. How can I
"eliminate" those entries, which occur multiple times?
Thanks a lot in advance
Greetings
| |
| Briscobar 2005-04-28, 9:02 pm |
| In news:4271434a$0$7512$9b4e6d93@newsread2.arcor-online.net,
Martin Miethe <mmiethe@protours.cl> rambled:
> Hello,
>
> a report gives me multiple hits of database entries which are actually
> 100% identically.
> But of course, I want to show every line just one time. How can I
> "eliminate" those entries, which occur multiple times?
> Thanks a lot in advance
> Greetings
Sounds like you have a one-to-many or a many-to-many relationship. You can
try a couple things:
1) Try different links between tables. You may have incorrectly linked them.
2) Create groups, and place your information in the header or footer - not
the details section.
3) Format the fields to "Suppress if duplicated".
HTH.
--
KB - MCNGP "silent thug" #26
Briscobar AT gmail DOT com
Is www.mcngp.com experienced? Well I am...
| |
| Martin Miethe 2005-04-28, 9:02 pm |
| Hi,
> 1) Try different links between tables.
I think thats the actual problem.
But IŽll try with groups.
"Suppress if duplicated" still leaves me spaces between the actual lines..?
Thanks
>
>
> Sounds like you have a one-to-many or a many-to-many relationship. You can
> try a couple things:
>
> 1) Try different links between tables. You may have incorrectly linked them.
> 2) Create groups, and place your information in the header or footer - not
> the details section.
> 3) Format the fields to "Suppress if duplicated".
>
> HTH.
>
| |
| Briscobar 2005-04-28, 9:02 pm |
| In news:4271523a$0$10504$9b4e6d93@newsread4
.arcor-online.net,
Martin Miethe <mmiethe@protours.cl> rambled:
> Hi,
>
>
> I think thats the actual problem.
It usually is with duplicate data, but sometimes there's no better way to
link.
> But IŽll try with groups.
This may be your best bet, especially if you're using running totals/summary
fields.
> "Suppress if duplicated" still leaves me spaces between the actual
> lines..?
You'll need to conditionally suppress the section, then, using a formula
like this:
{Table.Field} = Previous({Table.Field})
This will suppress the entire section if one field is repeated. This may not
work, and you may have to include several (or all) of the fields in that
section in this formula, so that it looks like this:
{Table.Field} = Previous({Table.Field}) and {Table.Field2} =
Previous({Table.Field2}) and {Table.Field3} = Previous({Table.Field3})
etc...
--
KB - MCNGP "silent thug" #26
Briscobar AT gmail DOT com
I modified the signatures.ini file to add this: www.mcngp.com
| |
| Martin Miethe 2005-04-28, 9:02 pm |
| Alright, once again thanks for the answer.
Greetings
>
>
> It usually is with duplicate data, but sometimes there's no better way to
> link.
>
>
>
>
> This may be your best bet, especially if you're using running totals/summary
> fields.
>
>
>
>
> You'll need to conditionally suppress the section, then, using a formula
> like this:
>
> {Table.Field} = Previous({Table.Field})
>
> This will suppress the entire section if one field is repeated. This may not
> work, and you may have to include several (or all) of the fields in that
> section in this formula, so that it looks like this:
>
> {Table.Field} = Previous({Table.Field}) and {Table.Field2} =
> Previous({Table.Field2}) and {Table.Field3} = Previous({Table.Field3})
>
> etc...
>
| |
| Briscobar 2005-04-29, 4:03 pm |
| In news:427158e2$0$7518$9b4e6d93@newsread2.arcor-online.net,
Martin Miethe <mmiethe@protours.cl> rambled:
> Alright, once again thanks for the answer.
Welcome.
--
KB - MCNGP "silent thug" #26
Briscobar AT gmail DOT com
I'm running out of stupid stuff to write. Oh by the way: www.mcngp.com.
|
|
|
|
|