Crystal 2008 not showing views in SQL server data source

building reports crystal reports
1

When using Crystal Reports 2008 version 12.2.0.290 with SQL Server 2008 …in the ‘Available Data Sources’ tree I can see tables and stored procedures and older views but not the views I just created today.

I have verified that the ‘Data Explorer Options’ for views is checked in both places. I can see older views. I have used the ‘Refresh’ command several times but still don’t see the new views. Any ideas greatly appreciated.

Mikey J (BOB member since 2009-12-11)

2

I had the same problem few weeks ago, You may need to increase the NTablesMax value in your registry on your machine. You must be a administrator or you must have permissions to change the registry on your PC.

Try this :
Start --> Run --> regedit

Go to this path:

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports

Increase the value of NTablesMax to a value that will be good in your environment. Save and exit out of registry.

In the last, re-start your machine and check whether it is showing all the views.

Warning : It is not advisable to modify registry. Take the backup first or take the help of your administrator.

BO_Chief :us: (BOB member since 2004-06-06)

3

I made that change. Gave it a big boost from 8000 to 32000 but I am still unable to see the recently added views. Also tried redoing the ODBC. Still no luck. I am using Windows XP. Any other ideas anyone?

Mikey J (BOB member since 2009-12-11)

4

Make sure you make the change when Crystal Reports is shut down, because closing the application will overwrite your recently changed value back to 8000. So quit your CR, mod the registry, and then reopen CR. There is no need to reboot. This setting controls the number of objects displayed in Database Expert and applies too all objects: tables, views, and stored procedures.

voitek :us: (BOB member since 2009-01-07)

5

OK seems to be working now. Thanks.

Mikey J (BOB member since 2009-12-11)

6

Yes, that worked for me too !! Thanks :smiley:

teejee (BOB member since 2012-03-18)

7

For Crystal 2008 , the path is HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Fetch Options

BBunin (BOB member since 2012-08-15)