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
CorelDraw11 or CorelDraw12
BarCode Wizard
With the wizard I'm generating BarCode128.
When generated barcode contains only numeric characters (for example "00000005") barcode is not readable with barcode scanner. I've tried with several types of scanners.
When I add any non numeric character...
VS.NET 2002
SQL
built in Crystal Reports
CrystalReportViewer control
How can I determine(run time) if Crystal's Print Dialog Box is called?
Thank you.
Marin
Tek-Tips forums
Business Objects: Crystal Reports 1 Formulas
Business Objects: Crystal Reports 2 Data Access
Business Objects: Crystal Reports 3 Integrate
Business Objects: Crystal Reports 4 Other topics
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.