Minor question

[Gil Lopes via AccessMonster.com]

I made a line-chart in my report - for more details you may read a previous
thread I made for help.

Anyway, after fighting around with it, I managed to make the chart as I
wanted.
The problem is that I get in my report a complete list of many pages, all
showing the same exact chart.

Anyone can help with this?
I just want it nor to repeat itself...infinetely...

Is there any property line I' m missing on this?
I can' t get it.

My chart is a MS Graph Object, and it shows a progression of a percentage
value trough a time range.
the source of it is a query I have.

Any help is appreciated.

Regards,

Gil

 

[Duane Hookom]

Generally this is due to having a Record Source for your report. If you only
need a graph, then the Row Source of your graph is your data and your report
doesn't need a record source.

 

[Gil Lopes via AccessMonster.com]

Thanks Duane. You' re applying for a job as a Saint...

That really solved the problem, but leaving another one : (

I do need to have some other data sources in my report. I don't need to use
that query anymore, but I do need to add some other tables and queries to my
report. And that is not working, as it messes up with the graph.

Can you tell me any way around this?

Regards,

Gil

Generally this is due to having a Record Source for your report. If you only
need a graph, then the Row Source of your graph is your data and your report
doesn't need a record source.

I made a line-chart in my report - for more details you may read a previous
thread I made for help.

[quoted text clipped - 19 lines]

Gil

 

[Duane Hookom]

1) Place the chart in the report header or footer section
2) use subreports to show "some other tables and queries"

--
Duane Hookom
MS Access MVP
--

Thanks Duane. You' re applying for a job as a Saint...

That really solved the problem, but leaving another one : (

I do need to have some other data sources in my report. I don't need to
use
that query anymore, but I do need to add some other tables and queries to
my
report. And that is not working, as it messes up with the graph.

Can you tell me any way around this?

Regards,

Gil

Generally this is due to having a Record Source for your report. If you
only
need a graph, then the Row Source of your graph is your data and your
report
doesn't need a record source.

I made a line-chart in my report - for more details you may read a
previous
thread I made for help.

[quoted text clipped - 19 lines]

Gil

 

[Gil Lopes via AccessMonster.com]

Thanks for all Duane!

I now have a report with 3 independent charts working as intended (well,
allmost).

I did removed any source from my report, and made those charts with row
sources that work.
I now have two distinct problems:

1. When I create a subreport to show some other values (like "Max([query.used.
by.chart]) ) it shows the message: "Group by multi-level not allowed in
subquery" - something alike, as my office is in portuguese - and the
subreport doesn' t show the intended value.

2. Another issue is that I would like you to please tell me how is the syntax
of a "Group by" string in SQL, in a query.
I' m trying to group a field by month in a query wich has the following
fields: Date , cash-flow and ProductID. As the cash-flows are very small, I
would like them to be grouped by month, but couldn' t find a way to get
around it but SQL commands, but I really don' t know enough SQL to try and
compose the syntax. This query will feed one of the 3 independent charts in
my report.

Help? : )

Regards,

Gil

1) Place the chart in the report header or footer section
2) use subreports to show "some other tables and queries"

Thanks Duane. You' re applying for a job as a Saint...

[quoted text clipped - 24 lines]

 

[Duane Hookom]

1. I don't know what would be causing the error message regarding the
multi-level group by. You haven't shared the SQL view of your subreport or
the sorting/grouping used in the subreport.

2. You can allow the GUI/design view of your query create your query's SQL.

--
Duane Hookom
MS Access MVP

Thanks for all Duane!

I now have a report with 3 independent charts working as intended (well,
allmost).

I did removed any source from my report, and made those charts with row
sources that work.
I now have two distinct problems:

1. When I create a subreport to show some other values (like
"Max([query.used.
by.chart]) ) it shows the message: "Group by multi-level not allowed in
subquery" - something alike, as my office is in portuguese - and the
subreport doesn' t show the intended value.

2. Another issue is that I would like you to please tell me how is the
syntax
of a "Group by" string in SQL, in a query.
I' m trying to group a field by month in a query wich has the following
fields: Date , cash-flow and ProductID. As the cash-flows are very small,
I
would like them to be grouped by month, but couldn' t find a way to get
around it but SQL commands, but I really don' t know enough SQL to try and
compose the syntax. This query will feed one of the 3 independent charts
in
my report.

Help? : )

Regards,

Gil

1) Place the chart in the report header or footer section
2) use subreports to show "some other tables and queries"

Thanks Duane. You' re applying for a job as a Saint...

[quoted text clipped - 24 lines]

Gil

 

[Gil Lopes via AccessMonster.com]

Hummm...
Let me start by showing you the SQL of my query (the one I wish to be grouped
by month):

SELECT DISTINCTROW CashFlowsAbertos.Data, CashFlowsAbertos.[Cash-Flows],
CashFlowsAbertos.[Nome do Fundo]
FROM CashFlowsAbertos
WHERE (((CashFlowsAbertos.Data)>=[forms]![consultaperiodo]![datacom] And
(CashFlowsAbertos.Data)<=[forms]![consultaperiodo]![datafim]) AND (
(CashFlowsAbertos.[Nome do Fundo])=[forms]![consultaperiodo]![fundrend]))
ORDER BY CashFlowsAbertos.Data DESC;

So, I would like to group CashFlowsAbertos.[Data] (which is date) by month,
with the correspondent sum of CashFlowsAbertos.[Cash-Flows]. But I really don
't know how to write the syntax. Any hints?

Thanks!!!

Gil

1. I don't know what would be causing the error message regarding the
multi-level group by. You haven't shared the SQL view of your subreport or
the sorting/grouping used in the subreport.

2. You can allow the GUI/design view of your query create your query's SQL.

Thanks for all Duane!

[quoted text clipped - 37 lines]

 

[Duane Hookom]

SELECT CashFlowsAbertos.[Nome do Fundo],
Year(CashFlowsAbertos.Data) as Yr,
Month(CashFlowsAbertos.Data) as Mth,
Sum(CashFlowsAbertos.[Cash-Flows]) As SumCashFlow
FROM CashFlowsAbertos
WHERE (((CashFlowsAbertos.Data)>=[forms]![consultaperiodo]![datacom] And
(CashFlowsAbertos.Data)<=[forms]![consultaperiodo]![datafim]) AND (
(CashFlowsAbertos.[Nome do Fundo])=[forms]![consultaperiodo]![fundrend]))
GROUP BY CashFlowsAbertos.[Nome do Fundo]
Year(CashFlowsAbertos.Data),
Month(CashFlowsAbertos.Data)
ORDER BY
Year(CashFlowsAbertos.Data) DESC,
Month(CashFlowsAbertos.Data) DESC;


--
Duane Hookom
MS Access MVP

Hummm...
Let me start by showing you the SQL of my query (the one I wish to be
grouped
by month):

SELECT DISTINCTROW CashFlowsAbertos.Data, CashFlowsAbertos.[Cash-Flows],
CashFlowsAbertos.[Nome do Fundo]
FROM CashFlowsAbertos
WHERE (((CashFlowsAbertos.Data)>=[forms]![consultaperiodo]![datacom] And
(CashFlowsAbertos.Data)<=[forms]![consultaperiodo]![datafim]) AND (
(CashFlowsAbertos.[Nome do Fundo])=[forms]![consultaperiodo]![fundrend]))
ORDER BY CashFlowsAbertos.Data DESC;

So, I would like to group CashFlowsAbertos.[Data] (which is date) by
month,
with the correspondent sum of CashFlowsAbertos.[Cash-Flows]. But I really
don
't know how to write the syntax. Any hints?

Thanks!!!

Gil

1. I don't know what would be causing the error message regarding the
multi-level group by. You haven't shared the SQL view of your subreport or
the sorting/grouping used in the subreport.

2. You can allow the GUI/design view of your query create your query's
SQL.

Thanks for all Duane!

[quoted text clipped - 37 lines]

Gil

 

[Gil Lopes via AccessMonster.com]

I did the following, based on your help:

SELECT Month(CashFlowsAbertos.Data) & "-" & Year(CashFlowsAbertos.Data) AS
Datab, Sum(CashFlowsAbertos.[Cash-Flows]) AS SumCashFlow
FROM CashFlowsAbertos
WHERE (((CashFlowsAbertos.Data)>=[forms]![consultaperiodo]![datacom] And
(CashFlowsAbertos.Data)<=[forms]![consultaperiodo]![datafim]) AND (
(CashFlowsAbertos.[Nome do Fundo])=[forms]![consultaperiodo]![fundrend]))
GROUP BY Month(CashFlowsAbertos.Data) & "-" & Year(CashFlowsAbertos.Data),
CashFlowsAbertos.[Nome do Fundo], Year(CashFlowsAbertos.Data), Month
(CashFlowsAbertos.Data)
ORDER BY Month(CashFlowsAbertos.Data) & "-" & Year(CashFlowsAbertos.Data);

The idea of my minor changes was to get a value that was similar to a normal
date, so that my chart would recognize it as a date (that was giving me big
headaches).
It is working as intended, and my database is coming together.
Mostly, thanks to you.

Sincere regards,

Gil