[SHARING] WARNING: FML does not obey RECORDLIMIT when it builds hierarchy
All
Just to warn.
1. FML will try to build the hierarchy from a non recordlimited dataset which can result in a huge response time so always extract a subset and then do FML.
2. For some reason blank indent stops working with a record limited report in HTML but it works fine in PDF!This message has been edited. Last edited by: Kerry,
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
February 16, 2009, 12:23 PM
Efrem
When using the in FML, we always read the entire hierarchy from the Reporting Server but only build the 1st level within the tree of the FML Painter. As you click on the plus sign next to an item or search for an item within the hierarchy we well then continue to build the tree based on what is required. This saves time in bringing up the report in the painter and developing a report from scratch.
For your BLANKINDENT issue, SET SHOWBLANKS=ON
Let me know what happens.
February 20, 2009, 05:38 AM
hammo1j
Cheers Efrem
The SET SHOWBLANKS cures the indentation problem with excel.
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo