Facing Problem: creating reports with pre-defined templates
I am new here. And also new to crystal reports. I have a strange requirement with reporting in Crystal reports. I do not know whether the solution is feasible or not.
I am using Crystal reports for Enterprise 2013 edition.
I am trying to create a template and then allocate cell wise values(like Excel) to the cells in the template. But I am facing the problem while assigning values to these cells from the data source.
Steps I followed:
1. Create a Blank Crystal report without data source.
2. Create a Data connection to oracle database/universe.
3. Drag database columns to these cells.(Maybe use intermediate formulas)
But I am facing an issue. whenever I am assigning the columns to these cells. There are multiple pages displayed for each value from the column in the database.
The sample test data and steps are explained the attached excel.