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 Chriss Miller 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. Turkbear

    Suppressing a Blank field

    If I recall correctly ( it has been a while), if you create a text box and place the fields in it, it can be formatted to suppress when blank ( I used it all the time for address labels) [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  2. Turkbear

    Screen saver stopped triggering

    Hi all, OK, it seems to have been a Windows 8 'quirk'. When I checked the notification area on the desktop I saw that an Office update was ready to be installed and, after installing it, everything screensaver related returned to normal. Apparently that action, while pending, prevented the...
  3. Turkbear

    Screen saver stopped triggering

    Hi, my screen saver has suddenly decided to not start, nor does the screen dim or turn off as specified in the power settings. I have turned off all the 'live' tiles (with no effect) and have uninstalled the only new program I installed (a FLV viewer from the Microsoft store) with no impact on...
  4. Turkbear

    A deer

    It reminds me of the prescription instruction: Take 1 tablet 4 times a day Difficult without attaching a string to it! [lol] [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  5. Turkbear

    Failed to open the connection - Preview from CMC

    Is there a DSN on the machine running the CMC version and is it exactly the same as the one used in development? What database and connection type is involved? [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  6. Turkbear

    Can you set a HOME page in IE10 under Metro?

    Thanks, that really makes sense ( more than the app does) The new interface does seem to have a steep learning curve, at least for those 'shortcuts' we used in 7 (or in 286 ,3,95,xp,Vista [I'm old![tongue]]) [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  7. Turkbear

    Can you set a HOME page in IE10 under Metro?

    When running IE10 from the Metro side, no tool bars are visible and I cannot find a way to set a start (or home) page. It always goes to whatever site was last visited, which is annoying. Is there a way to set and go to a 'home' page. The classic 'desktop' version works as expected. Thanks...
  8. Turkbear

    Error adding report in CMC

    Be sure that the account that the reportserver is running under has full rights to the source of the dynamic parameters. [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  9. Turkbear

    need to disable Oracle backups

    What backup method/technique is being used? Does your org have an Oracle DBA, if so, what is their advice? ( If not, why not?) [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  10. Turkbear

    Select query where it finds ids taking certain classes but not other classes

    [bigsmile]Nice post Santa, I seem to recall that problem from one of my Oracle classes. [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  11. Turkbear

    The report path on the BOE XI to be displayed within the Report footer

    Try opening the report using the BOE connection not the regular File...Open.. dialog within CR..Then save it back and it might show the correct directory (The Output server's directory ) [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  12. Turkbear

    Hi, help on this subject is appreci

    Try ( as your record selection formula): InStr({calldesc},"mobility") > 0 or InStr({calldesc},"cash edge") > 0 or InStr({calldesc},"voyager") > 0 If there can be upper or lower case then add those possibilities. [profile] To Paraphrase:"The Help you get is proportional to the Help you...
  13. Turkbear

    Slow Response to Parameter Selection

    By using a formula in Crystal to do the selection you have most likely moved that step from the database ( fast) to the local machine ( slow). Take a look at the SQL created by your report and you will probably see that that part of the WHERE clause is not being passed. Try creating a view that...
  14. Turkbear

    Crystal Reports Where Clause

    Can you explain the primary_code = n part of the formula? Why does the code Ian posted not work? [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  15. Turkbear

    SQL Command using 2 database locations or do I need a custom data source?

    I have usually found that creating a view in one datasource that incorporates the other datasource is easier to use with Crystal, so if you can do that in your databaae type give it a try. With that method only one datasource needs to be accessed by your SQL in Crystal. If not, is a SQL command...
  16. Turkbear

    HELP! Simple Range Parameter without attached field

    If your parameter is defined as 'allow a range of values' than it should work by using the parameter in the selection criteria. You do have those numbers in a record field, right? [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  17. Turkbear

    Epitaphs

    From a hypochondriac: I Told you I was sick! [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  18. Turkbear

    Parameter or Database Connection?

    Assuming that your linking fields are correct and that your 'new' table of invoice numbers created from the spreadsheet is the leftmost table with a left outer join to the header table which then is linked to the line table,it should return the records you want- In your report you should group...
  19. Turkbear

    Crystal Reports 2008, Oracle 11g

    Hi, Why group on Status? If you place that field in the details you can then use that formula to get the # You can suppress the detail section if you want ( and do not have any other fields in there) [profile] To Paraphrase:"The Help you get is proportional to the Help you give.."
  20. Turkbear

    Comparison of values in CASE statements

    One problem I see it that you will not have any values ( or aliases) for any CASE statement that is not met, that is, if the detail_type is NOT IN 1 0r 10, the alias CHARGES will not be created so it cannot be 'found' by the parser. [profile] To Paraphrase:"The Help you get is proportional to...

Part and Inventory Search

Back
Top