crystal report in windows forms csharp

Question

I'm creating the crystal report for a particular where i need to choose the company name which is displayed in checkedlistbox .Here i am storing the company id which is related to the company name in a variable called count. Problem is that when i select multiple companies it should display the records related to that particular company but i am not able to get any records in crystal report Can anyone who knows about crystal report please help me

Amit Gupta · Answer

Passing datasource to crystal report will be same, just you need to recreate your query based on checklistbox. Your query will look like SELECT Company_Name,Id FROM Company_Master Where id in (1,2,3); You need to replace 1,2,3 with your count Good Luck

karthik pai · Answer

Thanks for your reply Amit Gupta..Can you send me some links or code for that coz i am new to crystal report i dont have much idea regarding that

Amit Gupta · Answer

You are just passing the concatinated srring of count (that is not going to display multiple records), you need to pasa the datasource to crystal report, doing this will get your desired result

karthik pai · Answer

this is my crystal report:

Amit Gupta · Answer

Share your code and crystal report

karthik pai · Answer

First i used parameter fields in crystal reports where i passed the {?id} then in select expert i mentioned equal to {?id} which displays the records based on single company selection. Suppose if i select multiple companies then it displays the blank report.. But in my code where i used count variable it stores of the id of multiple companies..Problem is due to the formula what i used .Can anyone tell me the formula for multiple id of the companies in crystal report

Amit Gupta · Answer

Here i am storing the company id which is related to the company name in a variable You have already mentioned that you had designed the report based on single id, you need to design your form that can handle multiple companies

Khaja Moizuddin · Answer

hello refer these articles for references : https://www.c-sharpcorner.com/UploadFile/009464/use-crystal-report-in-C-Sharp-windows-application-using-store-pro/ https://www.aspsnippets.com/Articles/Basic-Crystal-Report-Tutorial-with-example-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm