You are viewing limited content. For full access, please sign in.

Question

Question

LF Forms - Dashboard

asked on May 3, 2013 Show version history

I recently watched  a LF demo video (from Laserfiche) where you had shown a dashboard for LF Forms, which allowed process information to be displayed in charts, reports, etc… I just can’t seem to find how to navigate to or enact this portion of the project. Could you kindly point me in the right direction?

 

 

0 0

Answer

APPROVED ANSWER
replied on May 3, 2013 Show version history

The Forms dashboard view shown in the demo you’re talking about was built out using SQL Server Reporting Services, a Microsoft tool. The information is all kept in the Forms database; for now, the best way to show an aggregate view like we do in the demo is to use the data in the database to generate a report. There are several products that can do this, such as SQL Server Reporting Services and Crystal Reports.

 

0 0
replied on May 4, 2015

Is there documentation on the database design so we can more easily create these reports?

3 0

Replies

replied on May 4, 2015

I am trying to use SQL reporting service, and fail to connect. what is the proper Connection string to use to connect to the form database and collect the information

0 0
replied on May 4, 2015

ok find how to setup the connection string

0 0
replied on May 4, 2015

That would depend on your SQL security. See SQL Reporting Services documentation for more info as this is not a Laserfiche feature.

0 0
replied on May 4, 2015

yes find it, I test it with an sqlexpress and forget to put the instance. but now the connection and services is running. thanks. only thing I cannot find is the relation between table to get a report for a perticular forms process

0 0
replied on May 4, 2015

Where can we find the relation between the table to build the Query to get information like the forms report grab from the database and create report with SQL report services

0 0
replied on July 27, 2015

Hello,

Is there any update on the dashboard?, we have a client who wants the results of the reports in a dashboard showing the tasks, task assign and things like that. We are trying to create a Report Service to do that, if we need add tables or things like that, can add in the DB formas?, like can we use cdc - change data capture in the forms DB?

Thanks for the help.

0 0
replied on April 25, 2016

Forms 10.1 include performance dashboard and operational dashboard which can show the metrics for instances started or finished and tasks started or finished and detail information on user task distribution.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.