Data Design Issue in Ireport

[swathi.reddys2008]

 Thanks for your help Ankur Gupta..

But My requirement is as follows.....

This the total Project Wise Stock Report

 

Sarchkey        Product    TotalQty   Uom

A1                     Cables      100         Mtrs

Documentno    Product   Qty    UOM

10                         Cables   10     Mtrs

20                         Cables     40   Mtrs

30                        Cables      50    Mtrs

Sarchkey        Product    TotalQty   Uom

A2                     AC      100         Mtrs

Documentno    Product   Qty    UOM

10                         AC   10     Mtrs

20                         AC     40   Mtrs

30                        AC      50    Mtrs

Sarchkey        Product    TotalQty   Uom

A3                   Lights     100         Mtrs

Documentno    Product   Qty    UOM

10                         Lights   10     Mtrs

20                         Lights    40   Mtrs

30                        Lights     50    Mtrs

In this way I need to Display my data......

Please Can you tell how can i acheive it through ireport.

 

Thanks in Advance.

[Ankur Gupta]

Hi Swathi,

as the pattern which I see in your data is that there is a search key and related to it is the document numbers right? 

So in the main repory you make a group based upon the Search key, now in the group header you can place Product,TotalQty and  Uom.

Now in the detail section add an subreport and  pass the search key or whichever value as  the key value which links the document numbers with the search key.

Then in the subreport simply place the query with the  search key in the where clause which will enable you to pull out respective document numbers .

Then place the fields in the details section of the subreport.

 

And finally when you run your main report you will obtain data of similar pattern.

If you need further explanantion and demonstration just pass me a sample data I will make a JRXML out of that so that you can follow.

You can even reach me on skype ID: mfsi_ankurg or on my mail ID : ankur.gupta.aug@gmail.com

Thanks,
Ankur Gupta