How to create detail sub report and main report in crystal?

Question

Hello,

I want to know how to create detail sub report and main report like bellow picture in crystal from different store procedure.

In my report, the data in main report is from one store procedure and the data in detail report is from other store procedure . How can I relationship between two reports (Main report and sub report) depending Department or Month?  

 

In the following picture, the total allowance in Department-Admin (Main report) is the total allowance of the department. The data in Detail-Allowance (Sub report) is all allowance type of the total allowance in Department (Admin) for each month.

 

How can I create detail sub report and main report in crystal using visual studio 2010? Please help me.

 

Answer 1

Web technologies are evolving day-by-day and i am not quite up-to-date with the evolution.

 

However, I am pretty certain that you would need some sort of server-side processing. From the way you have framed the question, it seems to me, that you are not quite clear about the request-response model of http protocol on which the web works.

 

Connecting to sql server from javaScript, while might be possible (I am not sure), it is not a very good idea from security perspective, i guess.

 

And where would you put all your business logic?

 

Calling asp.net a front-end would be incorrect. It is a server side technology.

 

You can have all your front-end in HTML5, CSS and Javascript and write a server-side code in WebAPI.

 

You may wish to look into serverless architecture (I still not have looked into!)