Object identification

[muffntuf]

Has anyone ever identified an object (table) with Crystal Reports for a parameter?

I need to build a formula in a Biz View that identifies whether information is coming from one table or another, if it is then I need to label it with a letter that can be chosen in a parameter in the biz view which will funnel up to the report.

I am using CR10 and CE10.

Thanks,
muffntuf

 

[Madawc]

I'm not sure I follow. If you've got values that may come from more than one source, such as postal address or customer address, then you can repeat the test that tells you where it comes from. Or better, do a boolian:

not isnull({postaladress.id})
and
{postaladress.street <> " "

If this were called @UsePostal, then you could use it selecting addresses and also applying the 'label'. E.g.

if @UsePostal then {basic.id} else @paramit & {basic.id}

Does this help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[muffntuf]

Not quite but here is a different view of this - One table holds quote information, another table holds requisition information. These need to be on the same detail line, but they need a parameter set up to sort either by the quote information or by the requisition information.

We can flag in the table, but the question was asked if we could do it in the semantic layer.

Thanks,
muffntuf

 

[lbass]

Maybe I'm missing something here, but you could do a conditional sort by setting up a string parameter with two options: Quote, Requisition.

Then create a formula {@sort}:

if {?sort} = "Quote" then {quote.field} else {requisition.field}

Use {@sort} as your sort field (report->sort records).

-LB

 

[muffntuf]

Thanks lbass, I thought of that and actually started this out that way, but this is based of a Biz View, so I can't distinguish which table the --oh and maybe I missed disclosing this -- number comes from--which is the same number. They share the same number but I need to tell which table it came from. Hmmm!

There is the quandry.

 

[lbass]

I've never worked with Business Views, but I think you could alias the field name for one of the tables, so you can distinguish them. See page 52 in:

http://support.businessobjects.com/communityCS/TechnicalPapers/ce10_businessview_en.pdf

-LB