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

    options gone?

    Hi , I have kind of a strange one. I opened an existing crystal report, but options aren't available. Select expert, database expert, new formualas, edit formualas, etc are all greyed out, but if I create a new report the options are there. Any one have any ideas on how to get edit/new options...
  2. staceyn

    edit/new options disappeared???

    Hi , I have kind of a strange one. I opened an existing crystal report, but options aren't available. Select expert, database expert, new formualas, edit formualas, etc are all greyed out, but if I create a new report the options are there. Any one have any ideas on how to get edit/new options...
  3. staceyn

    All edit/new options gone

    Hi , I have kind of a strange one. I opened an existing crystal report, but options aren't available. Select expert, database expert, new formualas, edit formualas, etc are all greyed out, but if I create a new report the options are there. Any one have any ideas on how to get edit/new options...
  4. staceyn

    Cant edit existing report

    Hi , I have kind of a strange one. I opened an existing crystal report, but options aren't available. Select expert, database expert, new formualas, edit formualas, etc are all greyed out, but if I create a new report the options are there. Any one have any ideas on how to get edit/new options...
  5. staceyn

    subreports and can grow options

    Hi All, I am using Crystal reports 2013 and creating a check layout form to be used in SAP business one. In the report layout, there are 2 subreports for the top and bottom check stub. If there are more than 10 invoices on a check, crystal is throwing an error that the page size was not large...
  6. staceyn

    force page break after certain number of lines

    Hello, I am working on a report where I need the report to page break after 20 lines from the group header 1. The client uses pre printed forms and on longer orders the data is running into the preprinted data on the printed form. The number of lines on any given order can vary from 1 to about...
  7. staceyn

    print number of copies based on a parameter?

    How to enter the number of copies you want of a Crystal Report based on a parameter? What I have is a situation where my customer is going to do a Goods Receipt PO with Lot numbers, then for each lot on the GRPO they need to print identification sheets that have some human readable information...
  8. staceyn

    case statement to evaluate null values syntax

    Thanks so much will give this a try
  9. staceyn

    case statement to evaluate null values syntax

    Hello, I am trying to figure out how to write the following query in SQL if anyone can help Use field A if not blank othrewise use field B, if field B is blank print "N/A" Thanks
  10. staceyn

    how to calculate number of weeks between current date and a receipt date

    Hello, I am using business intelligence development studio 2008 and am trying to figure out how to do a calculation that will return the number of weeks an item has been in stock. The calculation should be determining the number of weeks between the receipt date of an item and the current date...
  11. staceyn

    List of options available?

    Hello, I am using Crystal XI against an informix database. We are trying to create an image report that shows item information along with images of the items being reported on. For each item there is another table that holds what the valid color and sizes are for these items. There is...
  12. staceyn

    Crystal server 2008 question

    Hello, In Crystal server 2008, can reports be deployed that contain saved data rather than allow the users database refresh options? Thanks, Stacey
  13. staceyn

    Need help with selection criteria

    Thanks Turkbear, that did the trick. I appreciate the assistance..
  14. staceyn

    Need help with selection criteria

    Hello, Using Crystal Xi rel 2 with an informix database. I have a report request and am not quite sure how to handle the selection criteria. The user wants to be able to have a parameter that allows a selection against a numerical field. The required options would be choose all balances, all...
  15. staceyn

    Need help with parameters

    Hello, I am using Crystal XI rel 2 with an informix database. I have had a request to create a report with multiple parameter selections. The request is: to choose vendor id (string field)or have the option to choose all to choose PO date (date field) or have the option to choose all to...
  16. staceyn

    Invoice "already being paid"

    The paid today flag needs to be cleared from the AP4 table. This can be done using data file display and maintenance. The flag is in position 90
  17. staceyn

    Top N Sort by calculated percentage

    Anyone have any ideas on this issue? Thanks, Stacey
  18. staceyn

    Top N Sort by calculated percentage

    Hello, I am using CR XI Rel 2 with an informix 10 database. I am creating a "Hot sellers report". The main report show qty sold by color and style.The report is grouped by vendor, style, color. There is a subreport that shows On hand quantities by color and style. I have a variable formula to...
  19. staceyn

    How to calculate the percentage of the GF2 variable to the RF variable

    Hi Ian, I tried as you suggested. I am getting the right value in the RH from the variable for the grand totals from the new subreport. However, the percentages still aren't calculating correctly. It is almost as if it is resetting on the group levels in the calculation. Any other thoughts...
  20. staceyn

    How to calculate the percentage of the GF2 variable to the RF variable

    Hello, I am using Crystal XI rel2 with an informix 10 database. I have a main report with a subreport to pull sales data into an inventory listing report. I have all of the shared variables working and giving me correct totals for each group and for grand totals. The variables are passing...

Part and Inventory Search

Back
Top