sumithnangunuri Posted May 15, 2018 Share Posted May 15, 2018 For Example,In my main report i am creating the fields which belongs to one table as stated below, Course_ID Course startdate Enddate1198 maths 05-01-2018 11-01-20181199 science 06-01-2018 21-01-2018And i am creating the subreport in the main report,where getting the coursedetails from another table for which the courseid is common for both the tables.At the end report should be in the format ofCourse_ID Course startdate Enddate1198 maths 05-01-2018 11-01-2018 Coures_ID CourseDetails (Subreport) 1198 Maths subject has 8 different topics.1199 science 06-01-2018 21-01-2018 Course_ID CourseDetails (Subreport) 1199 Science subject has 8 different topics.I am not able to pass the main report id to subreport,where my report is not able to generate as the above format report.If anyone helps me i will be much thankfull to them. Link to comment Share on other sites More sharing options...
vitko.dmitriy Posted May 15, 2018 Share Posted May 15, 2018 Join two table in maine report, get all fields and create report Link to comment Share on other sites More sharing options...
sumithnangunuri Posted May 15, 2018 Author Share Posted May 15, 2018 Thank's for your respond you have give .But for my coursedetails column consists of multiple records,where it sholud be get sorted based on the ID.Yes i can club two tables in one report.But does,I can create the above format report.If yes please can you explain the format how to create. Link to comment Share on other sites More sharing options...
lisaws Posted May 15, 2018 Share Posted May 15, 2018 Pass the field value as a parameter to the subreport. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now