Last post Nov 15, 2013 12:44 AM by Ajay2707
Nov 14, 2013 09:35 PM|AndyLPJr|LINK
I have a stored procedure that show a record like below.
I want a crystal report to showing result like this:
INF : Infrastructure
ABI01 Cost of infrastructure A 1077665
ABI02 Cost of infrastructure B 42000
MTN : Maintenance
ABM01 Cost of Maintenance A 465900
ABM02 Cost of Maintenance B 3450000
ABO01 Cost of Operational A 110500
Is it possible to be made? Thanks for the help..
Nov 15, 2013 12:43 AM|Ajay2707|LINK
Yes,you can achieve this thing as follow.
1. create a group of ParentAccountID by right click of any group, then popup comes, give this column name. After creating it, just drag and drop 2 fields in this group, one is
ParentAccountID and second is
ParentAccountName and put text field (and write in this text filed, only return " : ") between this two fields.
and in details section, put fields as your design. and check your requirement is fullfill by checking preview.
2. Still if your requirement is not fullfill, then create a sub-group of
AccountID as above and check your preview. (only action taken when first will not give your proper answer).
Nov 15, 2013 12:44 AM|Ajay2707|LINK
For above process please refer link and search group.