Search results for query: *

Eventually we tracked down the original developer and he reminded us where he had placed the appropriate installers on the server - so everything is working now [thumbsup]

My Clients have a 4th Dimension application that uses Crystal XI for reporting. Each time they want to run a report a vb script is created beginning as follows " Const crEDTDiskFile=1 Const crEFTPortableDocFormat = 31 Dim CRViewer1 Set...

Thanks to all - I think I have found a better solution using subreports. Cheers, Ian

Gordon, I downloaded CR2008 and added a caclulated meber to my report - I think that would give the desired result although I still haven't worked out how to get "Sales" total to use in the percentage. I saved the report an opened it with CR XI. It warned that some features would not work and...

Using CRXI on Win XP I have too many columns for my A4 landscape page. How do I get a wider page or a horizontal page? Cheers, Ian

Gordon, I have some code that finds the customers and have assigned them to the variables col1customer, col2customer etc so now each column will evaluate correctly - there are actually 8 groups and some tricky logic to get that to work. Now I can only fit about 8 customers across a landscape...

Gordon, That ws an interesting article but it doesn't quite answer my problems. 1) the x% are of Sales (the first row of the report). In the overall report I store the Sales amount as the Sales line is being printed - I can't see how to store the Sales for each customer. 2) The x% does not...

Using CrXI on Windows XP. I am doing a report called Profitability by Customer. It is supposed to look something like Customer 1 Customer 2 ..... Customer n Total Bud Actual Bud Actual ..... Bud Actual Bud Actual Sales $$ $$ $$ $$ ..... $$ $$ $$ $$ Credits...

CR XI. My report has 6 columns of data. The 6 column headings are passed as parameters. For the available width the column headings could be up to 3 lines. I set the heading height to 3 lines, but would like the headings that are one line to be in the third line. I also tried setting can grow...

Running CR XI To run our reports our application creates a vb script. Yesterday I tried to run a script on Vista for the first time and got the error “Basic syntax is not supported in group or record selection formula” The line that seems to be causing the problem is...

The only way I could get the left outer join to return customers without transactions was to remove all transaction selection criteria from the original query. Then I could look at the transactions client side to decide if the customer should be excluded from the report. Unfortunately this was...

I understand what you are saying. However I also need to include the customers who have no transactions in the report. As soon as I link the transactions they are ommitted.

I am actually trying to report on customers that do not have a transaction of type x within the qualifiying date range. So if the subreport finds the qualifying transaction then the customers are excluded from the main report. Obviously the main report will always include customers who have no...

Using CR XI. I am producing a list of customers. I am using a subreport to exclude the customer if they have a particular type of transaction. Within the subreport I set a shared booleanvar true if the transaction is found. The shared booleanvar is set to false in the hidden RH section and...

I tried reversing the link but still only got the inner join i.e I did not get the sales accounts without transactions. I also tred using Excel to extract the records - same result. Perhaps my odbc driver or database (it is not native SQL) does not support left outer join. I have almost got...

Using crystal reports Xi. I have SALESTRANSACTIONHEADER.salesaccount left outer joined to SALESACCOUNT.id and with the other selection criteria the following sql is generated. SELECT "SALESTRANSACTIONHEADER"."TransactionType", "SALESTRANSACTIONHEADER"."ReversedBy"...

I think its a different Simba - the Simba I am using is an ODBC driver on Windows. I think it is related to memory - would it help to group on server ? Currently my detail area (Invoice lines) is hidden but contains a formula field (rSalesAmount) that adds 2 of the fields on the invoice line...

Using CRXI for reporting against 4D Server. I have written a quite simple Sales report, the main complication being that the detail is at the Invoice line level because certain categories of products are excluded. It runs fine for single months, but when I get to about 6000 detail records I am...

The 2 replies confirmed to me that I was doing the right thing. I re-entered the formulas(putting in the test for zero divisor and using the % operator), as I had done several times before posting. The formulas looked the same but now they work. :-D

I am using Crystal XI to do a Sales Analysis on 2 group levels. My groups are product and customer. At the detail level I have salesamount and costamount and have inserted summaries of both at product, customer and report levels. The subtotals show correctly, but when I calculate the profit...