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

Query Result don't display in report

P: 3
I have a query to calculate the percentage. Its working fine and displaying the desired result in the Datasheet View but when I am trying to put that result in report using text box, it shows 0. Now the strange thing is I have 9 text box with different query results which also shows there data in datasheet view but when it comes to report only 1 text box shows result but other shows 0.

Please help. I googled and found nothing. Every setting and formatting checked various times.
2 Weeks Ago #1
Share this Question
Share on Google+
6 Replies

Expert Mod 2.5K+
P: 3,313

Welcome to Bytes!

Do you have 9 different queries that have these results or is there on query with 9 different values. If it is the former, you need to find a way to JOIN those queries into one recordset that the report can use for its Record Source.

More information would be helpful in this instance.

2 Weeks Ago #2

P: 3
Thanks for your reply.

All 9 queries has different values and different results fetching data from the same table.

Attached is the image of query result in datasheet view and the report view.
2 Weeks Ago #3

Expert Mod 2.5K+
P: 3,313

I can't see images that are hosted elsewhere. If you could please attach the image (use the Advanced button).

However, I think the issue is that you have 9 queries. A report can only have one record source--unless you have nine separate subreports, each of which would have a record source of the individual query. This is not unheard of. Depending on how your data is being presented, it may be a very reasonable structure. Again, I would need to know more about the data and what you are trying to do to guide the structural discussion.
2 Weeks Ago #4

P: 3
Thanks for letting me know about advanced button. Screenshot attached again with record source list.

Yes, I have 9 different queries and 9 different record source. Each text box is assigned with different record source. I don't know why its not getting any data from record source.

Please advise.
Attached Images
File Type: jpg Report field comes up 0.JPG (27.5 KB, 12 views)
File Type: jpg Query Result.JPG (26.3 KB, 12 views)
File Type: jpg record source.JPG (8.7 KB, 12 views)
2 Weeks Ago #5

Expert Mod 15k+
P: 31,561
Is this problem as simple as the fact that percentages of less than 100 are actually values less than 1? When displayed in a Control that isn't set to format as a percentage - and especially when displayed as an integer - will simply show 0.
2 Weeks Ago #6

Expert Mod 10K+
P: 12,374
Your report is showing the first record of the data. As it should. If there are multiple records, they will be displayed in the other pages of the report. Unless you put the fields in the report header, in which case only the first row will be displayed.

This is all working as it should. Rather, it looks like you misunderstand how a report works.

If you need to display all the records as a singular record, then you need to aggregate your data into a single record.
2 Weeks Ago #7

Post your reply

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