Create me a JasperReport

Job ID: 36650070

Budget: ₹1,500 – ₹12,500 INR

I want to have a jasper/crystal report file and i am using crosstab to display state wise cities name and it's respective Ids. Look at the SourceFile.pdf and as you can observe first it will display all rows at once and then again it will print same rows with remaining columns. But what i want is as per destination format.png file.

Look at the result set file to have an idea about how the result set will be look like.

P.S. : You can take your own data of Country,State and City and demonstrate the same. All i want to have the results as per specified format. You will be responsible to make me understand how you have achieved the result. Simple and easy project for an expert developer.
Related categories: Microsoft SQL Server Crystal Reports