We are evaluating CR2008 standalone designer.
I tried to specify remote SQL 2005 Express as a datasource for CR2008 using SQL authentication. My sql user has full admin rights and I'm able to see and select views/tables/fields etc in Report Creation Wizard.
After I finish wizard, I always get "The database table .. could not found...Proceed to remove this table from the report?" message. I answer "No" and everything seems working except dynamic parameters based on lookup field - parameter prompt now does not have any drop downs, just plain textbox.
When I click on "Database\Verify database" I get the same warning and then "Database is up-to-date" message.
If I use a database on my local SQL server, everything works as expected.
Any idea what's wrong?
Thanks.