Modifying Generic Layout to add new tables

[Former Member]

Hello,

I am trying to modify a Generic Layout Crystal Reports provided in SDN. I want to ad a new table (OCRD) in Outgoing Payment Crystal Layout.

I have tried various methods but whenever I add a new field into the report area, I don't get any data on the Preview area.

Can anyone please guide me with the proper steps to modify this Generic Layouts for Crystal Reports?

Regards,

Sanil

[Former Member]

Hi,

Thanks for the responses Svein-Erik and bwuser.

I solved the issue. The problem was CR would always do SMART linking of the new table added. This will mess up the existing links between the tables.

Solution: Disable Automatic Smart Linking from Crystal Reports Options.

Goto: File > Options > Database (tab) > Uncheck Automatic Smart Linking.

Now after adding the new table do the linking between tables as desired.

Regards

Sanil

[Former Member]

Yes Sanil. This option is always check in Crystal Report for Auto-smart linking, Which always create this kind of problem.

One of the major problem that this option create is performance issue.

Glad to know that the issue is solved.

Bwuser

[Former Member]

Hi,

Thanks for the responses Svein-Erik and bwuser.

I solved the issue. The problem was CR would always do SMART linking of the new table added. This will mess up the existing links between the tables.

Solution: Disable Automatic Smart Linking from Crystal Reports Options.

Goto: File > Options > Database (tab) > Uncheck Automatic Smart Linking.

Now after adding the new table do the linking between tables as desired.

Regards

Sanil

[Former Member]

Hi Sanil,

What is the reporting database that we are using?

What is the version you Crystal Reports?

Have you checked if there is any automatic links being created between the tables which is letting crystal reports from displaying any data. Check if proper joins have been created or not?

One more thing you can do to check is that in Field Explorer, right click the field inside OCRD table and select "Browse data" and see if any data can be seen in the window that appear next?

Let me know if that help and update the post with your finding.

- Bwuser

[Former Member]

Hi bwuser,

Thanks for your response.

I am using CR 2008 for SAP B1 with FP3.

SAP B1 8.82 PL 04 version

I specifically did not allow automatic linking to take place when I was adding this new table.

Btw, have you tried doing it for yourself. You can download (link is below) the layouts and import to B1 company and have a look. Just try adding a new table (OCRD) in Outgoing Payments Layout and see if you can preview the data.

http://service.sap.com/~sapidp/011000358700000882672009E/Generic_Layout.zip

Regards,

Sanil

[Sveinjon]

Hi

I assume you have Set Datasource to your own database?

Also check the properties on the tables to be sure that you have updated the server/connection to your settings.

If that is ok, I would suggest you create the link to OCRD with a left join?

Svein Erik