Create a dynamic row

aminedakila · 2014-07-21T11:33:21+00:00

Hi everyone, I'm using Birt Report Design. I create a Data Source and Data Set. I can display it as a table report below: [id] , [name] , [nb_row] 1 , name1 , 1 2 , name2 , 3 3 , name3 , 2 Now I would like to get the…

aminedakila

Hi everyone,
 
I'm using Birt Report Design. I create a Data Source and Data Set. I can display it as a table report below:
[id] , [name] , [nb_row]
1 , name1 , 1
2 , name2 , 3
3 , name3 , 2
 
Now I would like to get the "nb_row" and to multiple it by the number of row for one "id".
Example of result:
[id] , [name] , [nb_row]
1 , name1 , 1
2 , name2 , 3
2 , name2 , 3
2 , name2 , 3
3 , name3 , 2
3 , name3 , 2
 
I saw the "RowOperationParameters" function on a topic of mwilliams, but I don't how to use it on Birt Report Design.
Could someone help me please?

Find more posts tagged with

Comments

Matthew L.

Could you please clarify what you are trying to accomplish? 
 
 
Are you trying to duplicate rows of data based on the number in [nb_row]?
(ex: if nb_row = 2 the duplicate 1 additional row, if nb_row = 3 then duplicated 2 additional rows)
 
 
What would be the purpose for duplicating data rows in the table?

GLO_FR

Hi aminedakila
 
takes a look on <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/34900-creating-multiple-outputs-for-record-with-quantity-field-greater-than-1/'>this topic</a>.
It was more or less the same kind of needs
 
Matthew is right. can you clarify what exactly you want to do.
Did you want from one entry --> multiple rows in output
or
from one entry --> multiple labels (in a same row) in ouput

aminedakila

Hi Matthew,
 
yes, this is exatly what I looking for.
I want to do this because I have Excel sheet to upload on my database which usually has this format:
 
[id] , [name] , [nb_row]
1 , name1 , 1
2 , name2 , 3
3 , name3 , 2
 
and I want to export a report with this format:
 
[id] , [name] , [nb_row]
1 , name1 , 1 text1
2 , name2 , 3 text21
2 , name2 , 3 text22
2 , name2 , 3 text23
3 , name3 , 2 text31
3 , name3 , 2 text32
 
Any ideas?

aminedakila

Hi GLO_FR,
 
the target is to generate all rows of my table (till now is easy to do), AND to get the value of "nb_row" of each row on my table and multiple it by the number of row to display.
 
Is it clear for you?
 
If not, maybe the French translation will help you:
 
j'ai une table contenant les champs [id], [nom] et [nb_ligne] (je l'ai simplifiÃ© pour faire court)
Jusque la j'arrive Ã afficher la table de ma base de donnÃ©es sous forme d'un rapport BIRT.
Maintenant ce que je veux faire en plus c'est de rÃ©cupÃ©rer la valeur de la variable [nb_ligne] de chaque ligne de ma table, et de dÃ©dupliquer les lignes en fonction de ce chiffre.
Exemple:
Si pour la ligne id=1 on a nb_ligne=5
Alors je veux afficher 5 fois la mÃªme ligne.

GLO_FR

Hi,
 
a scripted data set is one easy way to do it.
1) Read the data set in input and place it in a memory array.
2) Read the array and each time the number of row is greater than 1, loop on the current row and create as many output as you want in a scripted dataset
3) Use the scripted dataset in your report
 
Here is a short example with BIRT 3.7.2
 
 
*** Translation ***
une solution simple est le dataset scriptÃ©.
1) vous lisez votre jeu de donnÃ©es en entrÃ©e et placez son contenu dans un tableau mÃ©moire.
2) Ensuite, vous parcourez ce tableau mÃ©moire et vous faites une boucle sur l'enregistrement courant, dÃ©s que le nb_rwo est supÃ©rieur Ã 1.
3) le dataset scriptÃ© devient alors votre jeu de donnÃ©es principal dans votre rapport.

Matthew L.

I've attached an example built with OS BIRT 4.2.2 that builds the table dynamically on the fly and uses the "RowOperationParameters" to demonstrate its functionality.
 
This should output duplicate rows based on the 3rd columns number.
 
While this method works, GLO_FR idea of a scripted data set is recommended.

aminedakila

Hi GLO_FR and Matthew,
 
I tryed both of your solution and this is exactly that I looking for. Thanks a lot for your help.
I tryed also a solution different with dataset procedure (thanks Paul for this script):
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
CREATE PROCEDURE usp_ItemLabels
 -- Add the parameters for the stored procedure here
 @Counter int = 0,
 @Record int = 0
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
 
 -- Insert statements for procedure here
Declare @MyData table(ID int, ItemDescription varchar(50),Qty int)
DECLARE items_Cursor CURSOR FOR
SELECT ID
FROM table_1;
OPEN items_Cursor;
FETCH NEXT FROM items_Cursor into @Record;
@FETCH_STATUS = 0
 BEGIN
 set @counter = 0
 while @counter < (select qty from table_1 where ID =@Record )
 begin
 set @counter = @counter + 1 
 Insert into @MyData select ID,ItemDescription,Qty from table_1 where ID=@Record;
 end
 
 FETCH NEXT FROM items_Cursor into @Record;
 
 
 END;
CLOSE items_Cursor;
DEALLOCATE items_Cursor;
select * from @MyData
 
END
GO
 
 
The script function on MSSQL if someone what to use it.
 
Thanks again at Mattheuw, GLO_FR and Paul !