Click here to Skip to main content
15,891,777 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a database.. with two tables....
1. Fee Report with (ReceiptNumber as Primary Key and some other)
2. Fee Detail with (ReceiptNumber as Foreign Key, no primary key (because receipt no is repeating every time)

When I generate XtraReport using these tables my Fee Detail tables values are not displaying..
Fee Report - Receipt No. is working....
But when I Add Detail Report with Fee Detail... My report preview only show me First Table Data.. not second one...
please help....

Second Table contain Which Fees are taken..

Table 1 - Receipt No. 001

Table 2 - Receipt No. 001 Tuition Fee
Receipt No. 001 Late Fee
Receipt No. 001 Misc Fee

(in Table 2 Receipt No. is repeating because Fee Details are here... Which Fees are taken)

please also give me suggestion with database structure.....
I am using SQL Database
Posted
Comments
Jim Jos 28-Oct-13 23:21pm    
Did you have master / detail relationship in the report? Did you give the Sql or report automatically created it..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900