Geek Answers Handbook

How to create custom custom reports in Excel based on a template

How Excel can be used to create custom end-user reports. Data must be obtained from an Oracle or SQL Server database based on some queries and reports that must be generated in Excel.

I want to develop a solution for the end user (with knowledge of Excel and writing database queries) to generate reports in accordance with its changing requirement so that it does not depend on the development team for today's change in report requirements.

I developed this type of application using the previously received C # and Crystal reports, which requires three things: 1. Crystal report template with database query 2. Filtering criteria (by which data will be read from the database). 3. Dynamic user control (for example, text field, drop-down, etc.) According to the filter criteria. Management required (defined in the database table by the end user).

If the end user is familiar with Crystal report design, he can create his own crystal report template with a database query built into the crystal report. My software generates dynamic user controls defined in the database for this report template. These filter criteria are passed to the query defined in the Crystal report so that the desired report can be generated according to its filter criteria. This helped him on the day of the catering to communicate the corresponding changing requirements.

Now I want to create a similar solution using Excel, that is, replace the Crystal report template with an Excel template. My initial suggestion is that I replaced the crystal report with an excel template with a small fixed parameter and several variable report parameters (which will come from the database as requested), the rest I will use from my earlier solution.

I dont know

  • How to define report parameters in Excel?
  • How to create a multi-page report page (when the database returns a data set of more than one record)?
  • How to make a paginate report like crystal report when the results will be displayed on several pages?
  • How to define a header and footer header in Excel to display multiple report pages?

, ( Excel), , , # , ( ) / , (# Crystal report).

, , .

. .

+5
2

, , Excel , Crystal Reports. Excel, , . Excel " " Excel.

Excel?

Excel , , , Crystal Reports. # VSTO, ( ) . VBA/VSTO Excel (QueryTables, ListObjects ), . , , , "".

( )?

, , ?

, . , Crystal Reports (, " ", " " ..), Excel, . Excel Crystal Reports, , . Excel , " " ? ( Excel )? , , , , .

Excel mulitple page report

, , . , , , "" ( , ..). " ", .

, Excel . Excel , , , - Excel, ( VBA).

+2

:

Excel (.XLS .XLSX) #

Excel . . . , , ..

, , , Excel .

+1

More articles:


All Articles