RE: [gnome-db] Re: Multiple queries in report stuff

["Santi Camps Taltavull" <santi camps terrassa org>]

> -> add a simple function to create a Query representing "SELECT * FROM
> my_table": a button in the list of tables tab. Creating such a function
> is already available today but the user must click on the "new query"
> button in the queries page. 
> 
> -> create a new GnomeCanvasItem to represent a Query object on a canvas:
> a CanvasQuery object (modeled for example after the CanvasQueryView).
> This GnomeCanvasItem will:
> 	- show the fields in a query
> 	- show the parameters of a query
> 
> -> create a ReportView object (inherited from a GnomeCanvas object,
> similar to the CondsView) to display CanvasQuery items and enable
> connection between them as shown in the proposal I sent yesterday.
> 
	I think I would be very nice that, when you add a table that is relationed (via a foreign key) with another already in the diagram, connections be created automatically.

> ..-> extend the DTD to store reports definition (queries and their
> relations, text, etc) and write the actual code which does the job of
> generating a report description which can be sent to libgda for
> "interpretation".
> 
	Referencing the DTD in libgda/report should be enought, I think.  Also, to generate the report description, libgda-report will provide all the functions needed, so report is always interpreted and validated.

> I know this is quite a lot of work, but then we have something quite
> generic which uses the power of the Query object.
> 
> Tell me what you think about this.
> 
	It sounds very nice.  But I don't see how other elements of the report will be designed, like labels, lines, pictures, pageheaders or pagefooters, for instance.   It will be another canvas where these elements are designed graphically, or how are you thinking to do this ?

	Cheers

	Santi Camps