By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,764 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

Issue when creating a NEW SORTING LEVEL in a REPORT

100+
P: 135
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
Sep 10 '07 #1
Share this Question
Share on Google+
4 Replies


puppydogbuddy
Expert 100+
P: 1,923
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.
Sep 10 '07 #2

100+
P: 135
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
Sep 10 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
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.
Sep 10 '07 #4

Expert 100+
P: 296
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.
Sep 10 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.