I am converting reports from 8.5 to crystal 10. There seems to be formulas that the reports are calling. I am sure they are based in the user function library. how do I extract them from the CE 8.5 repository and put them into the CE 10 repository.
thanks,
We just imported our reports to CE 10 from CE 8.5. We would like to see a report of all the properties of those reports i.e. schedule, destination, type of output, associated group. What tool does Crystal provide to generate a report of that sort from the repository?
thanks,
The index is for a query run in crstal reports 9.0. I am converting a field in the query to match another oracle database table. I want to increase the runtime performance.
What is the syntax for making a run-time index? I have converted a field to numeric and am joining to another oracle database field which also does not have an index. I would like to build a run-time index on one or both. What is best? and how is it done?
If I cannot combine the threads, can I put in a subreport that is already run so the links will work quickly? Now it is running the subreport each time for each record in the main report.
To clarify my original question,
we have fld1 in an table in DB2,
which we want to join to a field (say fld2) in an oracle table. One is numeric (Oracle) and the other is character. Can we use the formula command in Crstal to convert the character to numeric and join on the formula. Will...
I am trying to combine into a query a DB2 table that has different field type for its index than the one I am joining to it in Oracle. How do I convert indices in Crystal so I can make a proper join.
thanks,
synapsevampire,
I just did a simple union query. It worked for that. But then I did a more complicated query and it produced an error.
select fld1, count(fld1) as fld_cnt
from
(
select fld1 from table1
union
select fld1 from table2
)
the inner query worked, but failed when added to outer...
I cannot see a query editor. The query I have to write is too complicated to use the drag and drop method. I know this feature was in 8.5. But what about 9.2.
Thanks
Mark
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.