Comments by Cuculala (Top 23 by date)

FORMAT is not a recognnizedbuilt-in function name

i have this connection on my app.config
<add name="ConMe" connectionstring="Data Source=myDSource;Initial Catalog=db_sample;Integrated Security=True; ">

Can i use "ConMe" on the report.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd) instead?

I dont have a problem on the connection string,
Is that possible to add my report source on the app config?

Thanks DamithSL for the help I've got it already :)

Hi Thank you for the advice :) i will try this and ask you again if something went wrong :)

Thank you for the advice :) i will try this and ask you again if something went wrong :)

that's a part of my sub query please ignore select as

i tried your codes and i got this exception ;
Incorrect syntax near the keyword 'when'.

SELECT [Supplier],[tbl_purchaseOrders].[Purchase Order No],[Date Ordered],[Due Date],[Terms of Payment],
case
when [Invoice Date] <= [Due date] Then 'Delivered'
else when [Invoice Date] >= [Due Date] Then 'Late Delivery'
else when [Due Date] <= CONVERT(VARCHAR,GETDATE(),110) Then 'on due'
end as [Status]
from tbl_invoice,tbl_purchaseOrders

Thanks Peter Leow, Is that possible if my case is the column name of my table 2? for example;
CASE [Due Date]
WHEN CONVERT(VARCHAR,[Invoice Date],110) >= CONVERT(VARCHAR,[Due Date],110) THEN 'On time delivery'

the above result is just an example, im trying to create a view with status so user can see the status of its order, if its late, on time, or on its due date.

Thanks for help guys, but i want my status to be seen like this

|------------------------------------------------------------------
|supplier | PONumber | DueDate | DateDelivered | Status
|------------------------------------------------------------------
|supplier1| 123 | 4/12/2014 | 4/15/2014 | late delivery
|------------------------------------------------------------------

I'm sorry im new to this forum, thanks for advice I'll improved my question next time

Here's my code
Public hitcount As Integer = 0
Public email As String = ""
Public pageVisit As String = ""
Public dateTimeVisit As String = ""


Dim header As String = hID.PadRight(5) & "|" & hEmail.PadRight(25) & "|" & hPage.PadRight(50) & "|" & hdateTime.PadRight(15)
Dim value As String = hitcount.ToString.PadRight(5) & " " & email.PadRight(25) & " " & pageVisit.PadRight(50) & " " & dateTimeVisit.PadRight(15)

If System.IO.File.Exists(path) = True Then
Dim file As New System.IO.StreamWriter(path, True)
file.WriteLine(value)
file.Close()
Else
Dim file As New System.IO.StreamWriter(path, True)


File.WriteLine(header)
File.WriteLine(value)
File.Close()
End If
I want to auto increment my hitCount by 1.

Hi KR, thanks for your code but it doesn't work :(

Hi AndrewCharlz, combobox does not have a property .checked

Hi Aravindba

Thanks for your help, the extra blank pages are gone already, I just move up the page footer and that's it, it's actually work. Thanks again :)

actually preview time are ok but i got this extra blank page in run time. but when i change the size of the document by 8.5 x 13 in run with report viewer page set up, the blank page disappeared. what should i do? thanks for your help

Hi thanks for reply,
my report have only one pages but in the preview when i run my report i got 2nd blank page.