This is related to an earlier post entitled "Text in Query/Numbers in
Report"
Brief recap - report has a query as a record source. The query shows
the correct data, the report translating the text in one field into
numbers. The field in question uses a NZ function. They query is an
aggregate query with the field in question using the First operator.
After additional troubleshooting , I have found the following...
1. When the report has a group header on the field and the field is in
that group header, the report different information than the underlying
query (for that field).
2. When the report has a group header on the field and the field is in
the detail section, the report the same information as the underlying
query (for that field).
3. When the report does not have a group header on the field and the
field is in the detail section, the report the same information as the
underlying query (for that field).
Scenarios 2 and 3 are as you would expect. Scenario 1 is what is
driving me nuts.
I have tried SaveAsText, LoadFromText for the report - no effects.
Any ideas?
Thanks
2  1944 
The devil is probably in the details, but just as a guess, the Totals Query
you are using likely relies on some ordering of the data, but ordering of
the data in Reports relies on the Sorting and Grouping properties of the
Report -- perhaps there is some conflict between the two.
To further diagnose the problem, perhaps you could convert the Totals Query
to a Make Table Query, then try using the resulting table as the Record
Source of the Report. (I find temporary Tables are often useful in
debugging, though I try to avoid using them in production applications,
usually can avoid it.) This, however, might turn out to be one of those
instances where temporary tables are appropriate in production.
Larry Linson
Microsoft Access MVP
"Tom" <rt*****@swbell .net> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . This is related to an earlier post entitled "Text in Query/Numbers in
Report"
Brief recap - report has a query as a record source. The query shows
the correct data, the report translating the text in one field into
numbers. The field in question uses a NZ function. They query is an
aggregate query with the field in question using the First operator.
After additional troubleshooting , I have found the following...
1. When the report has a group header on the field and the field is in
that group header, the report different information than the underlying
query (for that field).
2. When the report has a group header on the field and the field is in
the detail section, the report the same information as the underlying
query (for that field).
3. When the report does not have a group header on the field and the
field is in the detail section, the report the same information as the
underlying query (for that field).
Scenarios 2 and 3 are as you would expect. Scenario 1 is what is
driving me nuts.
I have tried SaveAsText, LoadFromText for the report - no effects.
Any ideas?
Thanks
That's the ticket - thanks. Someday I'll go back to figure out why it
works. For now its good enough that it works.
Tom
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Stephan |
last post by:
Hi,
I'm using Visual Studio 2003 (C#) with the integrated
Crystal Report software and have the following question:
How can I assign a value (string) to an unbound (string)
field in Crystal Report at runtime?
Example:
private void button1_Click(object sender,
|
by: Danny J. Lesandrini |
last post by:
First, this is _not_ a question about how to get Crystal Reports to run
on a client machine. I've got all the merge modules added to the project
and it's working fine. The question is about distributing my .RPT files.
1) Initial Setup Project inclusion of .rpt files:
My folder of new .RPT files keeps growing. Is there a way to point
my deployment/setup project to the folder containing these .RPT files
so they are added...
|
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what a spreadsheet might show, the
column names will actually be dynamic, based on data from a SQL Server 2000
database. The row data will also come from the same database. So in this
case, I will have a main report and a subreport. I've already tried...
|
by: Danny J. Lesandrini |
last post by:
Didn't get any takers on this post this morning at dotnet.General, so I'm
reposting here.
First, this is _not_ a question about how to get Crystal Reports to run
on a client machine. I've got all the merge modules added to the project
and it's working fine. The question is about distributing my .RPT files.
1) Initial Setup Project inclusion of .rpt files:
My folder of new .RPT files keeps growing. Is there a way to point
|
by: Kaur |
last post by:
Hi,
I am trying to create a crosstab type of report without using crosstab
query. The report captures several survey questions and for each survey
questions there are multiple choices that users responded to. There are
three tables for this particular report that will be used. LkupQuestion
has all the questions, LkupAnswerChoices has all the anwerChoices. The
third table contains the association of questions and anwer choices
with the...
| | |
by: Stinky Pete |
last post by:
Evening,
I have a form that uses 5 pages (it's an electronic copy of the paper
version) we are going to use for manufacturing non conformances and
product deviations. In case your wondering, it's 5 pages to get the
risk assessment done before it gets to my area in QA and the db is a way
to electronically archive the information for regulatory compliance
reporting. Anyway, I've been merrily going along making a report the
same as the...
|
by: itmags |
last post by:
I need to create a couple of reports, invoices, credit reports, etc...
My question is: How/what is the best way to go about this using
VB2005 / SQL Server 2000
Crystal Reports? MS Reporting? Home brew using print document?
(Program to be distributed thoughout this office and possibly to a few
other organizations that have expressed an interest).
I've taken a couple of stabs at this and either this is more
|
by: lorirobn |
last post by:
Hi,
I have a report displaying items that are missing from a room. I
created 2 queries, the first getting the items IN the room, and the
second being an "unmatched" query that references the first query
where Item is Null. I use a subreport for the details, and the
results display correctly.
However, the Report_Details event of the subreport is executed about 2
or 3 times more than I would expect (I think 3 times when I have a
|
by: JessicaZ |
last post by:
Hi everyone! I'm new here and have a question regarding Leban's report to pdf tool. I am working on a database where we are using this code to send a report out to pdf(duh) BUT what I need to do is a bit more complicated.
Basically the db keeps track of stock in various locations. Each month, a report must be run for the 76 locations and put into pdf so the reports can be put onto sharepoint .
I would like the database to loop through...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| |
