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.
6  1741  twinnyfo 3,653
Recognized Expert Moderator Specialist
axmohammad1,
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.
Thanks!
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.
[IMG]https://ibb.co/kQG8bks
, https://ibb.co/GCwQ4CF[/IMG]
twinnyfo 3,653
Recognized Expert Moderator Specialist
ax,
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.
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.
NeoPa 32,558
Recognized Expert Moderator MVP
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.
Rabbit 12,516
Recognized Expert Moderator MVP
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.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Lin Ma |
last post by:
Greetings,
In my search application, user can type a number to search. I use LIKE in my
query.
If a query result generates over 10,000 recordsets, it may several minutes
to run.
Is there a way to only query certain recordset at a time?
|
by: Surajit Laha |
last post by:
I am firing a query like:
SELECT TaskName, StartDate FROMTasks
WHERE StartDate >= '01-Aug-2003'
Now the result comes as:
TaskName StartDate
--------------------------
Task1 01-Aug-2003
|
by: Craig M |
last post by:
Hi,
I've created a query that has all calculations needed, and made a report
based on this.
I have then made a form based on this query.
What I would like to do is print only the current record on the form. This
is because the
report is a "letter" and I only want 1 record per page.
|
by: Matthew Louden |
last post by:
I am new to Crystal Report at all. I wonder if we can transform datagrid
result to crystal report directly?? What I want is that the datagrid shows
the result, and user can make a report from that.
please advise on how to get started. Thanks!!
|
by: Maarten van der Cammen |
last post by:
Hi,
In a table I have two numeric fields (e.g. FieldA and FieldB). Both fields
have double precicion (field size "double"), Format "Fixed" and Decimal
places "3" since I want to calculate with at least 3 digits precision (e.g.
values might show as 0.123).
In a select query, I divide FieldA by FieldB. All results show properly.
Then I...
| | |
by: reeba |
last post by:
I want to store the query result, in an servlet, into an xml file and display the contents of the xml file on the browser......
my code is as follows:
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
// List dataList = new ArrayList();...
|
by: NDayave |
last post by:
How do,
I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.
What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.
I am aware of the problems of inserting blank records to tables. I say this as the...
|
by: benchpolo |
last post by:
SELECT a.claimno
,a.diagrefno
,a.diag
,a.diagdesc
,b.diagrefno as diagrefno2
,b.diag as diag2
,b.diagdesc as diagdesc2
,c.diagrefno as diagrefno3
,c.diag as diag3
,c.diagdesc as diagdesc3
|
by: urfriend |
last post by:
Hi,
I have a multiple search form, and when I use it, it displays the result according to the criteria given in that form.
However, the result is shown in datasheet view as a query result.
How can I automate the output to show on a form instead of a query in datasheet view??
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
