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

  • Users: staceyn
  • Content: Threads
  • Order by date
  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

    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
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. staceyn

    Totaling variables question

    Hello, I am using cr XI rel 2 with an informix database. I have a main report grouped by color, item and class. I have 3 subreports to bring in received data into the main report. There are parameters to select certain items within a class. The subreports are also grouped by color, item and...
  17. staceyn

    Update printed flag in database through Crystal?

    Hello, I am using Crystal XI rel2 with an informix 10 database. We have created a packing list report that is scheduled to run every minute through a crystal scheduling tool. The ctheader table has a field called cth_printed which is a Y/N field. I am trying to determine if there is a way to...
  18. staceyn

    Parameter input for Top N value?

    Hi All, I am using Crystal XI rel 2 against an informix database. I have a report that is the top 65 ranked by sales. It is grouped by store and date. I have used the top n expert to give the top 65 and a running total to give a numerical ranking for each record. This is all working great...
  19. staceyn

    enable server issue

    Hello, I have just installed the crystal server xi evaluation. In the configuration manager all servers show as running. However when I go into the enable/disable server option there are no servers listed. Any ideas on what is wrong here? Thanks, Stacey
  20. staceyn

    Help with expression in SSRS

    Hello, I am using Visual studio 2005 against an infomix odbc datasource for my report. I am trying to get previous weeks data to display. I have a parameter to prompt for sales week and have that added to my table filters. I then have the following formulas to grab the week entered as well as...

Part and Inventory Search

Back
Top