Blogs

  • Browse Blogs
  • My Blog
  • My Updates

Tags Help

  • View as cloud  | list

Similar Entries

photo

Mac 8.5 Client Issue...

Blog:  Sanity Check
Roland Reddekop
Updated 
No Ratings 0     No Comments 0
photo

Resynching DAOS refe...

Blog:  Chad Scott
Chad Scott
Updated 
Ratings 1     No Comments 0
photo

Domino Bug: how to r...

Blog:  Jan Schulz
Jan Schulz
Updated 
No Ratings 0     Comments 3
photo

Great post you shoul...

Blog:  Lotus Nut
Chris Whisonant
Updated 
No Ratings 0     Comments 1
photo

It is a bug - TIMEZO...

Blog:  Domino Diva
Kim Greene
Updated 
No Ratings 0     No Comments 0

Notes Some Frustrations

Blog Authors:  Darren Briaris  

Main  | Next

Reporting from Notes

Darren Briaris  |     |  Tags:  reporting domino notes  |  Comments (5)
First Post, First Frustration!

How do people report from Domino applications?
we have a one or two large applications which require reporting functionality. They have a number of forms that are related to each other (i.e. Doc A can have many Doc B's - not responses). We need to report from these on a weekly/monthly basis and also on an ad-hoc basis.

Crystal Reports is OK but linking multiple form types is very slow...

JasperReports is OK but unfriendly from the client point of view and relies on NotesSQL... same linking slowness

Cognos - OK but has trouble running SQL queries on multiple tables through NotesSQL driver....

To me an ideal solution would be the DB2 backend as this should allow easy reporting from any app to DB2. I haven't had chance to install an 8 server yet but can an existing app be moved to DB2 backend easily? Are there performance issues?


Does anyone have any comments on how they cope with the Notes reporting issues and any guidance on the best way forward?


Comments

1 James T Kork      Permalink We were also looking for good reporting funktionality.
There are also some major apps we use with millions of dokuments to run reports on. Dont even think of starting to get some export runing.... it is just to slow.
What we found being an intersting app is list and labll http://www.combit.net/en.
That is the tool we might want to test deper sins cr and all the others where either to expensive to slow or to complicated to use.
Give it a try if you need some how to use tricks ping me :-)

2 Brett Patterson      Permalink For most reporting we do out of Notes, we use agents that return the data sets in xml format. Then, some fun xslt stylesheets to put it into the report format we need. Works great, works quickly, but it's all custom designed and hand coded. But, once you get passed all that...

3 James T Kork      Permalink We were also looking for good reporting funktionality.
There are also some major apps we use with millions of dokuments to run reports on. Dont even think of starting to get some export runing.... it is just to slow.
What we found being an intersting app is list and labll http://www.combit.net/en.
That is the tool we might want to test deper sins cr and all the others where either to expensive to slow or to complicated to use.
Give it a try if you need some how to use tricks ping me :-)

4 Sherwin Delfin      Permalink Create IBM Lotus Domino Reports with Open Source Tools (JasperReports).
Learn an easy and inexpensive way to deliver Lotus Domino data into PDF, HTML, XLS, CSV, and XML files.
http://my.advisor.com/doc/19377
Free registration required, though.

5 Johnny Jiang      Permalink Hi Darren,
We just released an opensource reporting tool on openntf.org, it is called Notes Reconn and is based on XML/XSL, hope it helps.

Johnny Jiang


Main  | Next
Skip to main content link. Accesskey S
IBM Lotus Connections Help Tools About

Tags

A tag is a keyword that is used to categorize an entry. To view the entries with a particular tag, click a tag name or enter a tag in the box.
The tag cloud indicates the frequency of tag use. Popular tags appear darkest. The slider control adjusts how many tags are displayed in the tag cloud.