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
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...
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
When I call the PrintPreviewDialog, the resulting default window and zoom size are too small to read.
Can someone help me with the call to preset the zoom to 100% instead of the default Auto?
Thank you,
Marin
VS.NET 2002
SQL 2000 with SP3 or SP4
//////////////////////////
I'm passing an image as array of bytes to the SQL Stored Procedure which inserts it to the database.
ALTER PROCEDURE sp_InsertBarCode
@ImgBarCode image=null,
AS
INSERT INTO BarCodeTable(ImgBarCode)
VALUES(@ImgBarCode)
RETURN...
VS.NET 2002
SQL 2000 with SP3 or SP4
//////////////////////////
//////////////////////////
I'm creating an image of an barcode with following code:
Private Shared Function CreateImage(ByVal strBarKod As String, ByRef arrImage() As Byte) As Boolean
Dim graphic As Graphics
Dim pb As New...
VS.NET 2005 & builtin Crystal Reports
When I first access my application it may be using, say 20 mb of RAM (in Task Manager in the Mem Usage column). Then I go and run a report. The report will be large and it might add another 30mb of mem, so total mem usage is 50mb.
Then I quit the report...
I'm using CR biult in VS.NET 2002.
SQL 2000
My report is grouped.
I need to show only TopN (10,15,20....)groups based on column SubTotal of the group.
Thank you,
Marin
I'm using CR built-in VS.NET 2002.
DataSource for reports is DataTable (DataSet) which is filled with SQL Procedure(SQL adapter).
I need my data to be with 6 decimal places accuracy.
That particular column in the DataTable is defined as decimal.
When my SQL procedure returns values with...
Application for HP IPAQ (VB.NET 2003)
ConnString =
"server=" & SrvName & ";" & "database=" & DBName & ";" & "user ID=" & UsrName & ";" & "password=" & UsrPwd & "; Connection Timeout=20"
When I use this connection string to connect from HP IPAQ to an DataBase on Win Server 2000 (SQL 2000...
Application for HP IPAQ (VB.NET 2003)
ConnString =
"server=" & SrvName & ";" & "database=" & DBName & ";" & "user ID=" & UsrName & ";" & "password=" & UsrPwd & "; Connection Timeout=20"
When I use this connection string to connect from HP IPAQ to an DataBase on Win Server 2000 (SQL 2000...
VS NET 2002
Target machine -> WinXP Pro
How can I retrieve information about current printer status?
Is he online, out of paper, paper jamed, number of jobs ....
Any link, code, tutorial .... will help.
Thanx, Marin
I'm using CR which is built-in VS.NET 2002(ver. 7.0.9466).
Reports are printed on HP 1020 (USB port), Windows XP.
When I want to print more then 1 copy, only 1 copy is being printed.
The line I'm using and is working with other printers is:
oRpt.PrintToPrinter(NoOfCopies, True, 0, 0)
Any...
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.