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!

  • Congratulations gkittelson 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. crystalball

    sql server connection for gentran properties file

    They have been notified, and I still cannot make a connection. I'm looking for an example that works to compare syntax with.
  2. crystalball

    sql server connection for gentran properties file

    I need an example of how to set up a sql server connection in Gentran Integration Suite v4.0. There are conflicting examples in their documentation, and I would like a working example. Thanks
  3. crystalball

    What part of this Record Selection

    OK. I have corrected many problems of my own making and have finally managed to push the entire record selection formula over to the server. The problem now is that approximately 3 out of 4 times that I run the report, it returns no data at all. When data is returned, it is correct and complete...
  4. crystalball

    What part of this Record Selection

    synapse - The expression is already there. Do you mean a formula, as below? -GG ( if {?BusArea} <> '*'then {@BusArea} = {?BusArea} else if {?BusArea} = '*' then true ) and ( if {?Region} <> '*' then {@Region} = {?Region} else if {?Region} = '*' then true ) and ( if...
  5. crystalball

    What part of this Record Selection

    synapsevampire - Your assumption is correct. The * is intended to select all rows. Based on your recommendations, I re-constructed the record selection formula as follows. The GL_PERIOD and GL_YEAR is being pushed down, however, something is still amiss with the balance of the selection. Is it...
  6. crystalball

    What part of this Record Selection

    What part of this Record Selection Formula is keeping it from being &quot;pushed down&quot; to the server. I am at a loss on this one. Thanks to all ({?BusArea} = '*' or {DSSTTSLSCOMM.BUS_AREA} = {?BusArea}) and ({?Region} = '*' or {DSSTTSLSCOMM.REGION} = {?Region}) and ({?Branch} = '*' or...
  7. crystalball

    Inordinate amount of time to generate pages

    When running a report, Crystal accesses the database and returns the first page of data. Following that, an inordinate amount of time lapses while generating the rest of the pages. In my case this is only a four page report. How do I determine what Crystal is doing during this waiting period?
  8. crystalball

    Crystal vs Access

    The problem with crystal is that it lacks the ability to store data other than in the report. Access allows users to add data tables to be used in conjunction with the tables being read. If you don't need this feature then crystal is ok, but in my opinion just barely ok. Crystal is easier...

Part and Inventory Search

Back
Top