Multiple instances of same table

[FireGeek21]

In Crystal Reports XI, can you pull in multiple instances of the same table? If so, I understand you would probably have to give each an alias. How would you go about linking? Selection Formulas? Can anyone give an example of how to do this? THANKS!

RSGeek

 

[IanWaterman]

Just add the table again and Crystal will prompt with an Are you sure you want to add this table again? Just click yes and it will be added with tablename_1.

In Database expert you can rename to make it more meaningful.

Ian

 

[FireGeek21]

Thanks Ian for your response.

I already did this and renamed each table. My record count is inflated and was troubleshooting why this could be. I am familiar with pulling in the same table multiple times with Report Smith but wasn't sure if it could "legally" be done in Crystal.

 

[IanWaterman]

Have you joined table in on the linking screen in database expert.

If not you will have a cartesian join and gets a huge dataset returned.

Ian

 

[fsreport]

Hi
Try creating a view on the database

fsreport

 

[FireGeek21]

Ian, yes I did link them. FSReport, we are unable to create a view on the database (long story as to why).

I think the issue is in OLE, there is a Command with PAEMPLOYEE, EMDEPEND and EMPLOYEE already linked. BENEFITS is then brought in twiced (renamed each time - HL and DN) and HRDEPBEN is also brought in twice (renamed each time HL_DEP and DN_DEP).

In rebuilding this in ODBC, I am attempting to recreate the same setup. So, in replicating what was build with Command, I am bringing in PAEMPLOYEE, EMDEPEND and BENEFITS each separately and linking 1:1 between PAEMPLOYEE and EMPLOYEE and 1:many between PAEMPLOYEE and EMDEPEND.

The next join is 1:many PAEMPLOYEE to HL and 1:many PAEMPLOYEE to DN. Finally a 1:many HL to HL_DEP and 1:many DN to DN_DEP.

The record count is seriously inflated and I need to bring it down. Anyone experienced in converting Lawson OLE reports to ODBC???

RSGeek