Crystal Report with Mailing Label not working properply.

Mayank Jani

Hi Members,

I am developing an applicantion in C# WinApp with ACCESSS database.

there is a ComboBox with cities and after selecting a city, the records of all employees from the selected city displays in a CheckedListBox. Now I want to print all the employees name and address as mail label in a Crystal Report but, my problems are...

1. Only the last employee name and address appears on CrystalReport.

2. It displays all the number of records of the data table with only one name.

3. All city displays in the report with all states but in different order.

Confusing... for me too. Please see the screen shots... I tryed to describe everything in the screen shots but anything else you want to know please let me know.

Thanks

Mayank Jani

6 Replies

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

Mayank Jani8y ago
Hii,
Just got it done. however, I have to take a long rout.

Thanks

Mayank Jani.
Mayank Jani8y ago
Hi Amit,

I am using VS 2008.
No, I have not get the solution. meanwhile I have paused the problem for some time and worked on another issued i.e. to upload image to a folder and retrieve. It's done.

now again I am going to take the issue on hand again. I am thinking that the issue may be with the Crystal Report Wizard also. I am selecting the mail label print and some of them "Next"... "Next" I do not understand. Let me check.

please suggest me that, should I close this thread for now and post new question or just keep this open and post the query for the same in this thread?

Thanks.

Mayank Jani
Amit Gupta8y ago
Hey, Didn't? you got the answer?
Mayank Jani8y ago
Hi Amit,

thanks for your reply...
this type of code is new to me but, I tried it and having some confusions.
please see the screen shots. I have added comments within.

Thanks

Mayank Jani
Amit Gupta8y ago
There might be a possibility for the same name of the Employee, so better choose its EmployeeID (a unique id created for all employee, if not created then your must do it).

And play with that EmployeeID so that each and every field should be customized.

Do let me know, if you require any clarification
Amit Gupta8y ago
Hey

Your doubt is correct, the loop in your code was overriding all the names and gives you the last inserted records in the crystal report.

You have to add all the employees inside the loop and after loop ends bind that ReportSource with crystal report.

1. Create a global function that will used whenever it required
string GetEmployeeNames(CheckListBox checkListBox)
   {
       string emp = "";
       for (int i = 0; i < checkListBox.Items.Count; i++)
       {
           if (checkListBox.GetItemChecked(i) == true)
           {
               {
                   emp += ", " + string.Format('{0}', checkListBox.Items[i].ToString);
               }
           }
       }
   return emp;
       // this will give you the name like 'name1', 'name2'
   }
Note: The above query is untested, so test and modify it accordingly
2. Now query the database all at once, not for each time (for fast and better performance)
private void btnPrint_Click(object sender, EventArgs e)
   {
   string names = GetEmployeeNames(chlbxEmployees); // pass the name of your checklistbox
   string query = string.Format("Select EmpName, EmpAddress, EmpCity, EmpState from CryEmp where EmpName in {(0)}, names)";

       // 1. fetch data from the above query
       // 2. Bind the datatale with crystal report
   }
3. All Done.
Good Luck

Update:
I had updated my answer, the $ is used for formatting the string value. (var and $) is available in the latest version of c# version, I think you are on the older one.