How to opena report in pivot chart view by default

[baba]

I like to open a report as a pivot chart from my query.
How to open a report by making the default view of report as pivot chart?.


I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis and a graph is generated. I do not know how to save it and open the report by default in pivot chart view every time I click a button.

[June7]

I don't know if this is possible. Pivot Chart is not available parameter in the report's Default View property. You can build a graph on a report that uses pivot query as data source.

[baba]

I ran the below query :
Query :
SELECT Table1.[Arrival Year], Table1.[Abend Type], Count(*) AS Expr1
FROM Table1
WHERE (((Table1.[App Name])="APP1") AND ((Year([ArrivalTime]))=Year(Date())-1) AND ((Month([ArrivalTime]))>=Month(Date())-1)) OR (((Table1.[App Name])="APP1") AND ((Year([ArrivalTime]))=Year(Date())) AND ((Month([ArrivalTime]))<Month(Date()))) GROUP BY Table1.[Arrival Year], Table1.[Abend Type] HAVING (((Count(Table1.Case))>5));
Result of the query looks like the attached document "QueryResults" :


How can I use the above details (query and its results ) to create a graph/chart using MsAccess that looks like the sample pivot chart that I have attached . I need X axis With Date as Main category and Abend Type as Subcategory showing the values as seen in the sample chart below and y axis having counts from the query.
Thanks for your help!

[June7]

Did you build that graph with Excel? I don't think Access can accomplish that double X axis labeling. The best I can do is to concatenate the Arrival and Abend fields of the sample data. The graph's RecordSource then is:
SELECT Format([ArrivalYear],"mmm"" '""yy") & " " & [AbendType] AS X, [Expr1] FROM Table1;

[baba]

I was able to create a pivot chart with two columns in X axis in MsAccess also. First created a query,then created a pivot chart in a form. This was the only option that worked for me . Thanks