How can I get one field to display.

[bandarna]

Hi,
I have existing report I need to modify it. Wanted to add a new field and that field needs to display using following sql:

select a.com_balance from [fmdprod1213].[dbo].[commit_hdrs] a,
[fmdprod1213].[dbo].[commit_items] b
where a.com_id = b.com_id
and a.com_xref_num = b.com_xref_num

the above sql returns only one values always. Just wanted to plug in. can anyone help me how can I do this?

-nb

 

[epmo]

Create a subreport

 

[Madawc]

If you already have the tables, you don't need a subreport. Just create a formula field wtih something like

if a.com_id = b.com_id
and a.com_xref_num = b.com_xref_num
then ToText(a.com_balance)
else " "

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP