FPReport FAQ: what changed
Revision 2 to 3. Removed lines have a minus sign; added lines have a plus sign.
| Old | New | Line | |
|---|---|---|---|
| 1 | - | ||
| 2 | - | ||
| 3 | - | ||
| 4 | - | ||
| 5 | - | ||
| 6 | - | ||
| 7 | - | ||
| 8 | - | ||
| 9 | - | ||
| 10 | - | ||
| 11 | - | ||
| 12 | - | ||
| 13 | - | ||
| 14 | - | ||
| 15 | - | ||
| 16 | - | ||
| 17 | - | ||
| 18 | - | ||
| 19 | 1 | ## General | |
| 20 | 2 | ||
| 21 | 3 | ### Read the README.txt file | |
| 22 | 4 | ||
| 23 | - | ||
| 5 | + | Before you compile the FPReport, have a look at the README.txt | |
| 24 | 6 | ||
| 25 | - | ||
| 7 | + | ### FPReport \<\> LazReport | |
| 26 | 8 | ||
| 27 | - | ||
| 9 | + | FPReport is not LazReport! These are two different reporting systems. | |
| 28 | 10 | ||
| 29 | - | ||
| 30 | - | ||
| 11 | + | - LazReport is based on FreeReport 2.32, see [[LazReport Documentation]]. | |
| 12 | + | - FPReport is written from scratch, see [[FPReport]] documentation. | |
| 31 | 13 | ||
| 32 | 14 | ### Papermanager must registered | |
| 33 | 15 | ||
| 34 | - | ||
| 35 | - | ||
| 36 | - | ||
| 37 | - | ||
| 16 | + | You never registered the standard page sizes with: | |
| 17 | + | ||
| 18 | + | ``` pascal | |
| 19 | + | if PaperManager.PaperCount=0 then | |
| 20 | + | PaperManager.RegisterStandardSi | |
| 38 | 21 | ``` | |
| 39 | 22 | ||
| 40 | 23 | ### Fontmanager | |
| 41 | 24 | ||
| 42 | - | ||
| 43 | - | ||
| 44 | - | ||
| 45 | - | ||
| 46 | - | ||
| 47 | - | ||
| 48 | - | ||
| 49 | - | ||
| 25 | + | Your report used LiberationSans font. Make sure you added the search paths to the font cache. eg: | |
| 50 | 26 | ||
| 51 | - | ||
| 27 | + | ``` pascal | |
| 28 | + | {$IFDEF UNIX} | |
| 29 | + | gTTFontCache.SearchPath.Add(GetUserDir + '.fonts/'); | |
| 30 | + | gTTFontCache.SearchPath.Add('/data/devel/Wisa/fonts/Liberation/'); | |
| 31 | + | gTTFontCache.BuildFontCache; | |
| 32 | + | {$ENDIF} | |
| 52 | 33 | ``` | |
| 53 | - | ||
| 54 | - | ||
| 34 | + | ||
| 35 | + | In windows this is usable: | |
| 36 | + | ||
| 37 | + | ``` pascal | |
| 38 | + | gTTFontCache.ReadStandardFonts; | |
| 39 | + | gTTFontCache.BuildFontCache; | |
| 55 | 40 | ``` | |
| 56 | 41 | ||
| 57 | - | ||
| 42 | + | Default Fonts (cDefaultFont and ReportDefaultFont) on | |
| 58 | 43 | ||
| 59 | - | ||
| 60 | - | ||
| 61 | - | ||
| 44 | + | - **Unix** LiberationSans | |
| 45 | + | - **Windows** Arial | |
| 46 | + | - **Not Unix and not windows** Helvetica | |
| 62 | 47 | ||
| 63 | - | ||
| 48 | + | In some environments like Raspbian you may have trouble with the defaults! You may see a message that the font is not found and the report is not generated. | |
| 64 | 49 | ||
| 65 | 50 | ## FPC FPReport | |
| 66 | 51 | ||
| 67 | 52 | ### I did not find FPReport in my FPC dir | |
| 68 | 53 | ||
| 69 | - | ||
| 54 | + | It is located in the FPC\packages\fcl-report dir, but only in FPC trunk (=3.1.1) since rev. 36962 (20 Aug 2017). | |
| 70 | 55 | ||
| 71 | 56 | ### What is the minimum requirement | |
| 72 | 57 | ||
| 73 | - | ||
| 58 | + | Info from the mailing list - FPC 2.6.4 (and Lazarus 1.6.2), but you will need to copy some additional units from the trunk version of the FPC source repo (in particular, fpexprpars, and fcl-pdf) and the Lazarus trunk repo too. | |
| 74 | 59 | ||
| 75 | 60 | ### Expression and Variables | |
| 76 | 61 | ||
| 77 | - | ||
| 62 | + | If you use float variables and string values on a non-English configured system you will have problems with the comma as a decimal separator (eg German configured computer). All results will have a dot instead of the the configured value in format setting. This is by design (see Bug report 0036545 and 0036525)! | |
| 78 | 63 | ||
| 79 | - | ||
| 64 | + | *Explanation:* The Value property of a variable is written to the JSON or XML when saving/loading the report: see ReadElement/WriteElement. So it must be in a transportable, locale-neutral format. | |
| 80 | 65 | ||
| 81 | - | ||
| 66 | + | Imagine saving the report to stream and in a File or DB Blob field, then loading it on another PC with different locale settings. If the stream is written with decimal separator, and read with decimal separator there will be an error on load. | |
| 82 | 67 | ||
| 83 | - | ||
| 68 | + | See also SetValue() where Val() is used to create the value from a string. | |
| 84 | 69 | ||
| 85 | 70 | ## Lazarus FPReport | |
| 86 | 71 | ||
| 87 | 72 | ### I did not find FPReport in my Lazarus directory | |
| 88 | 73 | ||
| 89 | - | ||
| 74 | + | Only in Lazarus trunk since rev. 55719 (20 Aug 2017). Look in LAZARUSDIR\components\fpreport there is a runtimepackage lclfpreport.lpk. | |
| 90 | 75 | ||
| 91 | 76 | ### I cannot compile the FPReport packages | |
| 92 | 77 | ||
| 93 | - | ||
| 78 | + | As of 20th January 2019 FPReport does not compile out of the box in 64 bit Lazarus (Windows version at least). It should compile flawlessly in 32 bit Lazarus, though (see also "I did not find FPReport in my Lazarus directory" above). | |
| 94 | 79 | ||
| 95 | 80 | ### Lazarus does not start anymore in Windows | |
| 96 | 81 | ||
| 97 | - | ||
| 82 | + | You need to copy freetype-6.dll and zlib1.dll to your LAZARUSDIR (the folder where lazarus.exe resides). Make sure you use 32 bit DLLs with 32 bit Lazarus and 64 bit DLLs with 64 bit Lazarus. These DLLs are not included. Please see the FreeType [1](https://www.freetype.org/) and Zlib [2](https://www.zlib.net/) project pages for details on how to get them. *Please note that FPReport expects a "freetype**-6**.dll" whereas the install package from freetype.org includes a "freetype6.dll" (without the dash) or a "freetype.dll", so you have to rename the file to "freetype-6.dll" before starting Lazarus.* | |
| 98 | 83 | ||
| 99 | - | ||
| 84 | + | There is a breaking change, the library must be "freetype.dll" in newer versions of fpc (actual fixes32 and trunk) | |
| 100 | 85 | ||
| 101 | 86 | ### My Report does not run/start in Windows | |
| 102 | 87 | ||
| 103 | - | ||
| 88 | + | Start the application from the console, so you can see if some dll's are missing. Normally freetype-6.dll and zlib1.dll are missing. For more information read the README.txt. On FPC 3.3.1 it is freetype.dll instead of freetype-6.dll. Use the correct version for your bitness (32 or 64 Bit) | |
| 104 | 89 | ||
| 105 | 90 | ### My Font is not found in windows | |
| 106 | 91 | ||
| 107 | - | ||
| 108 | - | ||
| 109 | - | ||
| 110 | - | ||
| 111 | - | ||
| 112 | - | ||
| 113 | - | ||
| 114 | - | ||
| 115 | - | ||
| 92 | + | You have to use the Postscript name of the font. For example, under Windows you have the font 'Arial' - this is one of the standard fonts - but you have to write Memo.Font.Name := 'ArialMT' because ArialMT is the correct Postscript name. | |
| 93 | + | ||
| 94 | + | ``` pascal | |
| 95 | + | for i:= 0 to gTTFontCache.Count-1 do begin | |
| 96 | + | try | |
| 97 | + | Memo1.Append(TFPFontCacheItem(gTTFontCache.Items[i]).HumanFriendlyName +'...'+ TFPFontCacheItem(gTTFontCache.Items[i]).PostScriptName); | |
| 98 | + | except | |
| 99 | + | Memo1.Append('ERROR in...'+ TFPFontCacheItem(gTTFontCache.Items[i]).FileName) | |
| 100 | + | end; | |
| 101 | + | end; | |
| 116 | 102 | ``` | |
| 117 | 103 | ||
| 118 | 104 | --- | |
| 119 | - | ||
| 105 | + | *From the Free Pascal wiki, page "FPReport FAQ", as it stood on 2020-01-10 after a change by Trev, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's [[Licensing]] page. If you have concerns about this material, [message the admin](/wiki-contact).* |