CODEWITHSUNDEEP
c#asp.netsql-servercrystal-reports
LeO
LeO

Reputation: 35

use multiple data source in crystal report

There are 3 procedures. One is having personal detail, Second is having business detail and third contains transaction done by person. In crystal report, i want to use these procedures. Yes, in single report. Requirement is, display personal detail and business detail only on first page when person changes. display all transaction done by person. all 3 data sources contains person_id. Person detail, Business detail and transaction detail, then new page and repeat the same. This is what i want. I am using Visual Studio 2008, C#, WEB_App, SQL-SERVER with basic experience of crystal report. tried some sub-report and grouping but not getting what i want. Need Help or Suggestion. Thanks in Advance...!!

Upvotes: 0

Views: 2774

Answers (1)

LeO
LeO

Reputation: 35

Got it. Adding all data sources with link on person_id. add grouping on basic detail of person_id. added sub report for business detail and set sub report link on person_id. below that added for transaction detail. removed data source of business detail from main report. Thanks for View...!!

Upvotes: 1

Related Questions