passing an array to parameter

Hi,
i have designed the report for displaying details of a student.student records are fetched using the student id that i pass as parameter to the report.Now i want to pass an array of studentID so that multiple student info can be displayed.How do i do that?

Find more posts tagged with

Comments

mwilliams

Hi levanter, 
 
Take a look at these posts from the devShare: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/535-using-in-like-clause-in-birt/#description'>Using IN/LIKE Clause in BIRT - Tutorials - BIRT Exchange</a> 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/338-birt-parameters-using-in-clause/#description'>BIRT Parameters - using IN clause - Designs & Code - BIRT Exchange</a> 
 
Hope this helps.

levanter

thanks Williams,
i am able to pass the multiple student ids and get the values for that but now i am encountering with a new problem.I have two tables table1 and table2. Table1 containing the details of the stidents like fname,lname etc, where as table2 containing the details of the subjects and marks scored for that particular student.but the problem here is table1 displays all the students firstname and lastname and after that table2 displays the values of all the subjects and marks for all the students.But i wanted to display the fname and lname of a single student and the marks scored by that paticular student in table2 after that it should move to the value of the second student,how to do that???

mwilliams

levanter,

Are you embedding table 2 into table 1, so that each student's subjects and marks details show under their name? What key do you have that ties the two tables together?

levanter

Thanks Michael,
it was my error,actually the table was not linked

mwilliams

levanter,

So, you've got it all working now?

levanter

i am facing a new problem now,
i am having my student details like student id and name in the page header and student marks in the body section.now after displaying details(subject and marks) of one student i want to reset the header details to the next student,there must be some option but i am not getting that.How to do this one???

mwilliams

levanter,

If I understand the issue correctly, you should just need to group the report by student and put the student info into the group header. This should work for changing the student info for each student.

levanter

Thanks a lot Michael,
Its done opened up so many gates to explore.