Create a subreport FOR A CRYSTAL REPORT

This article has little to do with Asp.net. Asp.net is just a carrier for displaying reports. This section describes how to create a primary report and a subreport.

Let's take a look at the two tables in the database. [fruit] and [fruitkind], the former field [fruitkind_nbr] is a foreign key and the latter's primary key.



To obtain data, you must create two stored procedures [DBO]. [usp_fruit_getall]:


And [DBO]. [usp_fruitkind_getall]:

These two stored procedures will be used when we create a crystal report later.
First, let's take a look at the creation of the main report. In either the first or second real-time operation demonstration, you can click another image window. It was originally intended to make a sound video, but in order to be able to achieve real-time, and do not want users to install any player to see it, it is still possible to make a GIF image.




The following real-time operation demonstration focuses on how to create a subreport and how to customize the big data format. Some of the processes are Asp.net: