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. mthompso

    Need to show picture, which section am I in?

    I am trying to display .jpg files in the details section of a sub-report. The parent report is named Quinqenall.rpt, the subreports are sub5YearTempo and Quinqenall_images.rpt. It's this last which should display the images. I've done a test run, using the techniques in "Load a picture in...
  2. mthompso

    CR9 - String now array!?

    Thanks - that was the problem. In previous CR versions 3 values were passed to this parameter: it's name, the value, and "true". I tried setting it to "Multiple Values", but that made no difference, then trimmed the values passed to just one, the required value. Everything...
  3. mthompso

    Font problem in CR 9

    Have you checked the Crystal Decisions hot fixes? This isn't related to the problem I'm having, but when scanning them I noticed a couple of font-relaed issues. Some were solved by Crystal and I believe one of them was Windows-related and occurred after a Windows patch.
  4. mthompso

    CR9 - String now array!?

    Error message: This array must be subscripted. For example: Array[i]. The following formula has been working flawlessly up to and including CR 8.71; now it's CR9 & CR declares it to be broken. The name of the formula is Yr>2000 and this is all it consists of: --start formula if...
  5. mthompso

    Phantom record when form regains focus

    vbkris ... Thank you for jogging me about the form activate event. That's where the problem was, had nothing to do with the shift of focus. The record pointer was on the correct record; code the original programmer had written moved the record pointer, then tested for project id - a loop...
  6. mthompso

    Data Report Problem

    That's a pretty loose question, exactly what properties are you concerned about? Almost all Crystal Report properties can be changed at run time. Depending on your version of CR, check out the knowledge base at Crystal Decisions. Hope this helps.
  7. mthompso

    Phantom record when form regains focus

    After closing a modal form, the calling form ends up on a record that doesn't exist. Here's what happens. I have two forms, projects and photos, which operate on separate tables in the same database. A toolbar button on Projects is used to open the photos form, and it is always opened modally...
  8. mthompso

    Changed field size not picked up

    Yes, I did a test report and the correct string length is picked up. I'm wondering where the info is hidden in the .dsx (I assume) file. I've looked at it with a hex editor, but can't discern patterns to indicate field lengths, etc. The strings which name the fields are there, as is location...
  9. mthompso

    Changed field size not picked up

    Bruce, Tks for reply - when you say dbconn issue, do you mean that although I changed the location and set it anew, Crystal still connects to the old database? I can browse the data, the window populates, but the summary info at the top displays Type: string, Length: 8, rather than string, 10...
  10. mthompso

    Changed field size not picked up

    Bruce, Thanks for the suggestion. I should have mentioned that I tried: 1. Relocating the database, to force a new location 2. Verifying the database after the move. The move was successful, and the database verification reported that the database was up to date. (Verified using the...
  11. mthompso

    Linking Images

    I had a similar problem, needing to fetch different files whose names were stored in a database. The only way I found was to convert the report to a Report Designer Conponent (.dsr) and work on it within VB. It then worked just fine, displaying images stored for each different property.
  12. mthompso

    Changed field size not picked up

    I have had to resize an Access97 text field from 8 characters to 10 characters. It's a key field and used extensively in reports. Crystal Reports 8.5 is stuck on the old size (string,8) and I've had no success in coercing this field to the new size. Needless to say the reports using this field...
  13. mthompso

    Table refuses to link CR8

    Generally you need both field length and attributes the same to link. What about creating two indexes on fragments of the fields you hope to link on, casting so that they are both of the same type, so that the two tables could link. Alternately, create a calculated field in the child table...
  14. mthompso

    Subreport does not work at customer site

    Ngolem, Sorry for the delay in replying, but it took some time to get the client to fire up Access and inspect records, structure etc. The database structures are identical. The key values are the same: type and length, and are indexed when referred to as foreign keys. I added debug.print...
  15. mthompso

    Subreport does not work at customer site

    >Is database different That's a good point, and one I had not thought of. Not in this case, however, as any fields I've modified or added are checked for on program load and created if necessary. There's an interesting subtext here. The report in question is a .dsr, compiled into the program...
  16. mthompso

    Subreport does not work at customer site

    Konad, Thank you for your reply. The code in my original message is to tell the subreport where the data file is located. "sFPPM" is the variable which holds the path to and the name of the database. If I comment that out, then an error occurs at the customer site that the...
  17. mthompso

    Table refuses to link CR8

    So, if this field, along with another one now, will not link, how do I include its values? Use and unbound field and try to put a SQL Select statement in it? Miles Thompson
  18. mthompso

    Subreport does not work at customer site

    I have a simple report with one subreport. The subreport does not display any records at the customer site, although it works fine on my computer. The main report is selected against the Sites table on the Sites.ProfacNumber field. The subreport's name is HazMaterials. Its parameter field is...
  19. mthompso

    Table refuses to link CR8

    Brian, that's a good point, but the OwnTypeCode field has always been indexed, primary, no duplicates. This is why it's so hard to believe that Crystal refuses this link. I shouldn't need an index on the field I'm linking from (Ownership in the Sites table), should I? Miles Thompson CQA...
  20. mthompso

    Table refuses to link CR8

    Microsoft Access 97. Should have mentioned that. No free tables. This relationship has been mapped and displays in Access's "Show Relationships" view. Miles Thompson CQA Consulting milesthompson@ns.sympatico.ca

Part and Inventory Search

Back
Top