Search results for query: *

I'm running Crystal 8 and have a main report with a sub report attached. The problem I'm having is that when I export the report and choose character-separated values I lose the subreport information. I get the subreport information only if I export it in an Excel format. I really need it in the...

The main report has all the fields in the group footer. I inserted the sub report into the footer. I had to create a formula for the fields that I'm linking on because they were formatted differently. The field consist of a purchase order number that I used a the trim formula on. The main report...

I have two issues with a subreport. 1. The report takes a long time to run - The main report normal ran in a few minutes, the subreport runs in a few seconds when they are done seperatly. When they are together the report takes over an hour. The subreport has 13000 lines and only includes 2...

Thank your for your help. I believe I have figured it out. The sql show query that seems to work is SELECT MMDIST.&quot;DOC_NBR&quot;, MMDIST.&quot;ACTIVITY&quot; FROM &quot;LAWSON&quot;.&quot;MMDIST&quot; MMDIST WHERE LENGTH(TRIM(MMDIST.&quot;ACTIVITY&quot;)) <> '0' I was able...

Ngolem, your suggestion worked but it took a long time. I'm confused on the sql show query because it doesn't inlcude the record selection. It shows: SELECT MMDIST.&quot;DOC_NBR&quot;, MMDIST.&quot;ACTIVITY&quot; FROM &quot;LAWSON&quot;.&quot;MMDIST&quot; MMDIST The record selection is...

I'm tyring to get a report for only the items that contain data is a specific field. The report consist of just one table with two fields. The first field (doc-num) is alpha 10 and the second field is alpha 15 (activity). I only want to print records that have an activity. The table has over a...

Hi ppl - small question - how do you find out your profile password?? Novell Networks did something weird, and I can't work out what it is when logging in non-networked mode!