Hi all,
I have a report that has a header , footer and a detail section
The detail section has a subreport.
The header and footer of the report pulls the data from a quote header table with quote number, cust info etc.
For every quotenumber, there might be mroe than one line items. The different lineitem details for that quotenumber is pulled from table quoteline item
I have different line items that can be quoted.
On my sub report, I want to format the output on the report(include certain fields/remove certain fields) depending on the lineitem.
For eg:
For quotenumber 788 I have 3 lineitems a, b and c
I want the sub report as follows:
lineitem description qty cost
misc info
cust number info
a wooden pencil
very strong
989898 25 25.00
b matress
light weight
(i dont wanna display cust
number for this lineitem) 1 100.00
c Pen 25 45.00
(for pen line item, I do not
want to display any of its
misc info or cust number info)
Is this possible?
Any input is appreciated
Thanks in advance
I have a report that has a header , footer and a detail section
The detail section has a subreport.
The header and footer of the report pulls the data from a quote header table with quote number, cust info etc.
For every quotenumber, there might be mroe than one line items. The different lineitem details for that quotenumber is pulled from table quoteline item
I have different line items that can be quoted.
On my sub report, I want to format the output on the report(include certain fields/remove certain fields) depending on the lineitem.
For eg:
For quotenumber 788 I have 3 lineitems a, b and c
I want the sub report as follows:
lineitem description qty cost
misc info
cust number info
a wooden pencil
very strong
989898 25 25.00
b matress
light weight
(i dont wanna display cust
number for this lineitem) 1 100.00
c Pen 25 45.00
(for pen line item, I do not
want to display any of its
misc info or cust number info)
Is this possible?
Any input is appreciated
Thanks in advance
