I can’t figure out why my ‘Export to RDBMS’ behaves inconsistently.
Sometimes the option is dimmed out and sometimes it is not.
I have both 5.1.4 and 6.1 installed on the same machine. Today when I opened the same report, the 5.1.4 version showed me the option is available and the option for 6.1 is dimmed out.
One thought would be whether you are switching between ZABO (3-tier) or full-client (2-tier) connections. I don’t believe Export to RDBMS is available using a ZABO connection.
When you get to your login screen, do you see a security domain box (in addition to user name and password)? If you do, entries in the drop-down box with a globe icon are ZABO connections, and entries with a computer icon are full-client connections. If you don’t have a security domain box, then it means you are using only one connection and it can’t be the reason for what you are seeing.
Well, I’ve helped to eliminate one possibility, but I’m afraid I’m out of suggestions. Actually, that’s not true. Is the data provider set to be editable / refreshable? Sometimes that can cause seemingly unrelated capabilities (like exporting) to be disabled as well.
You need to have a Personal Connection and that connection needs to have Create Table rights.
You may also want to Rename your DataProvider, since that is the name of the table that will be created. It’s possible that your DP begins with a numeric value so you may not be able to create a table with that name.