Some info not showing up in my report

[Lori2836 via AccessMonster.com]

Good morning. I have a report that is pulling from a query. When I run the
query, it has all the data it should have. But when I open the report, I
don't see all of the information that was in the query.
Since the data is there, when I run the query......does anyone have any tips
on what I should look for in my report, that it would all not be coming thru?
I have no filters set up.


Thanks!

 

[Lori2836 via AccessMonster.com]

Never mind! Found the answer myself...........have a good day everyone!

 

[Tom Lake]

Never mind! Found the answer myself...........have a good day everyone!

So what is the answer? Your solution may help someone else!

Tom Lake

 

[ACSOTECH]

Good Grief! What was the answer - I am having the exact same problem!

 

[Evi]

Are you using the Report Print Preview instead of the Report View button?
Or are you running Acc2007?
Evi

 

[ACSOTECH]

Yah! You guessed it! Access 2007. I solved the problem, but I can't help
but feel that it's a work around. Would like to hear your take before I give
you my work around.

Thanks, for looking at this for me!

 

[Evi]

My only take is that I'll stick to Antique2000 instead of upgrading
I've seen this problem come up before in the newsgoup so your workaround
may be a reference point for many a fellow-sufferer!
Evi

Yah! You guessed it! Access 2007. I solved the problem, but I can't help
but feel that it's a work around. Would like to hear your take before I give
you my work around.

Thanks, for looking at this for me!

 

[ACSOTECH]

I guess I may have been on the right track after all. The problem was in the
formula for the Dept Total. I attempted the use the calculated [sales tax]
as one of the fields in my Dept Total.... [units]*[unit price] + [sales tax].
In order to get the report to include [sales tax] data, I had to change the
Dept Total to include the complete formula even though I thought it
redundant....Dept Total: ([Unit Price]*[Units])+(([units]*[Unit
Price])*[Sales Tax Rate]). I have no idea why this is, but it worked. It's
kind of like you can't use a query formula from one field to populate another
if that makes sense.

 

[Evi]

Thanks for the info. I've found that whenever I've been tempted to refer to
a calculated field it always ends up biting me when I least expect it and
often when I've forgotten it exists!

If NetCost = [Quantity]*[UnitPrice] Then VAT must always be
([Quantity]*[UnitPrice])*[VATPercent] and never [NetCost]*[VATPercent]

Evi

I guess I may have been on the right track after all. The problem was in the
formula for the Dept Total. I attempted the use the calculated [sales tax]
as one of the fields in my Dept Total.... [units]*[unit price] + [sales tax].
In order to get the report to include [sales tax] data, I had to change the
Dept Total to include the complete formula even though I thought it
redundant....Dept Total: ([Unit Price]*[Units])+(([units]*[Unit
Price])*[Sales Tax Rate]). I have no idea why this is, but it worked. It's
kind of like you can't use a query formula from one field to populate another
if that makes sense.

My only take is that I'll stick to Antique2000 instead of upgrading
I've seen this problem come up before in the newsgoup so your workaround
may be a reference point for many a fellow-sufferer!
Evi
I
give When
I have
any

 

[ACSOTECH]

I found this on Microsoft's MS Access 2007 help website: Guess this is the
situation it is referring to:

Note When you compute a total in Design view by using an aggregate
function (aggregate function: A function, such as Sum, Count, Avg, or Var,
that you use to calculate totals.), such as Sum, or by using a domain
aggregate function (domain aggregate function: A function, such as DAvg or
DMax, that is used to calculate statistics over a set of records (a
domain).), such as DSum, you cannot use the name of a calculated control
(calculated control: A control that is used on a form, report, or data access
page to display the result of an expression. The result is recalculated each
time there is a change in any of the values on which the expression is
based.) in the function. You must repeat the expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
in the calculated control. For example:

=Sum([Quantity] * [UnitPrice])

What's really wild, is that I did a copy/paste from the webpage. The paste
above is twice the length and detail of what actually shows on the webpage.
When you do the paste, it includes any hypertext links in the paste function.
I have never seen that before. Cool!

Thanks for the info. I've found that whenever I've been tempted to refer to
a calculated field it always ends up biting me when I least expect it and
often when I've forgotten it exists!

If NetCost = [Quantity]*[UnitPrice] Then VAT must always be
([Quantity]*[UnitPrice])*[VATPercent] and never [NetCost]*[VATPercent]

Evi

I guess I may have been on the right track after all. The problem was in the
formula for the Dept Total. I attempted the use the calculated [sales tax]
as one of the fields in my Dept Total.... [units]*[unit price] + [sales tax].
In order to get the report to include [sales tax] data, I had to change the
Dept Total to include the complete formula even though I thought it
redundant....Dept Total: ([Unit Price]*[Units])+(([units]*[Unit
Price])*[Sales Tax Rate]). I have no idea why this is, but it worked. It's
kind of like you can't use a query formula from one field to populate another
if that makes sense.

My only take is that I'll stick to Antique2000 instead of upgrading
I've seen this problem come up before in the newsgoup so your workaround
may be a reference point for many a fellow-sufferer!
Evi
Yah! You guessed it! Access 2007. I solved the problem, but I can't
help
but feel that it's a work around. Would like to hear your take before I
give
you my work around.

Thanks, for looking at this for me!



:

Are you using the Report Print Preview instead of the Report View
button?
Or are you running Acc2007?
Evi

Good Grief! What was the answer - I am having the exact same problem!



:

Good morning. I have a report that is pulling from a query. When
I
run the
query, it has all the data it should have. But when I open the
report,
I
don't see all of the information that was in the query.
Since the data is there, when I run the query......does anyone have
any
tips
on what I should look for in my report, that it would all not be
coming
thru?
I have no filters set up.


Thanks!

 

[Bill Glick]

I had a similar problem to this problem and I found a work around to it that may help somebody. I had a simple bar graph in the footer of a report that showed sum of six different fields. In order to scale this chart, I needed to find the maximum value across these fields. That was pretty straight forward, however when I tried to put labels for the tick marks on the y axis, the values would not appear in report view. I'm guessing it's because I calculated the maximum in VB. I couldn't assign this maximum value to a text box and have it appear in report view. I could, however assign this value to the attribute of an item. I assigned the maximum value to the the "Top" attribute of a hidden text box, then set my max tick mark text box equal to this attribute. It works great. Yeah, it's really yoni, but I couldn't figure out another way around the problem.

Good morning. I have a report that is pulling from a query. When I run the
query, it has all the data it should have. But when I open the report, I
don't see all of the information that was in the query.
Since the data is there, when I run the query......does anyone have any tips
on what I should look for in my report, that it would all not be coming thru?
I have no filters set up.


Thanks!

--

........have a good day everyone!



Lori2836 wrote:

On Friday, April 04, 2008 1:19 PM ACSOTEC wrote:
I guess I may have been on the right track after all. The problem was in the
formula for the Dept Total. I attempted the use the calculated [sales tax]
as one of the fields in my Dept Total.... [units]*[unit price] + [sales tax].
In order to get the report to include [sales tax] data, I had to change the
Dept Total to include the complete formula even though I thought it
redundant....Dept Total: ([Unit Price]*[Units])+(([units]*[Unit
Price])*[Sales Tax Rate]). I have no idea why this is, but it worked. It's
kind of like you can't use a query formula from one field to populate another
if that makes sense.

"Evi" wrote:

On Friday, April 04, 2008 2:43 PM Evi wrote:
Thanks for the info. I've found that whenever I've been tempted to refer to
a calculated field it always ends up biting me when I least expect it and
often when I've forgotten it exists!

If NetCost = [Quantity]*[UnitPrice] Then VAT must always be
([Quantity]*[UnitPrice])*[VATPercent] and never [NetCost]*[VATPercent]

Evi


the
tax]
tax].
the
It's
another
workaround
I
problem!
When
have

Guess this is the
situation it is referring to:

Note When you compute a total in Design view by using an aggregate
function (aggregate function: A function, such as Sum, Count, Avg, or Var,
that you use to calculate totals.), such as Sum, or by using a domain
aggregate function (domain aggregate function: A function, such as DAvg or
DMax, that is used to calculate statistics over a set of records (a
domain).), such as DSum, you cannot use the name of a calculated control
(calculated control: A control that is used on a form, report, or data access
page to display the result of an expression. The result is recalculated each
time there is a change in any of the values on which the expression is
based.) in the function. You must repeat the expression (expression: Any
combination of mathematical or logical operators, constants, functions, and
names of fields, controls, and properties that evaluates to a single value.
Expressions can perform calculations, manipulate characters, or test data.)
in the calculated control. For example:

=Sum([Quantity] * [UnitPrice])

What's really wild, is that I did a copy/paste from the webpage. The paste
above is twice the length and detail of what actually shows on the webpage.
When you do the paste, it includes any hypertext links in the paste function.
I have never seen that before. Cool!


"Evi" wrote: