Hi Friends,
I have a big text file of over 300,000 records in it. Is there a way to get the last record number without going through each record?
Thank you
Try This:
YourReport.SelectionFormula = "{YourTable.YourField}= " & YourVariable
YourReport.Formulas(0) = "YourReportFormulaName= " & YourVariable
Make sure you do not have space between YourReportFormulaName and = sign.
Try!!
DCM, Thank you for help. I tried but it did not work.
Here is situation:
@StartDate yyyy-mm-dd hh:mm:ss.fff
I put '2001-02-01 01:01:00.000'
@EndDate yyyy-mm-dd hh:mm:ss.fff
I put '2001-03-01 11:59:00.000'
But I got same error message.
Parameter Number 1 is invalid
Thanks again.
I have to design a CReport using SQL Server's stored procedures which have two date data type parameters - Start Date and End Date. When I try to select the Stored Procedure from the list I get the Stored Procedures Input Parameters Box with yyyy-mm-dd hh:mm:ss.fff value But when I put a date...
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.