There's a couple of ways to do this, but they'e all a little tricky... if I read your posts correctly, you're (in effect) creating a 'spreadsheet' of width 20 columns and n rows. If THAT assumption is correct, let e know.. we can look at a couple of options from there. ECS DataSystems, Inc...
Sure... a VB solution would work nicely - and it would be a elatively compact scheduler for you. Once you've defined the reports and the schedule time, it would be a relatively straightforward app to call the report up (off the system time) and 'run' it... ECS DataSystems, Inc.
www.ecsdata.com
A...
Also, check that the DATABASE | SET LOCATION is set to SAME AS REPORT. Also VERIFY ON EVERY PRINT should be set.
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
You may be having a TEMP file, or Swap file problem... if you are creating a signifiant graph OR there is a ton of data manipulation, this might occur...
ENSURE your TEMP folder is cleared of ancient .tmp files; ensure that you have at least 20% available space on the drive. If necessary, open...
Try changing the = to a LIKE:
Tablea.Field : Tck_Code = 1TQ
Tableb.Field : Tck_Code = 1TQ7005FR
Select Formula:
Tablea.Field LIKE Tableb.Field + *
The LIKE should pick out any 1TQs you might have in Table B
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Check out http://technet.oracle.com/support/bboard/content/647.htm
for info on the ORA error...
Also, the ODBC drivers and the P2SODBC.DLL have changed from CR 7 -> 8x. Check the CDecisions website for downloadable updates for Oracle
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
There's problem with the ODBC DLL supplied with CR 8 and, concomitantly with the Oracle Native ODBC driver... they have a problem in bringing ion LOBs...
You might want to look at the Crystal Decisions site and check downloads for ORACLE. There's a CR Merant ODBC driver which does work well...
I assume you're trying to in CR what you can do in Excel, for example - side-by-side placement of the text. Don't know a way of doing it in 1 report without 'squishing' the report objects (fields, report headers, etc) down to 1 char wide then exporting the whole thing to Excel... ECS...
You an group on ID number and place the report names into the detail (which, by the way, is the quickest way to view stuff in development). This will give each document its own 'line' in the detail - but won't put the combination of docs for a given ID on one record line.
Alternatively, you...
Are you trying to manipulate the data in this field in any way? For example, are you attempting to use this in a formula (which CR won't support) or in record selection?
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Uhhhmmm...
We're assuming you have the long text field formatted to 'Grow'....
What's the Database you're reporting against? We've had problems with the ODBC drivers in bringing info in; and with the CR export DLLs putting stuff out to Export...
Have you checked the CD support document...
OK...
What type of file (DB) is it?
Is the credit in the file a negative (-110.00) or is it a positive amount (100.00) and somehow coded as a CREDIT? That may give you (us?) a clue as to how to proceed. :-I
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Depending on how the report is set up, you might want to go from CR -> Excel -> Powerpoint. The Excel tables do work nicely in PP....;-) ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
What do you need to do with this text?
As long as Oracle will store the RTF data, you should be able to retrieve it, BUT - you will bestoring and retrieving the RTF coding as well as the RTF content AND you won't be able to manipulate, select on, or otherwise use the incoming BLOB in any...
The really haven't seen the anomaly before, and we're updating from CR 4.5 and 6.0!
If the ODBC connection is made once in CR, and you go out and open another report using that connection, you won't be forced to log on again... and again...
Are you sing different ODBC conections for the two...
Which viewer is it that you're using? Are you using the Info Viewer that
is opened through the Info Desktop for Windows, or are you using one of
the web-based viewers? ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Was the subreport created as a stand-alone then 'imported' into the container report? Or was it created within the container?
Is the subreport linked to the container or is it not 'data-dependent) (using a param)?8-)
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Just prior to the END SUB, add something like this:
Result% = m_report.printreport
if result% <> 0 then
'Show error in msgbox
end if
;-)
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
Does this error occur if you page through the report, one page at a time? Or does it only occur when you 'goto' a page? :-V
ECS DataSystems, Inc.
www.ecsdata.com
A Crystal Partner
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.