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!

  • Congratulations Mike Lewis 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. pectin232

    Section on own page details help needed

    I got it working!!! thanks... I mess around and move data to a section and did a newpage before with the code. It works. Thanks Lbass.
  2. pectin232

    Section on own page details help needed

    Lbass. I put a word document. Not sure if it helps you to have a better understanding. It is not a big thing. I am sure somehow I have not correctly place the textboxes or they have to be in the GF instead of the details in order for the NewPage After code to work. Thanks and appreciate if you...
  3. pectin232

    Section on own page details help needed

    I want all the details GH, Details,GF etc.. all to be printed out on each page... lets say I am a patient.. and I want all details of my case... first visit, last visit, check up frequency, etc etc.. x rays all to be printed out on 1-5 pages.. this is my case..but somehow Mr jay case [another...
  4. pectin232

    Section on own page details help needed

    This is on the main page of the Form where it has like over 10 different Subreports. I click on Section Expert and select the SubReport....I tried 'New Page Before' and 'New Page' After to print the details of the subreport on each and every page. where Somehow it still prints on 1 page for 2...
  5. pectin232

    Subreports text fields wraps around too early and does not use ...

    From within Crystal itself it looks and runs fine but from outside of crystal. Business Objects renders the report as a PDF, it does not look right... the widths are not completely used up, but wraps into the next line after 5 1/2 instead of at least 6-7
  6. pectin232

    how to populate a parameter prompt even if it is null or empty string

    Is that inthe Record selection formula? Thanks Lbass. For crystal I am quite new in this.
  7. pectin232

    how to populate a parameter prompt even if it is null or empty string

    It is stand alone. It is a front end java app which extract from the database to populate the 2 text fields which the user can select from a list of users. Sometimes when a case is close or whatever reason there is no data on these fields, Crystal report will bomb out. Is there a way for me to...
  8. pectin232

    how to populate a parameter prompt even if it is null or empty string

    It is a string. Users search for certain cases to see cases associated with the workers in charge. In most cases... the 2 fields are populated and another list box populated. Crystal will crash somehow if the 2 textbox fields and listbox fields are empty or null, etc. This rarely happens ...
  9. pectin232

    how to populate a parameter prompt even if it is null or empty string

    I did this if isNUll({?ADDITIONAL_WORKERS}) then {?ADDITIONAL_WORKERS} = '0' it does not show any data... but when right click to do a browse the data.. it shows all 15 of them. How do I display it?
  10. pectin232

    how to populate a parameter prompt even if it is null or empty string

    sorry for not being clear... if there is no value or user did not enter any values but to use the existing value that is in the listbox itself.
  11. pectin232

    how to populate a parameter prompt even if it is null or empty string

    if isNUll({?ADDITIONAL_WORKERS})=true then {?ADDITIONAL_WORKERS} = 0 else {?ADDITIONAL_WORKERS} = {?ADDITIONAL_WORKERS} What I am trying to do is... in the prompt if the user or system finds no Additional workers then it will still return the default data of the person or what values is listed...
  12. pectin232

    How to treat no data, null values, empty field for parameter prompts?

    I have this now but did not work.. this is also one of the several parameters. None work... not sure if I should use the NVL function.. If isnull({?Additional_Workers})=True then {?Additional_Workers}= (0,0 or If isnull({?Additional_Workers})=True then {?Additional_Workers}= {0,0} or If...
  13. pectin232

    How to treat no data, null values, empty field for parameter prompts?

    I have a command in the SQL itself now...but I am not sure how to encapsulate it in Select Expert. The 2 parameters are if isnull({?caseNumber}) then ...... not sure if this is what you mean? Thanks
  14. pectin232

    How to treat no data, null values, empty field for parameter prompts?

    I am fixing some crystal reports which has a few parameter prompts for certain case numbers and data ranges. If the user does not fill in any data it will crash crystal reports. How do I allow no values or no data in the parameters and insert a sysdate if no value is entered in the prompt? Thanks
  15. pectin232

    how to just make a blank space page XXXX of XXXX

    How to create a footer page XXXX of XXXX [the XXXX represents space] instead of page 1 of 20, then 2 of 20,etc... Thanks
  16. pectin232

    anyway of capturing parameters Crystal reports

    Thanks so much. I will request them to try that option.
  17. pectin232

    anyway of capturing parameters Crystal reports

    when Crystal reports run I am trying to see if I can capture the parameters being invoked by Business Objects server. If the user requests for [expample] UserID, address, phone, roleID, roleCode, etc etc.. I would like to see what crystal reports passes behind the scenes. Not sure if I am clear...
  18. pectin232

    anyway of capturing parameters Crystal reports

    Individual Crystal reports are being launch by any user using a Java application. They use the Java web application and then goes through different screens, sets different radio buttons, etc and clicks on submit. That launches Crystal reports and the user is able to view the report, save it as...
  19. pectin232

    One of Subreport in Main reports is not displaying

    I have parameters which is called for during run time. Is there a way to set the parameters to accept NULL values or empty strings during run time or values have to be there during run time?

Part and Inventory Search

Back
Top