Recent content by lashwarj

I have that, but when I go to open the Crystal report it tells me the server is not yet connected. Even though the data runs fine. My code has the test in it, the second code I provided. From within the app it runs great but when you try to access the crystal report it gives you the error

how do I set up the DNS info without having to redo my code to look like yours though, I have like 15 tables being used in this report from a sql database called Queensbury_Test

i can connect, I just need to pass my password through to crystal My new code looks like this and gives me the correct response, but when it get to the crystal portion it generates this error. PARAMETERS reportlocation STORE SQLCONNECT('Queensbury_Test', 'test_user', 'jinksycat') TO...

I have a program where I am opening a SQL controled report. How can i Make the report open the connection passing the values. In my app I can connect to SQL fine, but when my report opens it gives me a cannot start server

I have one day to finish this, I guess I could just leave it but I Hate to do that (new job bigger and better, lol) Here is the code I have in my init of my report bound form, PARAMETERS reportlocation Thisform.WindowState = 2 oCRObject = CREATEOBJECT(...

oh I dont want it to appear there all the time, i just want the user to be able to enter one by hand and have it save and show , not be a perminant option.

Rwsource is a table.field Rowsource type is 6-Fields

How do you make a combo box able to accept hand entered values, when my users hand enter a value it does not show after they save, it shows on the form but after they save it is gone.

I Have a database where multipal users are connected. I have code that once a year updates a database between a given date range, it them sets a value to .T., after that date range I set it to .F., my updates to not show till the user leaves the database, my code it below. How do I make it so...

Thank you guys, perfect.

Is there a way to return the month and date without the year.

One more, 'Value' is not a file variable REFERAL_TYPE = ALLTRIM(This.Value) REPLACE Thisform.Refer_Date.Value WITH {} REFER_DATE = (Thisform.Refer_Date.Value) is the code

IF i use the NUll, it gives a not a charater expression due to it being a date value I believe

These values are being inserted into a list box, when i try REPLACE Thisform.refer_Date.value WITH {} I get a syntex error

I list box the uses add values to, they add a char value and a date value, but i need to make it so they can insert a blank date value. With a text box you can simply do = ' ' Is there a method you can use to do the same for dates