Can Crystal Reports accept a mapping from a stored procedure from a old report with multiple tables.

Posted on 2013-09-17
Medium Priority
Last Modified: 2013-09-18
Does anyone know if you can map a report from a series of tables to a stored procedure. I have tried and everything breaks. When opening the Visual Linking Expert all the table links are broken. The report does not seem to want to map. Does anyone know if this can be done. Thanks?
Question by:ruavol2
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 39499504
The only way I have ever been able to do that (short of rebuilding the report) is to add the SP to the report (don't link it in and don't refresh the data).

You can then manually map the fields from the SP to the appropriate fields on the report.  By map I mean drag the field on and replace the appropriate field on the report.


Author Closing Comment

ID: 39503495
Obi one......your knowledge knows no bounds.....May the force be with you always....


Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question