How can I change only the time part of DateTime field?
ex. '2011-01-01 01:00:00' to '2011-01-01 00:00:00'
'2011-01-01 03:45:00' to '2011-01-01 00:00:00'
'2011-02-05 22:01:15' to '2011-02-05 00:00:00'
Thank you
He there,
I'm using
VS.Net 2002
builtin Crystal Reports
Win XP, SP2
I have cross tab which creates virtual pages.
On Preview everything is ok,
but when I export the report from CR Viewer to pdf Column headers on the virtual pages are empty.
Any sugestions?
Thank you,
draganss
This is something I have found for the X report:
Register - Number given to register where report was produced
Batch Number - The number assigned by Store Operations to identify the current batch
Batch Status - Shows whether the batch is closed or not
Start Date - Date when batch begins...
Thank you for your prompt response.
I have never heard either untill 2 days ago.
I beleive it is report which is used in USA(?).
Z report is Point of Sale report for each cashier. Every cashier at the end of his shift is printing this report.
I just hoped that someone who creates reports may...
LB thanks for your response.
I don't have option for SQL expressions within CR.
Changing the "original" stored procedure which gives back my data would be my last resort.
I'm looking for a way to do this with data that I already have.
VS.Net 2002
builtin Crystal Reports
SQL
************************************
I have crosstab with data like this:
..... Col1 Col2 Col3 Total
_______________________________
Name_a 1 2 3 6
Name_b 2 5...
Create formula, choose Basic Syntax.
formula=chr(149) & "your first line of text" & chr(13) &
chr(149) & "your second line of text" & chr(13)
chr(149) & "your third line of text"
Put the formula into the report.
HTH
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.