Adding Table with no Linking

[lthomas6]

I have a Crystal 10 report which uses SQL db. The report uses OLE DB and has 4 tables and 3 subreports.

I need to add a table however the table has no joins to any of the other tables. It is a systemsetting table so this should be fine.

Crystal gives error of "Failed to open a rowset.
Query Engine erro: If tables are already linked then the join type cannot change."


It seems Crystal doesn't like adding a table as as standalone.

 

[Turkbear]

Hi,
You may need to use a subreport to add an unlinked table.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

Note that Crystal works by 'Detail Lines'. When there are several tables, it consists of each distinct linked set of tables. An unlinked table won't fit, except by a subreport as Turkbear says.

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

 

[lthomas6]

I can go ahead and add a subreport, however the report has a formula that will need to will need to look at this field.

formula;
if isnull({Security.SecurityCurrency_CD}) then {Systemsetting.item}
else if ({Security.SecurityCurrency_CD} = 'US Dollars') then 'USD'
else right ({Security.SecurityCurrency_CD},3 )

I cannot choose this field from the subreport in the formula editor, it is not showing up.

 

[lbass]

You could share the item from the subreport and then reference the shared variable in your formula.

-LB

 

[Madawc]

Note that values from a subreport are only available in sections below the section that contains the subreport. Right-click on a section margin to create another section at the same level.

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

 

[AndrewBaines]

Try turning off the grouping on server option. You can normally add unlinked tables, just have to be careful that Crystal doesn't try to be too clever.

Andrew Baines

http://www.pursuittechnology.co.uk