Print Page | Close Window

Assign Two Table as data source.

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11383
Printed Date: 02 May 2025 at 10:16am


Topic: Assign Two Table as data source.
Posted By: BhavinBhatt
Subject: Assign Two Table as data source.
Date Posted: 10 Oct 2010 at 6:15pm
Hello All.
I want to assign two data tables which comes from sp from a datset to my crystal report.
how to achieve this. I have assign two sp from database expert of crystal report. but it gives an error regarding incorrect logon paramenters.

when I assign, only one Table. It runs without any error.


Whats the solution?

Thanks.



Replies:
Posted By: hilfy
Date Posted: 22 Oct 2010 at 5:52am
Crystal won't read multiple tables in a result set from an SP.  You would have to split the tables into results from two separate SP's.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window