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 Rhinorhino 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. Jacob438

    Problems installing NetShield 4.5

    I ended up calling McAfee support, and I found out it was due to some legacy registry keys that were present and that were throwing NetShield off. What I ended up doing (with the help of the support guy) was going through the registry deleting varoius keys... I can't recall which ones they...
  2. Jacob438

    parse xml data

    I have some data stored in a database column that looks like this in a long varchar field: <xml><instanceID>49926</instanceID><name>Jay Bartels</name><address>555 Madison Avenue</address><phone>650 555 1212</phone><comments>Please only call in an emergency</comments></xml> Is there a way i...
  3. Jacob438

    parse xml data

    Oh yeah, I realize it's not very practical, trust me this is definately not my doing, haha, if I had my choice, I wouldn't really deal with crystal reports much at all... Anyways, yeah I had to truncate the database field to 254 in order to do this, and after that, parsing is cake, so i guess i...
  4. Jacob438

    parse xml data

    now I've got a problem when I try to access that field from the database in the formula editor, i get a message stating &quot;blob field or memo field cannot be used in a formula&quot; what do I do now? I cannot change the database but I need to parse this field and get the data out of it into...
  5. Jacob438

    parse xml data

    I have some data stored in a database that looks like this: <xml><instanceID>49926</instanceID><name>Jay Bartels</name><address>555 Madison Avenue</address><phone>650 555 1212</phone><comments>Please only call in an emergency</comments></xml> Is there a way i could easily get the data to look...
  6. Jacob438

    web reporting problems

    you could try using something like this in the query string of the url: ?apsuser=Administrator&apspassword=pass&apsauthtype=secEnterprise using the fields apsuser, apspassword, and apsauthtype as you like. Jacob438
  7. Jacob438

    Chart Axis Values

    anybody know how to fix this? Jacob438
  8. Jacob438

    Chart Axis Values

    I am using Crystal Reports 8.5 and I'm having a really hard time getting a chart to look right. I am using a line chart, and when a large ammount of data is used, the chart looks ok, but when I'm reporting on values between 0 and 3 my axis looks something like this: 3 3 2 2 2 1 1 1 0 0 Why...
  9. Jacob438

    Crystal Decision Tech Support

    I'm glad to hear you had a good experience... I wish I could say the same. :) Jacob438
  10. Jacob438

    web reporting problems

    I couldn't access them from there also. I'm hoping that they are available from somewhere else where I can see which issues are fixed in each hotfix. Hopefully somebody knows, but I also had problems, just wanted to let you know, Jacob438
  11. Jacob438

    web reporting problems

    cool thanks, that did it, I wish there was a way to bypass the extra parameters in the URL just so it doesn't look so cluttered, but hey, beggers can't be choosers :) Jacob438
  12. Jacob438

    Page Break If Record is not completely fit on that Page

    Cool thanks, I did the pagenumber <> 1 way suggested by synapsevampire, but thanks for your input as well, kenhamady! Jacob438
  13. Jacob438

    Page Break If Record is not completely fit on that Page

    If I do &quot;New Page Before&quot; for the group header, then my first page is blank. The Page header a and b do not get printed on page 1 for some reason. Is there any reasoning behind this? Thanks, Jacob438
  14. Jacob438

    Page Break If Record is not completely fit on that Page

    This might be a simple question, but is there a way to inset a page break so that each item in a group starts at the top of a new page? I tried the &quot;keep together&quot; option mentioned above for the group, but then most of the time one item is printed on one page, but sometimes two items...
  15. Jacob438

    web reporting problems

    If you don't need the APS at all when running unmanaged reports, how come I get prompted for Authentication Type, UserName, and Password when I try to run an unmanaged report? I have CE8 installed, and I am accessing my report like this: http://server/report.rpt?user0=user&password0=pass and...
  16. Jacob438

    basic documentation

    actually, I'd probably be more comfortable with basic syntax, since I've known VB for 5 years or so now. However, if I can find documentation on just one of them, that would be great, I'm having trouble finding documentation on either, let me know if there is a document somewhere that has a...
  17. Jacob438

    Average of Count

    oh, that's kind of crappy, but thanks for enlightening me, Jacob438
  18. Jacob438

    Average of Count

    so if &quot;w&quot; is to determine number of weeks between days, then what is &quot;ww&quot;? The help files never installed with my Crystal Reports, so sorry if this is documented there. Thanks for you patience, Jacob438
  19. Jacob438

    first item in pick list already picked

    hmm... ok, just one more thing I dislike about CR, :) thanks Jacob438
  20. Jacob438

    Average of Count

    ok, cool, thanks Goran, I'll try that. I just noticed something, here's the actual formula I used: Count({table_case.idnumber}) / DateDiff(&quot;w&quot;,{?StartDate}),{?EndDate}) Is there anything wrong with this? Shouldn't the single &quot;w&quot; return weekdays where as &quot;ww&quot...

Part and Inventory Search

Back
Top