Search results for query: *

Is there any chance that your DB is storing date/time values in GMT/UTC format and/or the report (or application launching the report) is applying a GMT offset to the date/time value? 9/30/2011 8:05 PM EASTERN DAYLIGHT TIME is 10/1/2011 00:00:05 in GMT/UTC (GMT -4) -- Jason "It's Just Ones...

Does anyone have any creative ideas for the following issue? I'm stuck with 2 ideas, neither of which seem palatable to me. CRXI - Oracle 10.x I have a report request where a user wants to see a number of "counts" by month, by quarter and by year. This is not the issue as I have already...

CR XI...Oracle 10 I have an issue I am betting is very easy to workaround or solve but I am blocked....totally... I need to create a very simple bar graph chart which includes various counts...(Records created, records open, records closed, record past due, etc) The problem is I want to...

No, the detailsview has many rows. But I figured out a way. On the detailsview bound event I check to see if the mode is insert. If so, I fire another sql query that selects the columns from the "last" (max) record. I then open a datareader and set the field names = to the datareader item...

VB/asp.Net I have a detailsview object grabbing data from a data base. I am able to edit and insert rows fine. But, on insert all my fields are blank. I am able to populate them with "hard coded" default values via the databound event handler Like... Dim Cal2 As New Calendar...

VB/asp.Net I have a detailsview object grabbing data from a data base. I am able to edit and insert rows fine. But, on insert all my fields are blank. I am able to populate them with "hard coded" default values via the databound event handler Like... Dim Cal2 As New Calendar...

This may not be the correct forum. If so, please let me know where it should be posted. So, I have a home network using a TrendNet wireless router. Everything is configured correctly and functional. I am using MAC address filtering to allow/disallow connections to the network. But, what I need...

He hasn't created a new user but we did enable the "hidden" ADMINISTRATOR user and it worked fine. Because this is an old ActiveX control (3 years or so) it regsiters itself in C:\windows\downloaded program files. This was verified on My Vista and My W7 PCs by reviewing the add-on properties...

I will have him check the access security document. But I don't think any of the articles linked will help. We've already tried many (all?) of the steps in those links. We're way past bypassing/disabling the publisher could not . be verified messages. It doesn't change the behavior. The...

I am helping a friend with an issue that has me scratching my head. He has an older internet/security camera that works fine on his Vista/IE7 box, My Vista/IE8 box, My W7/IE8 box but not HIS W7/IE8 box. The only way we can get it to work at all on HIS W7/IE8 box is to run IE "AS ADMINISTRATOR"...

Are you able to connect to Oracle from this pc via Oracle's "SQL+" using the same user you're trying to use in the report? What error, exactly, do you receive when trying to connect via the report designer? As a test can you setup an ODBC connection to the DB and try that? -- Jason "It's...

Check your Windows environment path and make sure that the preferred client version (10?) is listed first. Then, at least as a test, rename the tnsnames.ora file in the 8 install to tnsnames.OLD Test -- Jason "It's Just Ones and Zeros

After you installed the Oracle client did you setup/configure a SQLNet.ora or TNSNames.ora file? -- Jason "It's Just Ones and Zeros

Here's one way....maybe not the easiest.... 3 Formulas (4 if you count the optional final display one to concatenate them) (datedif is your date calc in DAYS) 1 find whole number of years Global NumberVar Yrs := {@datedif}/365; Truncate(Yrs) 2 find whole number of months (based on 30 day...

Turk -- Yes, the m is a typo Lbass -- odd. I've even expected spaces or other funky stuff going on but the fact that all works correct when the - is removed says otherwise. What version of Oracle, what character set and what connection method (obdc? native?) did you use? -- Jason "It's Just...

Are you referring to calculating "age"? http://www.tek-tips.com/viewthread.cfm?qid=566269&page=883 http://www.crystalkeen.com/articles/crystalreports/customfunctions.htm http://www.tek-tips.com/faqs.cfm?fid=5876 -- Jason "It's Just Ones and Zeros

Not even ONE response? REALLY? -- Jason "It's Just Ones and Zeros

I've been around Crystal for a long long time. And I've seen my quirks. But this is a new one for me and perhaps the strangest. And, to tell you the truth, it's very bothersome because it effects the integrity of the data result set. Anywho..... CRXI R2/Oracle Varchar field in DB (FIELDA)...

Can you show us what you expect your output to look like? -- Jason "It's Just Ones and Zeros

LOL...Lbass, I was about to post a very similar approach....I previewed my post, found an error and when I edited I saw yours.. Anywho... Create a formula... StringVar Array x := split({YourTable.Field},"."); Right("000"&x[1],3) & Right("000"&x[2],3) & Right("000"&x[3],3) &...