Issue when creating a NEW SORTING LEVEL in a REPORT

[Gilberto]

Hello,

I have a report with some product information and i needed to create a NEW SORTING LEVEL with some TOTAL calculations which where located at the REPORT FOOTER, just so that they could be well aligned and close to its information on the level above. The only problem is that when i run the report it asks me to "ENTER PARAMETER VALUE" and shows the name of the new sorting level.

Is there any way to eliminate this? is there any property/option or some code i could use??

Thanks

[puppydogbuddy]

Hello,

I have a report with some product information and i needed to create a NEW SORTING LEVEL with some TOTAL calculations which where located at the REPORT FOOTER, just so that they could be well aligned and close to its information on the level above. The only problem is that when i run the report it asks me to "ENTER PARAMETER VALUE" and shows the name of the new sorting level.

Is there any way to eliminate this? is there any property/option or some code i could use??

Thanks

You should base the sorting level on a field in your field list, using the sorting/grouping tool of the report designer. If this new level is derived from a calculated field of some kind, then create the new level as a column in your query. In order to help any further, you need to provide more details about this new sorting level.

[Gilberto]

You should base the sorting level on a field in your field list, using the sorting/grouping tool of the report designer. If this new level is derived from a calculated field of some kind, then create the new level as a column in your query. In order to help any further, you need to provide more details about this new sorting level.

Thanks for the reply

This new level ONLY displays some calculations (totals) from the fields that are on top of it (i am using only the footer) and the only reason i created it was for a better physical "display" of the calculations. I dont really need to store this calculations on a table or as any field, and the level itself its NOT sorting anything, i just needed the space in between some headers/footers.

Do i NEED to create the fields or columns in a query in order to eliminate the ERROR ("enter parameter value") or is there another way?

Thanks

[puppydogbuddy]

Thanks for the reply

This new level ONLY displays some calculations (totals) from the fields that are on top of it (i am using only the footer) and the only reason i created it was for a better physical "display" of the calculations. I dont really need to store this calculations on a table or as any field, and the level itself its NOT sorting anything, i just needed the space in between some headers/footers.

Do i NEED to create the fields or columns in a query in order to eliminate the ERROR ("enter parameter value") or is there another way?

Thanks

You do not need the calc control in your query, but if the calculations are based on values from other fields in the table, those fields should be in the query. The calcs themselves, should not be stored in the table.

[mlcampeau]

Thanks for the reply

This new level ONLY displays some calculations (totals) from the fields that are on top of it (i am using only the footer) and the only reason i created it was for a better physical "display" of the calculations. I dont really need to store this calculations on a table or as any field, and the level itself its NOT sorting anything, i just needed the space in between some headers/footers.

Do i NEED to create the fields or columns in a query in order to eliminate the ERROR ("enter parameter value") or is there another way?

Thanks

In order to avoid the "Enter Parameter Value" prompt, you must choose a sort field that exists in your field list. That's why it was suggested that maybe you add the calculations to your query, then it would be in your field list. Another thing you could try, is using one of your fields in your field list and creating a footer for it, and placing your calculations in that footer. Just be careful that it doesn't mess up the sorting that you are trying to achieve.