Error When I changed Row Source Property of Chart

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

I have a chart from Cross Tab Query and I want to Change the Legend

Current Legend
Sumof Total of Ref No
Sumof In-Progress
Sumof Closed
Sumof Resolved
Sum of Pending

I was trying to change the Row Source Property of the chart in order to show
below legend

Total
In-Progress
Closed
Resolved
Pending

However after changing the row source and run my report i got this message
"Circular Reference caused by alias 'In-Progress' in query definition's
SELECT LIST"

Here is the SQL of my Cross Tab Query:

TRANSFORM Val(Nz(Count(Main.[Ref No]),0)) AS [CountOfRef No]
SELECT Main.[Owners Group], Count(Main.[Ref No]) AS [Total Of Ref No]
FROM Main
GROUP BY Main.[Owners Group]
PIVOT Main.Status In ("In-Progress","Pending","Resolved","Closed");

What should I do?
 
That error message is because you are using field name as an alias.
What you can do is use that query in another query and use the orignal field
name as an alias as they are removed from each other.
 
Back
Top