[solved] lazreport  display separated dataset in a single band
lazarus / 52-LazReport

----------------------------------------------------------------------
kito · 2016-03-29 20:46

hello ,
I am newbie I wish that I could  make my question as clear as possible
.
I have a principle dataset let's name it  'years' contains all years
and salary-field
I used 03 queries  with where clauses to separate  it  to three new DS
:
...
year_A   /  salary ..................... year_B   /  salary
......................year_C  /  salary
...
2005     /   400     ..................... 2006     /   400   
......................2007     /   400   
2005     /   400     ..................... 2006     /   250   
......................2007     /   420 
2005     /   400     ..................... 2006     /   400   
......................2007     /   580
2005     /   400     ..................... 2006     /   400   
......................2007     /   315 

I want to display the three tables (with lazreport ) in single band 
at least with the same vertical alignment position . please  any hints
?

Thanks

* each dataset has the same record count
*I had attached a pic

----------------------------------------------------------------------
cpalx · 2016-03-30 12:28

Make a store procedure that display the data as you want, then you
will have just one query and you wont have problems

----------------------------------------------------------------------
alexs75 · 2016-03-30 18:59

Use subreports

----------------------------------------------------------------------
kito · 2016-03-31 19:05

Quote from: cpalx on March 30, 2016, 02:28:13 pmMake a store procedure
that display the data as you want, then you will have just one query
and you wont have problems
Thank you cpalx for your replay , your solution sounds effective , I
spent last days googling how to apply that on similar situation as
mine .
I only get lucky  with  separation of the years but   salary  lost
their place  and just keeping duplicated from as the  first row .

my producer Now looks like this :

QuoteCREATE  PROCEDURE TRY
(
  IPIC_Y    INTEGER
)

RETURNS (
  COUNTY2    INTEGER,
  SALARY2    INTEGER
)

AS
declare variable i integer;

BEGIN
i=0 ;
while (i < 4) do
     for select YEAR_BRY,somme
     from BRY where bry.YEAR_BRY = :ipic_y
 
     into :county2,SALARY2
    
 
  Do
  begin
  --county = :ipic_y ;
  county2 = :ipic_y + i ;
 
  i=i+1;
  SUSPEND;
  end
  end;

----------------------------------------------------------------------
kito · 2016-03-31 19:08

Quote from: alexs75 on March 30, 2016, 08:59:30 pmUse subreports
thank you alexs75  I am keeping an eye on your suggestion ,  .

----------------------------------------------------------------------
kito · 2016-04-02 17:40

well , it's too complicated , and first of all it needs time to
understand the problematic , it doesn't belong to lazreport section
according to the previews answers . what I need is : taking a deep
look at the stored producers , PIVOT tables.

I'll mark it as solved , and perhaps if it's allowed I'll leave a
comment later  if I figure out how to fix it .

----------------------------------------------------------------------
kito · 2016-04-03 23:05

It took another hint from a friend of mine   

first (optionally) generate a stored producer from this query  :

QuoteSelect (case year When : year  Then Salary  Else null END)
Year1,(case year When :year +1  Then Salary  Else null END)
Year2,(case year When :year + 2 Then Salary  Else null END) Year3 from
My_table
the second part is depend on script inside the report  ( value = null 
---> visible  =false )

yep My face was like that    



* tested on Firebird /Oracle