Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: IanMac26
  • Content: Threads
  • Order by date
  1. IanMac26

    Crystal ActiveX ReportViewer

    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...
  2. IanMac26

    Wider pages or Horizontal Pages

    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
  3. IanMac26

    Crosstab or Dynamic Columns

    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...
  4. IanMac26

    Dynamic column headings multi line

    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...
  5. IanMac26

    Crystal scripts and vista

    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...
  6. IanMac26

    Suppressing subreport

    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...
  7. IanMac26

    How to report zero sales customers

    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"...
  8. IanMac26

    Simba error HY000

    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...
  9. IanMac26

    Calculations using subtotals

    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...

Part and Inventory Search

Back
Top