Daily Report 1

[Baixinha]

I need to creat a report where only the records of the day going to be printed, but when I put the function, the program take the hour of system insted of date.


I need some help and Excuses because my english. I'm brazilian.


Thanks


Cintia

 

[KathrynC]

What formula are you using, which function are you using to call the date?

 

[Baixinha]

I'm using

{Cadastro.Data} in ["CurrentDate"]

 

[kenhamady]

If your field is a Date value you can use:

{Cadastro.Data} = CurrentDate


Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Baixinha]

This formula,

{Cadastro.Data} = CurrentDate

Generate a error

A string is required here. (in front of CurrentDate)

 

[kenhamady]

That means that your field isn't a date field. Right click on the field in your report and select "Browse field data" to confirm the data type of this field as reaad by CR.

Also post a sample value as it prints on the report in it's exact format.
Last, give us the version of CR you are using. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Baixinha]

The data format that CR is using is dd/mm/yy (format required in Brazil), but the error is the same.

I'm using Crystal Reports 8

thanks

 

[kenhamady]

You gave me the format and CR Version, but you didn't tell me the data type of the field. See the first line of my last post and tell me what data type CR is seeing. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Baixinha]

The type of the field is a string.

 

[kenhamady]

The problem is that CurrentDate is a date value and you are comparing it to a string field. To make it work you have to convert one to the other, and the easiest is to convert today's date to a string.

Try the following formula for your record selection formula:

Totext(CurrentDate,'dd/MM/yy') = {Cadastro.Data}

You specified a 2 digit year in your sample, so that is what I am using (let me know if you really meant a 4 digit year). The format string in quotes IS case sensitive, so keep it just like I have shown it. Let me know how it works. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Baixinha]

After that, the formula that I've use is:

{Cadastro.Data} = CurrentDate

or there is another one?

If I use this formula, after covert the field, CR ask me to add a string yet.

 

[kenhamady]

You only need one formula. It is the last one that I gave you.

THis is not a formula field, but the "record selection formula". It does the conversion to a string for you while it is selecting. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[Baixinha]

I was using the formula in the wrong way, but now, the report is working correctly.

Thanks Very Much

 

[Baixinha]

When I print my report, the field where I put the formula is appearing.

How can I omit this field?

Thanks

 

[kenhamady]

The formula I gave you wasn't supposed to go into a field. However, if it is working I would just delete that field from the canvas leaving it in the formula list. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal