Crystal report

sona s

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?

12 Replies

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

sona s19y ago
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 s19y ago
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 s19y ago
Hello Sir,
i want to suppress 5 Text box fields
With names
txtName,txtAge,txtSex,txtDOJ,txtAddress
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 Montano19y ago
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 s19y ago
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.
Munish19y ago
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 s19y ago
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 Montano19y ago
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 s19y ago
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 Montano19y ago
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 s19y ago
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 Montano19y ago
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.