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
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...
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...
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...
What part of this Record Selection Formula is keeping it from being "pushed down" 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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.