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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Weird thing about embedded reports

Status
Not open for further replies.

kermit01de

Technical User
Jan 20, 2002
256
DE
Scenario:
- Main report basing on a query that has general info and sums of some fields.
- two embedded reports that show the details depending on linked fields
***
- each subreport runs fine on itself
- main report runs fine on an english or german system
BUT:
- main report (only) asks for parameters if run on an english system that has greek language support enabled. And it asks for parameters (Forms!Date!xyz) and the linked fields for the subreports. The Form is open in the background, no parameters are defined in any related query, nor any related query contains a field nor a condition about the Forms-field.

What is the problem - or better to ask - what is the solution? From where do the "mystery parameters" come?

Thanks for any hint.

--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<
 
Don't know for sure but things I'd try...

Open the form named Date before running the report (notice you used a keyword function name and fix it).

This reference my be in the sorting and grouping section if nowhere else.

Ensure that the master and child fields point to field names in the record sources.

Ensure that there are no controls with the same names as the fields.

Compact and repair the database.

If that doesn't help, try importing all the objects to a fresh database on the Greek enabled machine. Try that file on other systems.

If that doesn't work, you could make the recordsource for the sub reports use parameter queries that reference the parent. It will likely work but not as simple an implementation.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top