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 Wanet Telecoms Ltd 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. BurnsORegan

    Using JDE BLOB files with Crystal 9

    Greetings all Has anyone ever tried using Crystal to include part of an JDE Media Object before: Here is what I am trying to do: I have a report in CR9, SQL database obviously JDE front end. Users store Client communications from the call centre in Attached text files through the JDE front...
  2. BurnsORegan

    Hiding Subreport - Still getting Shared Var

    Greetings all Is there anyway in CR9 to suppress a sub-report, ie. get it to not print, but still get the values in the shared variables? Regards BurnsORegan
  3. BurnsORegan

    Supressing Sub-Reports

    Greetings all.... Is there any way to supress a Sub-Report from Printing but still have it return values in the shared variables...? Regards BurnsORegan
  4. BurnsORegan

    Drilling down through ePortfolio?

    Can anyone suggest a reason why when drilling down through ePortfolio the drill down starts at the beginning of the report again (ie. bring up a second copy of the entire report) and not drill into the record selected? Thanks BurnsORegan
  5. BurnsORegan

    Error: The report file to associate with this object was not specified

    Can anyone help with this message. It appears when trying to publish a report via ePortfolio. The report is quite large in size (22Mb). I get the same problem when tring to upload another report which is even larger. Is there a Time OUt setting or is their something wrong with the report. I...
  6. BurnsORegan

    Size of Parameter Window?

    Good Day to all.... Has anyone figured out a way in Crystal (9) or any other version to adjust the size of the Parameter Field window so as not to have a scroll bar down the right hand side? Regards BurnsORegan
  7. BurnsORegan

    The Frustration........Number Format

    Greetings and Happy St Paddy's day. Has anyone managed to solve the problem of getting the Number Field to hold it's formatting. Even if the defaults are correct it keeps changing the (999) for negatives to -999.......... Please before my PC and Server become VFO's (Very- Identifiable...
  8. BurnsORegan

    Logon Screen

    I wonder if this has been done....... I am trying to pick up the user id of the person using a report to facilitate data selction (security). I have read that Crystal does not do this! (In this modern day!) Therefore I am trying to create a Logon Screen to pop up prior to the report running...
  9. BurnsORegan

    Use a Parameter for Top N Charting?

    Good day to all who log in. Has anyone ever managed to use a parameter input to drive the TOP N feature within charts. I have a report where a parameter drives the TOP N within each group which works perfectly, but cannot find a method to drive the TOP N within a chart. Anyone? Cheers...
  10. BurnsORegan

    Cross Tab Row Heights

    Greetings again..... Any clues as to how to format the row height and column width of a Cross Tab Report? Can get the fields themselves to vary but not space between the field and the cell. Thanks BurnsORegan
  11. BurnsORegan

    TOP N as a Variable

    Greetings All..... Has anyone tried doing Top N as a variable? If so please share you knowledge..... Thanks BurnsORegan
  12. BurnsORegan

    Drill Down on Advanced Charts

    Does anyone know a work around for drilling down into Charts designed with the Advanced Features. ie. Your chart is not in the relevant group. If the route is a sub-report to deliver the data, can you link to a single part of a dynamic report using Hyperlink? Relevant data / points: 1...
  13. BurnsORegan

    Sales Performance Report Needed

    Here is sample data and a proposed layout for a report I am trying to construct. Please can anyone who has a thought....lend it to me.... Sample: {Table1} // (Sales Order Header - F4201 in JDE) Doc Num | Type | 1 SO 2 SQ {Table2) // (Sales Order Detail - F4211) Doc Num |...
  14. BurnsORegan

    "One to Many" and "Many to One"

    Greetings to all the Guru's. Here is a simple question for you. I am working on CR 9, over SQL DB, sing Crystal ODA links. What is the best method of reporting and Charting multiple tables where the Relationships vary. Here is an example: I am trying to create a Target vs Actual vs...
  15. BurnsORegan

    Usind Data from a Sub Report in the Main Report

    A simple question for the Guru's! Is it possible to set a Global Variable in the Sub Report which then can be used as in a formula in the Main report? And I am specifically trying not to use a SQL Command to fetch data from the DB. eg..... I have a report running over JDE tables (F4211)...
  16. BurnsORegan

    Crystal SQL Designer

    Help, is this sold separately or is it standard in CR 9 or in CR8) Burnsoregan
  17. BurnsORegan

    Linking tables.....the easy way!

    Greetings to all.. I know this has probably been asked before but here goes again anyhow. I I wasnt to keep linking simple for the average user (ie Not using the SQL Designer) is there a method to link 2 unlike fields. 9IR. Can I create a Virual Join to a Trimmed field? Regards Tim Crystal...
  18. BurnsORegan

    Full Outer Join

    Has anyone come accross the Full Outer Join button being greyed out even though the join is possible. I am on a client site and have an issue that appear to be the Full Outer Join facility is permanently greyed out! Help Regards BurnsORegan
  19. BurnsORegan

    Full Outer Join

    Greetings All..... Has anyone managed to get the FUll Outer Join Facility in CR9 to work. Ours appears to be permanently not available and greyed out? Any Idea welcome! BurnsORegan

Part and Inventory Search

Back
Top