Geoffseymour.Com

December 31, 1969

SQL Server Reporting Services Chart Label Interval

Filed under: 284 — admin @ 6:00 pm

When you generate a chart using date dimension for x-axis, by default, it will try to show every date as label, which make the label unreadable if you have hundreds of date. This problem can be resolved by setting “interval” in “Major gridlines”. For example, if you put “5″ in interval, it will only show one label every 5 days.

However, the problem may persist if the date range are flexible. If you have a report period varies from 1 days to 10 years, a set number in interval may not fit all circumstances. A solution is to set a fix number of labels shown (flexible interval) instead of fix interval.

Put an expression like this one as interval: =Floor(Count(Fields!Date.Value)/5)

With this expression as interval, the chart will show only 6 labels in x-axis regardless of the date range.

Source: chenty

2 Comments »


  1. PillSpot.org. Canadian Health&Care.No prescription online pharmacy.Special Internet Prices.Best quality drugs. High quality drugs. Order pills online

    Buy:Synthroid.Nexium.100% Pure Okinawan Coral Calcium.Accutane.Petcam (Metacam) Oral Suspension.Prevacid.Human Growth Hormone.Zovirax.Arimidex.Lumigan.Valtrex.Prednisolone.Retin-A.Zyban.Mega Hoodia.Actos….

    Trackback by TIMOTHY — July 15, 2010 @ 7:52 pm


  2. MedicamentSpot.com. Canadian Health&Care.Best quality drugs.No prescription online pharmacy.Special Internet Prices. Low price drugs. Order drugs online

    Buy:Zocor.Zetia.Seroquel.Benicar.Prozac.Advair.Female Cialis.Amoxicillin.Cozaar.Acomplia.SleepWell.Nymphomax.Lipothin.Wellbutrin SR.Lasix.Female Pink Viagra.Aricept.Lipitor.Buspar.Ventolin….

    Trackback by RONALD — July 21, 2010 @ 2:46 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress