Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jdemmi

    Skewy Date Logic

    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...
  2. jdemmi

    Counting Dilemma...

    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...
  3. jdemmi

    Chart Question...By month, year to date dilemma....

    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...
  4. jdemmi

    Populate Insert Fields of DetailsView with values of last record

    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...
  5. jdemmi

    Populate Insert Fields of DetailsView with values of last record

    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...
  6. jdemmi

    Populate Insert Fields of DetailsView with values of last record

    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...
  7. jdemmi

    Router Alert -- When a specific PC connects

    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...
  8. jdemmi

    ActiveX / Administrator problem

    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...
  9. jdemmi

    ActiveX / Administrator problem

    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...
  10. jdemmi

    ActiveX / Administrator problem

    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"...
  11. jdemmi

    Unknown Database Connector Error

    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...
  12. jdemmi

    Unknown Database Connector Error

    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
  13. jdemmi

    Unknown Database Connector Error

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

    How do I subtract a date field from another to show year,month,day?

    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...
  15. jdemmi

    Weird Results with "-" in Parameter Data..

    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...
  16. jdemmi

    How do I subtract a date field from another to show year,month,day?

    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
  17. jdemmi

    Weird Results with "-" in Parameter Data..

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

    Weird Results with "-" in Parameter Data..

    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)...
  19. jdemmi

    Line break in CSV export?

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

    How to Sort IP address

    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) &...

Part and Inventory Search

Back
Top