crystal report in windows forms csharp

karthik pai

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
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 pai8y ago
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 Gupta8y ago
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 pai8y ago
this is my crystal report:
Amit Gupta8y ago
Share your code and crystal report
karthik pai8y ago
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 Gupta8y ago
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 Moizuddin8y ago
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