I want to create a Report using only a View

+1 vote

How do I create a report using only a stand-a-lone database view.

in Features (Todo) by (5.0k points)

1 Answer

+1 vote

At the moment there is no way to create a report using only a view but there are two great alternatives.

1. Join a View to a Table

A very good work around is to join a view to an appropriate table and then create a report using that table. The benefit is that you can also filter the report contents by the table fields.

See: Table Views

2. Stored Procedure based Reports / Exports

With dbFront you can easily create a Report or Export from a Stored Procedure. The benefit of a Stored Procedure is that it can also take parameters and do additional pre or post processing.

See: Stored Procedure Outputs

NOTE: Please vote on this Feature Request if it interests you.

by (54.2k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer