reporting services - SSRS Report Generator -
i have problem on how output 1 on ssrs. want output this:
item1 item1.1 item1.1.1 item2 itme2.1 item2.1.2 item2.1.2.1 item2.1.2.2 item2.1.2.3 item2.1.3
can accomplish if group rows?
hope can me this. thank you.
edited:
this sample data:
mbtc-ccws07242014-04 c0000211957smith, john 00000000100000007242014nonvat assistance employee j. smith vassistance 7972 1900207140 07222014000000001000000000000000000000000000000000000000000001000000lfc lf012014php mb104sa10 assistance 1110016520unreleased acib-mbtc cash in bank - metrobank 000000001000000000000000000000 aap accounts payable 000000000000000000000001000000 c0000052658dela cruz, juan 00000000043800007242014nonvat ssc advance payment _5/1-5/7/13_harbco vssc advance paym8105 1900206889 07122014000000000438000000000000000000000000000000000000000000438000lfc 2014php mb104sa10 ssc advance payment _5/1-1110016520unreleased c0000206125test company 1 00000000030000007242014nonvat assistance vassistance 7984 1900207102 07222014000000000300000000000000000000000000000000000000000000300000lfc lf012014php mb104sa10 assistance 1110016520unreleased c0000052659company 1 00000000033300007242014nonvat ssc advance payment vssc advance paym7987 1900206890 07182014000000000333000000000000000000000000000000000000000000333000lfc 2014php mb104sa10 ssc advance payment_5/18-1110016520unreleased c0000050487mbtc 00000000117647107242014nonvat retainers fee_july 2014_i.salting vretainers fee_ju7898 1900207099 07122014000000001176471000000000000000000000000176471000000001000000lfc lf012014php mb104sa10 retainers fee_july 2014_i1110016520unreleased
for sql query.. can keep it? since confidential.
Comments
Post a Comment