Search results for query: *

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

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

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.

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

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

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.

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

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

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

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

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.

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

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

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

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

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

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

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

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

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