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 Chriss Miller 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. cis12232004

    "Dictionary not found" error

    cis12232004 (TechnicalUser) 22 Nov 05 12:03 I have a standard solomon report that I am accessing using solomon 5.5. I want to amend this report using crystal 8.5 but herein lies my problem. Once I saved the report on my hard drive, I tried to access it using Crystal but whenever I tried to...
  2. cis12232004

    Dictionary not found error

    I have a standard solomon report that I am accessing using solomon 5.5. I want to amend this report using crystal 8.5 but herein lies my problem. Once I saved the report on my hard drive, I tried to access it using Crystal but whenever I tried to open the report I received the error message...
  3. cis12232004

    Blank Report in Crystal 8.5

    This is what is located in the Record selection: {vr_10630.RI_ID} = ToNumber ({@RI_ID}) and {vr_10630.StkItem} = 1.00 and {RptCompany.RI_ID} = ToNumber(RIPARAM( "RI_ID" )) The Group formula is blank. This scenario is repeated for both the report that printed blank and the one that printed...
  4. cis12232004

    Blank Report in Crystal 8.5

    I am using Crystal 8.5 to create a new report that can be accessed through Solomon 5.5 and I am using SQL database with an ODBC connection. The problem is the report prints sometimes and then other times a blank report prints. I copied out the SQL statement on a couple occassions and what I...
  5. cis12232004

    Customized Crystal 8.5 Report

    Thank you for your comments but my report is working as it should.
  6. cis12232004

    Customized Crystal 8.5 Report

    Thanks gentlemen but I finally figured it out. I generated the table using SQL, exported it to Crystal, made some adjustments and then put it in the solomon user folder for use. Worked like a charm.
  7. cis12232004

    Customized Crystal 8.5 Report

    LB, when I go into Report Expert and try to link to table to the existing report I keep getting an error and crystal report closes. Any ideas what could be causing this? I have used report expert to customize other reports without any problems. By the way, that is the reason I attempted to...
  8. cis12232004

    Help with SQL

    cis12232004 (TechnicalUser) 27 Sep 05 12:56 I am attempting to customize a report in crystal 8.5 but everytime I connect to the SQL7 DB and add the new table my report closes out. I tried to manually add the SQL statement to add the table and field as well but I got an error. I am not well...
  9. cis12232004

    Customized Crystal 8.5 Report

    I am attempting to customize a report in crystal 8.5 but everytime I connect to the SQL7 DB and add the new table my report closes out. I tried to manually add the SQL statement to add the table and field as well but I got an error. I am not well versed in how crystal responsds to SQL so can...
  10. cis12232004

    Linking Reports in Crystal 8.5

    Jcfx, I thought I should use that because that is what the fields are made up of on the report and because it provided some commonality between the two reports. And, yes, your example portrays a good example of what I want these reports to do.
  11. cis12232004

    Linking Reports in Crystal 8.5

    Fields for the @Inventory formula in the subreport report are: Transform({PurOrdDet.InvtId}, RIPARAM( "SegInvenMask" )) + " " + {Inventory.Descr} Fields for @Inventory formula in the main report are: Inventory Trim( Transform({vr_10630.InvtID}, RIPARAM( "SegInvenMask" ))) + " " +...
  12. cis12232004

    Linking Reports in Crystal 8.5

    lbass, your patience in helping me resolve this issue is commendable. I did as you suggested and the information from the subreport is not showing at all. Question, eventhough the two fields have the same name, they are made up of different data, would that affect the outcome of the report...
  13. cis12232004

    Linking Reports in Crystal 8.5

    LB, it's me AGAIN! I have been working on this report and there is still a problem with linking. The two reports have one field in common and both fields also have the same name @inventory. When I go to Edit/Subreport Links, I choose the @inventory as the field to link to and I am not...
  14. cis12232004

    Linking Reports in Crystal 8.5

    In group footer 2, the main report should display the inventoryID and Description, Ending Balance, the Usage for the period, Unit Cost and Extended Cost, which it is now doing. In group footer 1, the subreport should display the inventoryID and Description, VendorID and Name, PO Number, PO...
  15. cis12232004

    Linking Reports in Crystal 8.5

    Ok, the subreport is in the group header and the information for the main report is in the group footer. There is nothing in the details section and the totals are in the report footer. The result I am receiving is just a repetition of the subreport. I don't see any of the data from the main...
  16. cis12232004

    Linking Reports in Crystal 8.5

    lbass, I apologise for all these questions but this is my first attempt at doing subreports and it is really challenging me. These are the steps I am taking to create the report: 1. Open the main report. 2. Insert the sub-report in the Group Footer section of the report. 3. Go to edit...
  17. cis12232004

    Linking Reports in Crystal 8.5

    lbass, thank you so much for your suggestions and patience. I linked the reports as stated and now I have another problem. I have more data in the primary report than the linked report. Is there anyway I can get all the data from the main report to show that don't have any corresponding data...
  18. cis12232004

    Linking Reports in Crystal 8.5

    I have a problem, I grouped the report as suggested, but what is happening is that no matter what section I put the subreport, it is still duplicating itself 20 times or more over and over again. Am I missing a step?
  19. cis12232004

    Linking Reports in Crystal 8.5

    Okay, I tried the subreport and ran into a problem. I have inventory IDs on both reports and I want these to be together. Right now I have an inventory ID starting with 100 on page 1 and a similar item on a separate page. How can I bring like items together so that the report flows smoothly...
  20. cis12232004

    Linking Reports in Crystal 8.5

    Will try that, thanks lupins46!

Part and Inventory Search

Back
Top