cache multiple database in perform join query

Never cache so many records on IIS or anywhere else

 

the best option for you is to create a view according to your report and show data from it in ASP.Net front end whenever use wants to see report

 

If you are sure the no. of records are going to be 14000 or so only, then go with view.

 

If you had a million or so records, then solution will be different - to create a SQL server job, execute it hourly or so and prepare required datain report tables.

 

but hence you have only some thousand records, creating a view is best solution for you