Last post Jan 25, 2011 01:29 PM by Inayat Rasool
Jan 25, 2011 12:58 PM|Inayat Rasool|LINK
I am displaying crystal reports using dataset. I pass in UI parameters and retrieve through stored procedures.
I need to add user information while printing and I get it through URL query string.
I have used the URL by assigning to hidden textbox however I dont know how to make it into crystal reports.
Crystal reports accepts only dataset.
Is there anyway to send information to dataset ( With parameters) and add it in the resultset??? I don't know how it works. Please suggest me on this. Thanks.
Jan 25, 2011 01:15 PM|che3358|LINK
Crystal Report accepts parameter fields also. Pass it as a parameter. Or, you can add an extra column in the DataSet, then store UserId in.
Jan 25, 2011 01:19 PM|Inayat Rasool|LINK
Thanks for replying but I am looking in for options to add data to cyrstal report from parameters directly.
All the parameters I am sending query the stored procedure but doesn't add to crystal reports. I think I can't use an additional field in database.
Jan 25, 2011 01:29 PM|Inayat Rasool|LINK
I think I found the answer by sending the information as parameter to stored procedure and selecting the same in Select statement. It works perfectly fine.