Report won't pull data - dummy data displayed

[crystal925]

Hi all, I've seen a few posts related to this, but they all seem to point back to an issue with using the word "Title" as a field, which is not one of my fields.

I am trying to use the wizard to create a report off a query with the following fields:

ModelYear, Make, Model, StartDate, EndDate, MileageIn, MileageOut, Service, Notes

My report doesn't pull any data though, just the dummy data appears. What am I missing?

Thank you!

[r4zoli]

If you run this query alone, it gives any data?

[crystal925]

Yes, when I run the query, I get back exactly what I want.

[JohnV]

If, when you create the report, at the last step you choose to Modify the report layout then you must save
it and reopen the report before your data will appear.

Does this help?

[drdmjohnson]

JohnV,

when attempting to implement your solution no data is pulled from the database.

Specifically what I am trying to do is to go from the

Keyname
Field_1 Field_2 Field_3 Field_4

type of layout to:

Keyname
Field_1
Field_2
Field_3
Field_4

When I move the field and delete the layout table from the default wizard, the resulting report will not pull the data out.

Any thoughts?