Crystal report

Question

Sir Could i use crystal reports for printing retail bills? How can we adjust the height and width of the report? can this report is suitable for dot matrix printer? how can suppress some fields before printing ? is there any method for printing the retail bills other than crystal report?

sona s · Answer

its working. i have construct a new function in my form through which i could pass a text to crystal report. inside the report i have write if {@Data}=suppress  then yes else no How can i write the event procedure for printing the report Can i hide these values inside the event procedure

sona s · Answer

Hello i have got a solution for this but it has some problems the solution is that i must set a parameter field named data its default values are display and suppress i must write the following code for each of the textfield as if {@data} =display then yes else no it is working.While displaying the crystal report a prompt is displayed and when i give the value display all the fields are displayed for suppress all are suppressed But what i want is to set the parameter through program without displaying the prompt is it possible?

sona s · Answer

Hello Sir i want to suppress 5 Text box fields With names txtNametxtAgetxtSextxtDOJtxtAddress in which For eg:- txtName.Text=Customer Name :  the textfield and formula fields are arranged together then i get Customer Name : William inside the crystal report the name william is from the database and it will be added to a field named {tblRegistration.rname} what i want is when the user click the print button the textfield txtName will suppress and {tblRegistration.rname} must print

Jan Montano · Answer

How far have you been with supressing the fields? If you could put a little bit code of what you have done so far in suppressing the fields... that would be great.

sona s · Answer

Hello Sir Its working.Now i want to group suppress some text boxes before printing the crystal report.is it possible? Can i suppress a group of Text boxes.

Munish · Answer

Hello Just create new formula field through Field Explorer and create a new field and type somthing like below if {FieldName}=1 then Male else Female I hope it can help u.

sona s · Answer

Sir its not working because the rsex field is a boolean one.When i type that code a message like formula must return a boolean value is displayed.

Jan Montano · Answer

I think what you need is a formula field in your Crystal Report. the formula field should contain something like this: if {tblRegistration.rsex} = 0 then FEMALE else MALE

sona s · Answer

sir i have using the crystal report for vs2003.sir i can suppress the field but there are some problems in it.it is not relating to suppress. i have a table named tblRegistration and a column named rsex in it.I will put 1 for Male and 0 for females it is a boolean field.But i want to print Male instead of 1 and female instead of 0 inside the crystal report i have write the suppress formula like this if({tblRegistration.rsex}=1) then (txtSex.Text=Male;) else (txtSex.Text=Female;); but this shows some error message like the formula must return a bool value please help me sir. sir can i pass strings directly in to the crystal report instead of dataset as the report source?

Jan Montano · Answer

Hi Are you using the crystal reports designer in vs.net? If you are you can right click the object you want to supress then choose FORMAT OBJECT. You should check the suppress checkbox if you want to suppress that specific field. If the above doesn't help and if you have your code please post it. thanks.

sona s · Answer

thank for reply sir. the retail bill means the bill provided by the shop on buying certain things. in the crystal report i should print the details like this. Customer Name : William but when i press the print button i should only need william because the field Customer Name is already there Can u get it? Please reply me sir

Jan Montano · Answer

Hi sona What do you mean by retail bills? Crystal reports could print any report provided that you have the available data. The height and the width of the report can be adjusted by adjusting the page. Unfortunately I have no vs.net installed and I can't recall the exact proerty to set. I think as long as your pc supports dot matrix printers there's no problem with it for crystal reports. How can you suppress some fields before printing... again sorry but I have no crystal reports installed. But that is also possible. Have you read the crystal reports documentation? You could all find it int there.