02.01.2013 [DBReportDesigner]
- BUG: CLogic/RsCreate split Fieldsliste reset to '|'
because of function with more then one parameters use ','
30.12.2012 [DBReportDesigner] 29.04.2012 [DBReportDesigner] 20.11.2011 [DBReportViewer] 18.08.2011 [DBReportViewer] 18.08.2011 [DBReportViewer] 31.07.2011 [DBReportDesigner] 31.07.2011 [DBReportDesigner] 28.07.2011 [DBReportDesigner] 18.07.2011 [DBReportViewer] 18.07.2011 [DBReportDesigner][DBReportViewer] 17.07.2011 [DBReportDesigner] 03.07.2011 [TestPage][DBReportDesigner][DBReportViewer] 17.06.2011 ======= started to migrade/porting DBreport to gambas3 ==== 04.05.2011 [DBReportViewer] 27.11.2010 [DBReportDesigner][DBReportViewer] 20.10.2010 [DBReportDesigner][DBReportViewer] 04.08.2010 [DBReportDesigner] 04.08.2010 [DBReportDesigner][DBReportViewer] 03.08.2010 [DBReportDesigner][DBReportViewer] 02.08.2010 [DBReportDesigner][DBReportViewer] 27.07.2010 [DBReportDesigner] 27.07.2010 [DBReportDesigner] 24.07.2010 [DBReportDesigner] 24.07.2010 [DBReportDesigner] 22.07.2010 [DBReportDesigner] 22.07.2010 [DBReportDesigner] 20.07.2010 [DBReportDesigner] 19.07.2010 [DBReportDesigner] 30.05.2010 [DBReportDesigner] 01.05.2010 [DBReportViewer] 25.04.2010 [DBReportDesigner] 24.04.2010 [DBReportDesigner] 21.04.2010 [DBReportDesigner] [DBReportViewer] 29.03.2010 [DBReportViewer] 28.03.2010 [DBReportViewer] 28.03.2010 [DBReportDesigner] 24.03.2010 [DBReportViewer] 21.03.2010 [DBReportViewer] 15.03.2010 [DBReportDesigner][DBReportViewer] 15.03.2010 [DBReportDesigner] 14.03.2010 [DBReportViewer] 07.03.2010 [DBReportViewer] 24.02.2010 [DBReportDesigner] * BUG: The ComboBox Click event now is raised correctly when setting the 16.02.2010 [DBReportViewer] 14.02.2010 [DBReportViewer] 14.02.2010 [DBReportDesigner][DBReportViewer] 14.02.2010 [DBReportViewer] 14.02.2010 [DBReportDesigner] 27.01.2010 [DBReportViewer] 27.01.2010 [DBReportViewer] 26.01.2010 [DBReportViewer] 24.01.2010 [DBReportViewer] 22.01.2010 [DBReportViewer] 22.01.2010 [DBReportDesigner][DBReportViewer] 21.01.2010 [DBReportDesigner][DBReportViewer] 10.01.2010 [DBReportDesigner][DBReportViewer] 07.01.2010 [DBReportDesigner] 06.01.2010 [DBReportDesigner][DBReportViewer] 03.01.2010 [DBReportViewer] 06.12.2009 [DBReportDesigner] 01.12.2009 [DBReportViewer] 01.12.2009 [DBReportDesigner] 30.11.2009 [DBReportDesigner][DBReportViewer] 30.11.2009 [DBReportViewer] 30.11.2009 [DBReportDesigner] 29.11.2009 [DBReportDesigner] 29.11.2009 [DBReportViewer] 29.11.2009 [DBReportDesigner] 26.11.2009 [DBReportDesigner][DBReportViewer] 26.11.2009 [DBReportDesigner] 23.11.2009 [DBReportDesigner] 13.11.2009 [DBReportDesigner] 12.11.2009 [DBReportDesigner] 11.11.2009 [DBReportViewer] 11.11.2009 [DBReportDesigner] 09.11.2009 [DBReportDesigner] 09.11.2009 [DBReportDesigner] 08.11.2009 [DBReportDesigner] 08.11.2009 [DBReportDesigner] 08.11.2009 [DBReportViewer] 04.11.2009 [DBReportDesigner] 04.11.2009 [DBReportDesigner] 11.10.2009 [DBReportDesigner] 05.10.2009 [DBREportViewer] 05.10.2009 [DBReportDesigner][DBREportViewer] 03.10.2009 [DBREportViewer][DBREportDesigner][TestPage] 03.10.2009 [DBREportViewer] made some changes to CVDrawCompute, because The dots and when more then 21.09.2009 [DBREportViewer] 17.09.2009 [DBREportDesigner] 14.09.2009 08.09.2009 01.09.2009 31.08.2009 01.09.2009 20.08.2009 09.08.2009 04.08.2009 02.08.2009 28.07.2009 26.07.2009 23.07.2009 22.07.2009 20.07.2009 19.07.2009 18.07.2009 17.07.2009 16.07.2009 15.07.2009 14.07.2009 12.07.2009 11.07.2009 10.07.2009 09.07.2009 08.07.2009 07.07.2009 06.07.2009 predefined Font for the Report 05.07.2009 Saving RecordSources without TEST -Bug fixes 2005-09-08 How delete a Param no more needed.(DBReportDesigner-0.0.3)? 2005-01-12
- BUG: CLogic/RsCreate split Fieldsliste reset to ','
- Strip
- fix bug : functions in SQL-String
- prepared xml2macro.xslt to be a better formed xml-document
- fix for Strings, which are only 1 Tab = \t
- 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.
- striped innerloop for copies, because the printer does it by its own.
- 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
- Licence link to http://www.gnu.org/licenses/ works now
- Licence in About is visible again.
- CVDrawDBText.class : Error handling, if a Iteration is set to the wrong RS
- Image handling, save, and read
- before creating PreView in Designer, I set the _object to NULL now, because of hanging App.
- BackPort: Filechooser DBClick (got from the gambas IDE).
- 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)
- BUG: Filechooser DBClick not fired when file not Exits
- Filechooser, set .Root larger.
- Dirchooser set .Root larger.
- BUG: Filechooser, reversed the order, of the assignment of .SelectedPath and .Root.
- BUG: Dirchooser, reversed the order, of the assignment of .SelectedPath and .Root.
- OPT: enhanced Modified Flag after Editor changes
- BUG: Filechooser DBClick not fired when empty.
- BUG: Filechooser closing by [X] returned a value.
- 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
- 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'
- OPT: moved a lot off Images to Stock:Icons (not yet overall)
- NEW: now you can use templates templates, are saved Clipboards
- NEW: started to implement templates = save the Clipboard to a file / restore it from such a file
- OPT: Stock:Icons in PopUp-Menu
- NEW: with Containers, now also NESTED-copy works, all elements on/in are copied.
- OPT: Paste in PopUp-Menu is enabled, if data in the $Clipboard.20.07.2010 [DBReportDesigner]
- OPT: changed the look of the PopUp-Menu
- OPT: changed emplacement for Edit in items PopUp-Menu
- NEW added 'Edit' to items PopUp-Menu, for a easier, quicker access to the Text property
- NEW added Layout as first element to the Properties list (combobox in Properties window)
- 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
- 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
- OPT: Made About-Window resizeable
- OPT: preparing for gambas3, moving all 'Printer' and 'Draw' - Keywords to a separate module, "_SwitchNext"
- 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)
- BUG: reusing the Images which are stored in the XML-file, so are the reports re-became independently.
- BUG: smoother copy/move function,
- NEW: CallBack to the calling gambas Program with parameters/object
- NEW: CallBack to the calling gambas Program (started)
- BUG: handle Images which have no Path to a picture
- NEW: Container handling for all elements
- OPT: Container handling is finished
- 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
- BUG: since Revision: 2515 (and gambas2 2.19) from 24.12.2009
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.
- NEW TAB-Support added for "AutoFit=TRUE" Labels, actually I fixed it to 72 pt per inch.
- BUG : repeated printing with ArchiveCopy works now (File name don't get larger and larger)
- NEW made it english 'ArchivCopy' become 'ArchiveCopy'
- NEW for new Report property 'ArchivCopy' at printout.
- 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.
- BUG: now Number of Copies and Print Range (From/To Page) should work as expected.
Even in "print to file"
- BUG: keep last opened file, for use in Open-dialog.
- BUG: FViewer.GeneralParams are reset now correctly.
- 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. --
- BUG: Warning, when starting DBReportViewer2 first time with the new config.
(Change from 06.01.2010 and 07.01.2010)
- BUG: correcting typo .foother, became .footer
- 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.
- NEW : DB-Conection dialog : the proposed db-types, depends on the box installed gambas-db-drivers.
- 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.
- 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)
- BUG: Only the parameters which are not passed, will be requested in the parameters dialog
- BUG: CLogic, gettingArgusPreview, reactivated the pass parameters,
eliminated on 26.11.2009
NEW : gave buttons a picture, gave buttons a shortcut, added a Close button
NEW : save Windows size
NEW : made Field-Header visible in RecordSource Test-Tab
NEW : added Charset Support for DB-Connections, the converting, is made just before the output.
BUG : Report-Parameters refeshed when loading different Report-Templates
BUG : DB-Connections are reset (disconnected) now, if changes are made
BUG: in NEW Report DB and RS Dialog raised twice
BUG: in EXIT-SAVE SAve-Dialog raised twice when CANCLE Save
- Report-Parameters: are used now in
RecordSource
Computed Label
Label
- Added ChangeLog
- made Dir-Dialog resizeable
- store and use some windows dimension
- Implemented read/write relativ-path for all file-operations.
- BUG: CLogic, gettingArgusPreview
EXIT-Dialog "you really want to exit" "Yes" "No"
- hopefully found the crash when leaving Designer (only when used as component) by the [X]
and closed the calling/using Application too quick
- 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.
- DBReportViewer can handle now the new report wide parameters
- 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.
- avoid a possible bug due on asyncron timers
- 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
- reordered /doc directory
- added startup QUICK GUIDE.html
- Checking Report-Parameters against Recordsource-Parameters
and Recordsource-Parameters against Report-Parameters.
- Read the new Report-Parameters from XML
- 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.
- Started About/Help etc.
- canges in CTOOLDBField, because Field is filled with the table,
if the tablename is used in fieldname.
Printing !ERROR! if a NULL should be Formated
Using Parameters in all RS if not there own, using same name
in all FMessage added to all windows ME.Stacking = Window.Above
passing, given parameters comming to TestPage,
down to DBREportDesigner and DBREportViewer
BUGFIX for page number: computed fields are now evaluated at exec time,
but, we copy recordsources values at (or after) constructor.
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')
changed CVDrawDBText converting String to Number.
Val didn't work in every case , hope its better now.
finished CTOOLMSave to not aske for a file-name if it is given
replaced all Dialog. calls with the newer kind from gb.form component
catch a possible error in Viewer, when computed-field is badly made.
made DBReportDesigner a component and worked on the FIDE_close code.
Added a simple Report-file management.
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.
FIX: select an sqlite3 file on FDBConnection
loading templates to designer as argument, while calling
BugFix in FDBConnection (see mail from Christian)
BUGFIX: Sorting recordsources
RS-rename with RS-childs
FIX: bug when save unsorted RS-child and RS-parent
RS-Params, changing Name, refresh List, check against List and Fields
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
Viewer: passing (for use in Gambas) user and password, when not stored
Option: store User/Password , default = FALSE
Stored User/Password are scrambled.
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
rearranged connections, you cloud open more then one connection, and have sqlite2, sqlite3 and odbc
empty Error.Text are no more shown in FMessage
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
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.
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
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
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)
toggle Layer-State with Ctrl+Home
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
made starting screen less flickering
Image - handling
better Dialog for Align properties
using spec. char like Euro ([AltGr]+[E]) the Designer and Viewer crasch.
was/is a gambas problem, found a work around
Std.Macros for Border and Locked
unset Items/Sections Locked Stat when an Item is copyed
show Items/Sections Locked Stat colored
finished proposing last file for open
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
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
+ replaced id by idnum
+ *.macro
--------------------------------------------------------------------------------
soportar color transparente
New Property: "Layer" Send to back or bring to front
Small buttons
BUG - No way from IDE, :-(
FIXED
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