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: *

  1. AntonioPerera

    Numbers appearing as text

    Crystal reports 11 I am incorporating some number fields into a formula. E.g : Batch number - 110 Entry number - 1 Sequence number - 1802 My formula is : Batch number&"-"&Entry Number&"-"&Sequence number I want my result to look like this 110-1-1802 However, it appears as ...
  2. AntonioPerera

    Text field on last page

    Thanks for the solutions.. I changed the font and increased the margin but still can't seem to fit it all into 1 page. The Text goes onto the next page The text still appears longer, I am trying to figure out a way to widen the text ?
  3. AntonioPerera

    Text field on last page

    Crystal reports 11 MS SQL Server 2005 I have placed a large volume of text on the last page of a report. It is a sales invoice format and the terms & conditions of the deal are on the last page. I am trying to fit it all onto the last page but the only way I can see now is to shrink it to a...
  4. AntonioPerera

    Display a page of text after the report

    That does not work. It displays the heading again and my text starts on the details section.
  5. AntonioPerera

    Display a page of text after the report

    Crystal Reports 11 MS SQL Server 2005 I have a form designed in crystal reports. The form is designed in such a way that if more than 20 lines appear on a single page, it repeats the balance lines on a new page. On the new page the header details appear again. I am trying to put a page full of...
  6. AntonioPerera

    Cannot find DSN in connection string

    ACCPAC 5.3 Windows Server 2003 Terminal Services MS SQL 2005 I have created a custom report in Crystal utilising tables from Peresoft Cashbook. I have placed my report on the ACCPAC desktop but when I try to run the report I get the following error message : Logon Failed Details : Cannot find...
  7. AntonioPerera

    Location Override on Physical Stock Count

    Sage ACCPAC ERP 5.3 MS SQL The physical stock counting function in ACCPAC involves generating a worksheet, updating it and then posting it. Can the posting be made to work using the location override feature in ACCPAC ? i.e can the transactions be posted to the adjustment write off GL...
  8. AntonioPerera

    Text after a report

    I need for the text to appear after my page footer. When I put it on the report footer it seems to overlay onto the details section. Still need some help with this.. Cheers.
  9. AntonioPerera

    Text after a report

    Crystal reports 11 I have created a customer invoice format using crystal reports. At the end of the report I need to put in a page of terms and conditions. When I put this page full of text,crystal gives me an error which says text is too big for the group header. How can I put in the text...
  10. AntonioPerera

    Split Command and Error

    Hi, I am using Crystal XI and I am trying to perform a split function. My data field is looks like this: (e.g) A01-Admin D001-Dorm Z1-Temp I would like to split it as "A01" on a separate column in my report and "Admin" on a separate column The formula I used was split (field,"-")[1] to get...
  11. AntonioPerera

    Year and Period

    ...upto November 2009. Then I have to incorporate all YEAR data upto 2008 (all 12 months) and then in 2009 months 1,2,3,4,5,6,7,8,9,10 and 11 only. *The problem is that if I put in a select expert to restrict upto month 11 then it will apply upto MONTH 11 on all YEARs. Any ideas on how to...
  12. AntonioPerera

    Total for Subreport

    My subreport falls into the details line and therefore I had to segregate it onto Details a and Details b. My total should fall into a GF#2 I am not getting my desired results, instead there is a cumulative count. Please suggest.
  13. AntonioPerera

    Total for Subreport

    HI , I have a subreport which gives a summarised total of a set of values. Now I need to get the total of that sub report. Example A 100 Total (Subreport) B 50 Total (Subreport) C 20 Total (Subreport) D 300 Total (Subreport) Need to get total of these above What is the best...
  14. AntonioPerera

    Calculating Correct Days

    It looks like the "Work" column works well but shows everything in hours. Is it possible to show the "Work" column details in Days instead of hours ?
  15. AntonioPerera

    Calculating Correct Days

    Hi, My tasks look like this : +Implementation 15.38 days -Database creation 5 days -Installation 1.38 days -Payroll Implementation 3 days -Other Implementation 2 days The total calculated is based on the days range and that amounts to 15.38 days...
  16. AntonioPerera

    Sort by Period

    I have a formula which sorts transactions based on criteria I have specified in a formula, that formula is the group # 1 header. An example of my formulas there is as follows : if {?YEAR YYYY} = "2008" and ({@dept} in ["100"]) then 01 else if {?YEAR YYYY} = "2008" and ({@dept} in ["200"])...
  17. AntonioPerera

    Text Formatting

    Hi Lbass, When I try to save the formula,it gives me a message stating "A number is required here" on this line : left({table.field}," &") else
  18. AntonioPerera

    Quantity Calculation

    Thanks lbass. You got me on track to figuring out what was wrong..
  19. AntonioPerera

    Text Formatting

    Hi , I have a field which contains data in the following ad hoc manner, here are some examples : Type # 1 John Smith<br>9 days at $1,800/day Type # 2 System Implementation - Peter Jones & Paul Simpson<br>Period: 15/11/08 to 28/11/08 Type # 3 Market Operations Management Improvement - David...
  20. AntonioPerera

    Quantity Calculation

    Those were placed on Detail C The running total was placed on Detail C without any Evaluation or Reset Options.

Part and Inventory Search

Back
Top