naikniket.31

I am using crosstab to show students marks and for that i want to print students records in same row instead of after completing all records and printing again. Please look attached images for better idea I have tried all possible ways i can but no luck. Any guidance and help will be much appreciated :)

@jgust, No, it is not what I want. Using this approach, it surly displays two columns but not all present on one side, and all absent on another side.

Please check following dataset Now I want to display these results as below How can I achieve this. I am using Jasper Studio

I am at a learning phase for Jasper reports. I am using SQL Server & Stored Procedures to create a jasper report. I have created a stored procedure that returns multiple results sets. Please check the below code, SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo].[usp_test] ASBEGINSET NOCOUNT ON; SELECT * FROM MEMBER WHERE ID =1; SELECT * FROM MEMBER_DTL WHERE FK_MEMBER = 1; SELECT * FROM MEMBER_BANK_DTL WHERE FK_MEMBER=1; ENDGO[/code]Now, when I execute the stored procedure using EXEC usp_test into the query pane, it only generates fields from the first result set. I don't want to create sub reports(if possible as there will be more than 10 results sets sometimes and also when I will create a subreport then also it will generate the same fields from 1st result set which is not feasible). So, how can I generate multiple datasets from these result sets and display them one by one whenever I needed.

Have you soled it by any means?

I am using jasper studio and I want to print a Group-wise sum in another group footer for better understanding take a look below. Class Group Header: Class One Student Group Header: Student One Subject | Total Marks | Obtained Marks ABC | 100 | 50 PQR | 100 | 80 AER | 100 | 30 Student Group Footer: Student One Total Obtained Marks: 160 Student Group Header: Student Two Subject | Total Marks | Obtained Marks ABC | 100 | 20 PQR | 100 | 10 AER | 100 | 30 Student Group Footer: Student Two Total Obtained Marks: 60 Here above I can print each student's obtained marks separately in the student group footer, but I want to print the same in the Class group footer which means I want output like below Class Group Header: Class One Student Group Header: Student One Subject | Total Marks | Obtained Marks ABC | 100 | 50 PQR | 100 | 80 AER | 100 | 30 Student Group Header: Student Two Subject | Total Marks | Obtained Marks ABC | 100 | 20 PQR | 100 | 10 AER | 100 | 30 Class Group Footer: Student One Total Obtained Marks: 160 Student Two Total Obtained Marks: 60 How can I achieve this result? Thank you in advance :)