Table not found on running report

(0) Share

Report

Posted on by Cynthia Audain

1,270

Hi Everyone

I want to create a simple report to extract the user listing, On viewing the system I recognized that all the information that I required could be found in the Table USERREC which is located in the system database.

I was able to design the report and it ran perfectly within Crystal Reports. However, on running the same in Dynamics SL, I keep getting the below error message that the table is not found. I set the datasource location, check the permissions but cannot seem to be able to figure out what is causing this problem and how to fix it.

Has anyone experience this before and is willing to share the solution or could someone point me in the right direction to get this report to work within SL?

I will appreciate any help that could be given.

Thanks in advance.

All responses (3)

Answers (1)

Verified answer

Mark E 6,405 on at

Like (0)

Report

RE: Table not found on running report

Glad to help. Please mark as answered.
Cynthia Audain 1,270 on at

Like (0)

Report

RE: Table not found on running report

Thank you very much, Mark.

I was able to get the needed information from that view.
Suggested answer

Mark E 6,405 on at

Like (0)

Report

RE: Table not found on running report

Use the vs_userrec view in the Application database to get the info needed from the System DB UserRec table.