How change the scale of x Axis?

Hi, how do I change the scale of x axis to a larger time scale than the data ?

Data is in quarters and I want that to be displayed in a line graph, but I want the labels to show hours

(it becomes messy otherwise when showing several days)

Thank You,

Regards

G?ran

You may want to take a look at the chart label section of the following article: http://msdn2.microsoft.com/en-us/library/aa964128.aspx#moressrscharts_topic3

-- Robert

|||

Thanks, a useful article.

Guess I figured it out myself, I grouped on this to avoid quarter labels:

SELECT DATEPART(DAY,QuarterDate) as DayGroup, DATEPART(HOUR,QuarterDate) as HourGroup

How can we manually change the scales displayed on ProClarity Perspective Views?

Hi, all here,

Thank you very much for your kind attention.

I still think here should be an ideal place for me to put my post here for help for ProClarity (with SQL Server 2005 Analysis Services)

Would please any expert here give me any guidance and advices for if it is possible for users to change scales displayed on ProClarity Perspective views? And if it is possible, how can we change it?

Thanks a lot in advance for that.

With best regards,

Yours sincerely,

You cannot change the scales of the y & x axis in Perspective.

What you can do is right click on an interesting part of the tool and choose zoom/zoom out.

The scales will automatically change according to this.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much.

With best regards,

Yours sincerely,

|||

Good luck Helen. Perspective is not a chart. Have a look at colour coding and see what you can do.

In this tool you can select leaf level members in a product dimension and colour code them at a highet level, like product categories.

It is used , as an example, to find your products that will sell at high volumes-high margins/high volumes-low margins, low volumes/low margins and low volumes/high margins.

That is way you only have measures on each axis.

HTH

Thomas

|||

Hi, Thomas,

Thank you very much.

With best regards,

Yours sincerely,

How can i use a report from Access 97

I was wondering if there is a way I can use a report from Access 97 to print a certificate using SQL Server and being displayed in ASP as well?We use Access 97 to create monthly reports and have them available for the Web. When we run the report we save it in a format called Snapshot, there is a viewer that can be used in an ASP to view Snapshot reports. They look just like they do in Access.

Here is an example of the ASP code:

<OBJECT ID="SnapshotViewer" WIDTH=100% HEIGHT=97%
CODEBASE="/apps/CabFiles/Snapview.ocx"
CLASSID="CLSID:F0E42D60-368C-11D0-AD81-00A0C90DC8D9">
<PARAM NAME="_ExtentX" VALUE="16722">
<PARAM NAME="_ExtentY" VALUE="11774">
<PARAM NAME="_Version" VALUE="65536">
<PARAM NAME="SnapshotPath" VALUE="<%=reportName%>">
<PARAM NAME="Zoom" VALUE="0">
<PARAM NAME="AllowContextMenu" VALUE="-1">
<PARAM NAME="ShowNavigationButtons" VALUE="-1">
</OBJECT>


We only do this for monthly reports, I've created a Perl script that runs after hours to generate these reports. I'm not to sure of performance and concurrency if I had these reports generated on demand by the front-end.|||but you really should be using Access 2002 with Access Data Projects.

they are a lot faster for reporting than traditonal MDB.