Crystal report , passing multi value parameters -
good day ,
i using crystal report 2013 , have interesting scenario , let's have created report accepts 1 parameter , shows list of records in table based on parameter.
now want able send comma seprated values in same parameter , want report run multiple times (equal number of values in parameter) , show me many tables values sent report.
so let's parameter name userids , want pass parameter userids=a,b,c , want report show me 3 tables having information user.
in web applicaiton achieve having component (jsp page creates html table us) , call componenet in loop table each user id , embed create 1 page showing these tables.
can similar login in crystal report , how?
i used approach resolve case , below sreps
1) introducted query in main report returns distinct user id (to used grouping data in report). 2) added multiple sub reports in details section , made sure commands in subreport should return user id. 3) inserted group group , seleted user id used group. 5) when run report , main query returns me distinct user ids , details section prints information grouped user id.
i hope have answered in clean way , in case if have suggesstions please let me know.
note : found initial solution based on component based approch use in programing laguages crystal report tool , had myself fimiliar different mind set.
Comments
Post a Comment