The X-axis of the graph should show 16 labels.
The X-axis of the graph should show 16 labels only on the X-axis, spaced evenly apart and rounded to 15 minutes.Here we have Start date , End Date & dateRange as parameters . For example, if a 24-hour window was chosen starting at midnight, the initial x-axis label should be 12:00:00 AM, and each consecutive label should be every hour and a half after that (1:30:00AM, 3:00:00AM, etc.) To find out what the interval should be, taken the time frame chosen (in minutes) and divide it by 16. For example, if a 24-hour window is chosen, the label intervals should be 24 * 60 = 1440 minutes / 16=90 minutes. Now coming to report, we are using SSRS2008 & line chart. I wrote interval expression as =(datediff("d",Parameters!StartDate.Value,Parameters!EndDate.Value)*24*60)/16 AND Interval Type as Hours. But the graph is not showing data as per the interval. Thanks In advance. Sridhar.M
March 23rd, 2011 4:59am

Please try setting the value for interval as given below =round(count(Fields!Amount.Value,"dataset1")/16) Note : replace field amount and dataset1 to appropriate field name and dataset name in your report. This should provide exactly 16 lables when the record count is exactly multiples of 16 (as in your example quarter hour records for a full day; 96 entries; 96/16=6. If not divisible by 16, the higher the count of records, the lesser chances are there it get displayed minimally more or less than 16 rows. Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 6:59pm

Thanks Bilal, But what should be the "dataset1" ? i want the date difference between startdate and Enddate & based on that date difference the labels should be displayed. Thanks, Sridhar
March 23rd, 2011 7:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics