02.01.2013 [DBReportDesigner]
- BUG: CLogic/RsCreate split Fieldsliste reset to '|'
because of function with more then one parameters use ','
30.12.2012 [DBReportDesigner]
- BUG: CLogic/RsCreate split Fieldsliste reset to ','
- Strip
29.04.2012 [DBReportDesigner]
- fix bug : functions in SQL-String
- prepared xml2macro.xslt to be a better formed xml-document
20.11.2011 [DBReportViewer]
- fix for Strings, which are only 1 Tab = \t
18.08.2011 [DBReportViewer]
- a new shell argument "AutoPrinting"
* without this argument or set to 0, nothing new happens
* Set to <> 0, in the PreView window the [Print] button ist pushed automatically and the Printer.Setup dialog isn't called.
+ Attention : all other dialogs, if any, will raise.
18.08.2011 [DBReportViewer]
- striped innerloop for copies, because the printer does it by its own.
31.07.2011 [DBReportDesigner]
- read in printer parameters, are set to the printer directly now
- so on Landscape Reports, the printer orientation is set to Lansscape, if you enter into Printers-setup
31.07.2011 [DBReportDesigner]
- Licence link to http://www.gnu.org/licenses/ works now
28.07.2011 [DBReportDesigner]
- Licence in About is visible again.
18.07.2011 [DBReportViewer]
- CVDrawDBText.class : Error handling, if a Iteration is set to the wrong RS
18.07.2011 [DBReportDesigner][DBReportViewer]
- Image handling, save, and read
17.07.2011 [DBReportDesigner]
- before creating PreView in Designer, I set the _object to NULL now, because of hanging App.
03.07.2011 [TestPage][DBReportDesigner][DBReportViewer]
- BackPort: Filechooser DBClick (got from the gambas IDE).
17.06.2011 ======= started to migrade/porting DBreport to gambas3 ====
04.05.2011 [DBReportViewer]
- NEW: added modUtil to DBReportViewer2
- NEW: The Report property 'ArchiveCopy' tries, if file extention is .pdf,
to convert the ps-file to PDF by using ps2pdfwr (if found)
27.11.2010 [DBReportDesigner][DBReportViewer]
- BUG: Filechooser DBClick not fired when file not Exits
- Filechooser, set .Root larger.
- Dirchooser set .Root larger.
20.10.2010 [DBReportDesigner][DBReportViewer]
- BUG: Filechooser, reversed the order, of the assignment of .SelectedPath and .Root.
- BUG: Dirchooser, reversed the order, of the assignment of .SelectedPath and .Root.
04.08.2010 [DBReportDesigner]
- OPT: enhanced Modified Flag after Editor changes
04.08.2010 [DBReportDesigner][DBReportViewer]
- BUG: Filechooser DBClick not fired when empty.
- BUG: Filechooser closing by [X] returned a value.
03.08.2010 [DBReportDesigner][DBReportViewer]
- BUG: database connection Types left empty, when gambas2 was not compiled, but installed on the box.
ga.db.*.la which filled the combobox, don't exist on such installations.
03.08.2010 [DBReportDesigner]
- OPT: Spinbox for Integers in Properties dialog
02.08.2010 [DBReportDesigner][DBReportViewer]
- BUG: Filechoser now loads a file after a DBClick on it.
28.07.2010 [DBReportDesigner]
- BUG : in File-extention complementation and a typo (wrong file-extention) in 'save a template'
27.07.2010 [DBReportDesigner]
- OPT: moved a lot off Images to Stock:Icons (not yet overall)
27.07.2010 [DBReportDesigner]
- NEW: now you can use templates templates, are saved Clipboards
24.07.2010 [DBReportDesigner]
- NEW: started to implement templates = save the Clipboard to a file / restore it from such a file
24.07.2010 [DBReportDesigner]
- OPT: Stock:Icons in PopUp-Menu
22.07.2010 [DBReportDesigner]
- NEW: with Containers, now also NESTED-copy works, all elements on/in are copied.
22.07.2010 [DBReportDesigner]
- OPT: Paste in PopUp-Menu is enabled, if data in the $Clipboard.20.07.2010 [DBReportDesigner]
- OPT: changed the look of the PopUp-Menu
20.07.2010 [DBReportDesigner]
- OPT: changed emplacement for Edit in items PopUp-Menu
19.07.2010 [DBReportDesigner]
- NEW added 'Edit' to items PopUp-Menu, for a easier, quicker access to the Text property
30.05.2010 [DBReportDesigner]
- NEW added Layout as first element to the Properties list (combobox in Properties window)
01.05.2010 [DBReportViewer]
- NEW The Report property 'ArchiveCopy' can have Report-Parameters included when passed as Argument to DBReportViewer
Example : ArchiveCopy=~/DBReport2/Archive/testArchivCopy{one of the Report-Parameters}.pdf
25.04.2010 [DBReportDesigner]
- OPT: Store About-Window size
- New: Sections and Items have a PopUp-Menu (Right-Mouse-Click)
Action, which where possible with both Left and/or Right-Mouse-Click now should only work on Left-Mouse-Click
24.04.2010 [DBReportDesigner]
- OPT: Made About-Window resizeable
21.04.2010 [DBReportDesigner] [DBReportViewer]
- OPT: preparing for gambas3, moving all 'Printer' and 'Draw' - Keywords to a separate module, "_SwitchNext"
29.03.2010 [DBReportViewer]
- BUG: reusing the Images which are stored in the XML-file, so are the reports re-became independently.
A NEW CHANCE FOR THAT (refound a case where it didn't work)
28.03.2010 [DBReportViewer]
- BUG: reusing the Images which are stored in the XML-file, so are the reports re-became independently.
28.03.2010 [DBReportDesigner]
- BUG: smoother copy/move function,
24.03.2010 [DBReportViewer]
- NEW: CallBack to the calling gambas Program with parameters/object
21.03.2010 [DBReportViewer]
- NEW: CallBack to the calling gambas Program (started)
15.03.2010 [DBReportDesigner][DBReportViewer]
- BUG: handle Images which have no Path to a picture
15.03.2010 [DBReportDesigner]
- NEW: Container handling for all elements
14.03.2010 [DBReportViewer]
- OPT: Container handling is finished
07.03.2010 [DBReportViewer]
- NEW The Report property 'ArchiveCopy' can be overwritten by an "ArchiveCopy" passed as Argument to DBReportViewer
Example : ArchiveCopy=~/DBReport2/Archive/testArchivCopy.pdf
06.03.2010 [DBReportViewer]
- NEW: Began to implement a container handling
24.02.2010 [DBReportDesigner]
- BUG: since Revision: 2515 (and gambas2 2.19) from 24.12.2009
* BUG: The ComboBox Click event now is raised correctly when setting the
Text property. ....and found a NULL object when calling RecordSource
20.02.2010 [DBReportViewer]
- NEW detached the TAB-Support form "AutoFit" property. Now all TAB are handled.
16.02.2010 [DBReportViewer]
- NEW TAB-Support added for "AutoFit=TRUE" Labels, actually I fixed it to 72 pt per inch.
14.02.2010 [DBReportViewer]
- BUG : repeated printing with ArchiveCopy works now (File name don't get larger and larger)
14.02.2010 [DBReportDesigner][DBReportViewer]
- NEW made it english 'ArchivCopy' become 'ArchiveCopy'
14.02.2010 [DBReportViewer]
- NEW for new Report property 'ArchivCopy' at printout.
14.02.2010 [DBReportDesigner]
- NEW Report property 'ArchivCopy', should be a Path+file name, if it is filled, at printout a PDF will be created.
The file name ends with a timestamp :
/tmp/testArchivCopy.pdf
becomes by adding & Format(Date(), "yyyymmdd") & Replace(CStr(Time()), ":", "")
/tmp/testArchivCopy20100214130107.408.pdf
04.02.2010 [DBReportViewer]
- BUG: in gambas, the chosen device could not read out by code, if in a session, once the 'Print to file'
was used, and after the target-file is/was not cleared.
29.01.2010 [DBReportViewer]
- BUG: AutoFit in line hight, forgot to get off a testing thing.
27.01.2010 [DBReportViewer]
- BUG: now Number of Copies and Print Range (From/To Page) should work as expected.
Even in "print to file"
27.01.2010 [DBReportViewer]
- BUG: keep last opened file, for use in Open-dialog.
26.01.2010 [DBReportViewer]
- BUG: FViewer.GeneralParams are reset now correctly.
24.01.2010 [DBReportViewer]
- BUG: AutoFit line break
The line break, is at the one of the last " .,;:-/" Char, before it becomes to large.
If nothing is found it will be cut at FontWidth - 4 Char
-- Oh, forgot to say, existing LF are still kept. --
22.01.2010 [DBReportViewer]
- BUG: Warning, when starting DBReportViewer2 first time with the new config.
(Change from 06.01.2010 and 07.01.2010)
22.01.2010 [DBReportDesigner][DBReportViewer]
- BUG: correcting typo .foother, became .footer
21.01.2010 [DBReportDesigner][DBReportViewer]
- NEW : new Property for Label, DBText and Compute Items : AutoFit.
If AutoFit=TRUE, the Viewer, resize the hight of the item and of the section, if necessary.
The line break, is at the last BLANK, before it becomes too large.
All Items who's TOP (Y) starts underneath the bottom of an AutoFitted Item, will be moved, when the Item is resized.
10.01.2010 [DBReportDesigner][DBReportViewer]
- NEW : DB-Conection dialog : the proposed db-types, depends on the box installed gambas-db-drivers.
07.01.2010 [DBReportDesigner]
- BUG: projects who use DBReportDesigner can't find /xml and /Macros
To know DBReportDesigner has to be started one time at first to create ~/DBReport2 and copy the files/dirs.
06.01.2010 [DBReportDesigner][DBReportViewer]
- NEW : moved the config file app.cfg to ~/DBReport2, also /xml and /Macros
DBReportDesigner2 and DBReportViewer2 use them
the directorys /xml and /Macros from /DBReportDesigner2, are used to update by every start all
concerned files in ~/DBReport2
DBReportViewer2 use that directory also.
~/DBReport2 is hard coded.
06.01.2010
[EVERYWHERE in that project]
- BUG: removed all gambas database drivers from the requirements and project components (which created problems)
03.01.2010 [DBReportViewer]
- BUG: Only the parameters which are not passed, will be requested in the parameters dialog
06.12.2009 [DBReportDesigner]
- BUG: CLogic, gettingArgusPreview, reactivated the pass parameters,
eliminated on 26.11.2009
01.12.2009 [DBReportViewer]
NEW : gave buttons a picture, gave buttons a shortcut, added a Close button
NEW : save Windows size
01.12.2009 [DBReportDesigner]
NEW : made Field-Header visible in RecordSource Test-Tab
30.11.2009 [DBReportDesigner][DBReportViewer]
NEW : added Charset Support for DB-Connections, the converting, is made just before the output.
30.11.2009 [DBReportViewer]
BUG : Report-Parameters refeshed when loading different Report-Templates
30.11.2009 [DBReportDesigner]
BUG : DB-Connections are reset (disconnected) now, if changes are made
29.11.2009 [DBReportDesigner]
BUG: in NEW Report DB and RS Dialog raised twice
BUG: in EXIT-SAVE SAve-Dialog raised twice when CANCLE Save
29.11.2009 [DBReportViewer]
- Report-Parameters: are used now in
RecordSource
Computed Label
Label
- Added ChangeLog
29.11.2009 [DBReportDesigner]
- made Dir-Dialog resizeable
- store and use some windows dimension
26.11.2009 [DBReportDesigner][DBReportViewer]
- Implemented read/write relativ-path for all file-operations.
26.11.2009 [DBReportDesigner]
- BUG: CLogic, gettingArgusPreview
23.11.2009 [DBReportDesigner]
EXIT-Dialog "you really want to exit" "Yes" "No"
13.11.2009 [DBReportDesigner]
- hopefully found the crash when leaving Designer (only when used as component) by the [X]
and closed the calling/using Application too quick
12.11.2009 [DBReportDesigner]
- Fixed a couple of bugs (which came also from my innocence to expand functionality)
- RecordSource TEST should work now with more then one .(dot) in the fields name.
11.11.2009 [DBReportViewer]
- DBReportViewer can handle now the new report wide parameters
11.11.2009 [DBReportDesigner]
- RecordSource Parameters do no more exist, not filled, not saved.
- Now we have report wide parameters, which can be edit in the Toolbar or in Recordsources.
- These Parameters now are shown in every RecordSource.
09.11.2009 [DBReportDesigner]
- avoid a possible bug due on asyncron timers
09.11.2009 [DBReportDesigner]
- Report-Parameters placed in Toolbar
- A dblClick, copy the Report-Parameters-name to Clipboard and set it to the end of a Label(if one)
- Set some ToolTips
- Added picture to _init parameters
08.11.2009 [DBReportDesigner]
- reordered /doc directory
- added startup QUICK GUIDE.html
08.11.2009 [DBReportDesigner]
- Checking Report-Parameters against Recordsource-Parameters
and Recordsource-Parameters against Report-Parameters.
08.11.2009 [DBReportViewer]
- Read the new Report-Parameters from XML
04.11.2009 [DBReportDesigner]
- Added Parameters and Parameter-Dialog for which could be used all
over the Report. Dialog is like Recordsource-Parameters.
! The ReportViewer part is not written yet.
04.11.2009 [DBReportDesigner]
- Started About/Help etc.
11.10.2009 [DBReportDesigner]
- canges in CTOOLDBField, because Field is filled with the table,
if the tablename is used in fieldname.
05.10.2009 [DBREportViewer]
Printing !ERROR! if a NULL should be Formated
05.10.2009 [DBReportDesigner][DBREportViewer]
Using Parameters in all RS if not there own, using same name
in all FMessage added to all windows ME.Stacking = Window.Above
03.10.2009 [DBREportViewer][DBREportDesigner][TestPage]
passing, given parameters comming to TestPage,
down to DBREportDesigner and DBREportViewer
03.10.2009 [DBREportViewer]
BUGFIX for page number: computed fields are now evaluated at exec time,
but, we copy recordsources values at (or after) constructor.
made some changes to CVDrawCompute, because The dots and when more then
one RS which are parented.
02.10.2009 [DBREportViewer]
added a call to post constructor _post_new()
the section is required by CVDrawCompute._post_new()
Example of computed field: iif(len(myrs_myfield)>30,'big','normal')
21.09.2009 [DBREportViewer]
changed CVDrawDBText converting String to Number.
Val didn't work in every case , hope its better now.
17.09.2009 [DBREportDesigner]
finished CTOOLMSave to not aske for a file-name if it is given
14.09.2009
replaced all Dialog. calls with the newer kind from gb.form component
catch a possible error in Viewer, when computed-field is badly made.
08.09.2009
made DBReportDesigner a component and worked on the FIDE_close code.
Added a simple Report-file management.
01.09.2009
Completed SQLite Dialog in DB-Connection on FDBConnection
While changing to SQLite, User and Password are set to "".
The Save User/Password ChkButton.Value set to FALSE
User, Password and Save User/Password ChkButton are no more visible
You have to choose a path to the DB, then the Database.
31.08.2009
FIX: select an sqlite3 file on FDBConnection
01.09.2009
loading templates to designer as argument, while calling
BugFix in FDBConnection (see mail from Christian)
20.08.2009
BUGFIX: Sorting recordsources
09.08.2009
RS-rename with RS-childs
FIX: bug when save unsorted RS-child and RS-parent
04.08.2009
RS-Params, changing Name, refresh List, check against List and Fields
02.08.2009
Setting a Tested-flag on Recordsources which is stored for each RS.
If RS are checked, Tested-flag is set to TRUE
Viewer: can read that Tested-flag
Check the RS, needs now only the params, not the tparams.
only tparams which are empty will pop up the parameter dialog.
RS-Params can be edit now
RS-Names names changed if not used in ParentRs
28.07.2009
Viewer: passing (for use in Gambas) user and password, when not stored
26.07.2009
Option: store User/Password , default = FALSE
Stored User/Password are scrambled.
23.07.2009
shorted default Text for new Connections and RecordSources
enable/disable ToolButtons, when first action is Connection
Select to Table in Tableslist when find in Recordsource SQL
Added * to Recordsource-Fieldlist
Using CDBRecordSource.Dropped to eliminate some ugly messages
eliminate many messages to direct-window
22.07.2009
rearranged connections, you cloud open more then one connection, and have sqlite2, sqlite3 and odbc
empty Error.Text are no more shown in FMessage
20.07.2009
some bug fixes on recordsource
No save on some conditions
SQL destroyed when adding a new recordset
Now, each recordset is executed when press the accept button
19.07.2009
change Section-Label size when Paper Size/Orientation or MarginLeft/MarginRight changes
In GetIterations the last gb.NewLine is cut, for not having an empty entry in FSelector
Properties choose list (combobox): make visible "<->" if Item is visible
Ensure that Paste item(s) into another Item is not possible
Found after Ctrl+C a yellow Item unter the Item.
18.07.2009
keep also 'Lastfile' uptodate after 'SaveAs'
changed, (need Ctrl for selection moving)
selecting/moving Items with mouse, while
press Ctrl 'multi selecting mode' no movment at all
press Shift 'single selecting mode' no movment at all
press Ctrl + Shift 'vertically fixed mode' no movment left/right
press Ctrl + Alt 'horizontal fixed mode' no movment up/down
17.07.2009
Show file name in Layout lable
selecting/moving Items with mouse :
press Ctrl + Shift = 'selecting mode' no movment at all
press Shift = 'vertically fixed mode' no movment left/right
press Ctrl = 'horizontal fixed mode' no movment up/down
16.07.2009
returned to with Ctrl+V , SET X/Y to X/Y +5 if it is on the same Section
if not on original Section SET X/Y stay tune.
enable/disable ToolButtons
Recursive Item locking (Item(s) in Item)
15.07.2009
toggle Layer-State with Ctrl+Home
14.07.2009
reactivated/finished Ctrl+P for Preview
reactivated/finished Ctrl+S for Save
changed up/down/left/right on Items to use it with Ctrl
added FLayoutEditor/SelectionToggleSet for toggle Locked-State
toggle Locked-State with Ctrl+Space
12.07.2009
made starting screen less flickering
11.07.2009
Image - handling
10.07.2009
better Dialog for Align properties
09.07.2009
using spec. char like Euro ([AltGr]+[E]) the Designer and Viewer crasch.
was/is a gambas problem, found a work around
08.07.2009
Std.Macros for Border and Locked
07.07.2009
unset Items/Sections Locked Stat when an Item is copyed
show Items/Sections Locked Stat colored
finished proposing last file for open
06.07.2009
predefined Font for the Report
after Ctrl+V , look if visible in Section .... SET X/Y to 0
locking Items/Sections (no more move with the Mouse)
Selection Editor for Aligne Property
05.07.2009
Saving RecordSources without TEST
properties choose list (combobox), Incl nested Items
changes because of the Properties chooselist : while delete Items or Sections
working with a temp-file (for preview)
after Ctrl+C unset the Focus from the Item and set it to the Section
making Sections sortable (moving up/down not changing Order) using CTRL+UP and CTRL+DOWN
-Bug fixes
+ replaced id by idnum
+ *.macro
--------------------------------------------------------------------------------
soportar color transparente
2005-09-08
New Property: "Layer" Send to back or bring to front
Small buttons
How delete a Param no more needed.(DBReportDesigner-0.0.3)?
BUG - No way from IDE, :-(
FIXED
2005-01-12
hecho - añadir posibilidad de redimensionar los controles con el mouse
hecho - Archivo de configuración para recordar tamaño, disposición de las ventanas
hecho - URGENTE permitir cambiar las propiedades de la pagina (margenes, tamaño)
hecho - URGENTE errores al no existir la base de datos
hecho - mejorar gestión de las propiedades, ahora metodo copiado de gambas
hecho - reducir cantidad de forms para propiedades
hecho - avisar para grabar si modificado
hecho - avisar para grabar si modificado antes del preview
hecho - _Init script
hecho - Agregar preview/print del reporte sin necesidad de abrir el viewer
hecho - URGENTE convertir a XML
hecho - URGENTE incorporar la imagen al archivo *.xml base64
hecho - URGENTE permitir eliminar secciones
hecho - URGENTE permitir cambiar el orden de las secciones
hecho - URGENTE mejorar aspecto del selector (FSelector)
hecho - URGENTE renombrar clases del "viewer" para diferenciarlas del "designer"
hecho - URGENTE crear secciones automáticamente según recordsets
hecho - No circular reference warnings, (clean free ?)
hecho - Añadir selección y ejecución de macros
2004-11-17
pre-alpha version