Table not found on running report

(0) Share

Report

Posted on by Cynthia Audain

1,348

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.

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Mark E 6,451 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Cynthia Audain 1,348 on at

Like (0)

Report

Thank you very much, Mark.

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

Was this reply helpful? Yes No
Verified answer

Mark E 6,451 on at

Like (0)

Report

Glad to help. Please mark as answered.

Was this reply helpful? Yes No