Horizontal ScrollBar in 3d Bar chart (MS Chart Control) C#

Hi,

     While implementing 3d MS Chart (Microsoft chart control) in my .net project, i’ve  found out that 3d bar chart does not comes with Horizontal scroll bar implementation. When you have more number of datapoints in the chart you will be in trouble. Though the chart control has the property for the HScrollbar, it is not working on 3d charts. After a small effort, I found a simple solution for the implementation of HScrollBar.

     Drag the Chart Control from the toolbox and add it to a panel, Drag HScrollBar control from toolbox and add it to the bottom of the panel.

      Here i have created  a method called LoadGrid() to load data to the chart control. I'm using Datatable to load the datas for chart control. Name, Amount are the columns in my datatable. Here Name will be in XAxis and Amount will be in YAxis. hscroll_chart is HScrollBar controls variable.

public void LoadGrid(DataTable myDataTable)

{

      foreach (DataRow row in myDataTable.Rows)

                    {

                        chart1.Series["Channel 1"].Points.AddXY(row["Name"], row["Amount"]);

                    }

          chart1.DataManipulator.GroupByAxisLabel(“Sum” "Channel 1");

          chart1.Series["Channel 1"].ChartType = SeriesChartType.Column;

          chart1.ChartAreas["Default"].Area3DStyle.Enable3D = true;

                   var chartArea = chart1.ChartAreas[0];

                   chartArea.AxisX.Minimum = 0;

                    chartArea.AxisX.Maximum = chart1.Series[0].Points.Count;

                   chartArea.AxisX.ScaleView.Zoomable = true;

                   chartArea.AxisX.ScaleView.SizeType = DateTimeIntervalType.Number;

                   int position = 0;

                   int size = 20;

                   chartArea.AxisX.ScaleView.Zoom(position, size);

                   chartArea.AxisX.Interval = 1;

                   chartArea.AxisY.IntervalAutoMode = IntervalAutoMode.VariableCount;

                     hscroll_chart.Value = 0;

                     hscroll_chart.Minimum = 0;

                     int ScalePoints = chart1.Series[0].Points.Count / 20;

                     hscroll_chart.Maximum = ScalePoints;

}

Then add the following in the HScrollBar Scroll event,

private void hscroll_chart_Scroll(object sender, ScrollEventArgs e)

        {

            var chartArea = chart1.ChartAreas[0];

            int val = (hscroll_chart.Value * 20);

            if (((hscroll_chart.Value * 20) + 20) <= chart1.Series[0].Points.Count)

            {

                chartArea.AxisX.ScaleView.Zoom(val, val + 20);

            }

            else

            {

                int rem = ((hscroll_chart.Value * 20) + 20) - chart1.Series[0].Points.Count;

                chartArea.AxisX.ScaleView.Zoom(val, val + rem);

            }

        }

Now run the application, when the DataPoints are more than 20 you can use scroll bar control. You can also change the DataPoints limit.

Programatically Set Custom PaperSize in CrystalReport

Programatically Set Custom 

PaperSize 

in CrystalReport

Hi,
     For one of our clients we are using crystal report  developed using Visual Studio 2005. At the deployment phase we often come across the problem of Setting Custom PaperSize in report. Our client is using custom page size of 11in x 6in , whenever the report preview is shown the report viewer automatically sets the size to A4. So the user can't able to view or print the report. So i searched  a lot to set paper size programatically. At last i found the following solution ,

  i)  First i have created Custom PageSize using ServerProperties (ie.,11in x 6in)  and named it as 11x6.

  ii) Then added the following method to my code,

  public Int32 GetPaperSize(String sPrinterName, String sPaperSizeName)
        {
            PrintDocument docPrintDoc = new PrintDocument();
            docPrintDoc.PrinterSettings.PrinterName = sPrinterName;
            for (int i = 0; i < docPrintDoc .PrinterSettings.PaperSizes.Count; i++)
            {
                int raw = docPrintDoc.PrinterSettings.PaperSizes[i].RawKind;           
                if (docPrintDoc.PrinterSettings.PaperSizes[i].PaperName == sPaperSizeName)
                {
                    return raw;
                }
            }
            return 0;
        }

  iii) Then i called this method  for the current Crystal Report Document, In my case 

CrystalReport11 is the Report Document

                this.CrystalReport11.PrintOptions.PrinterName = "Wipro LQ 1050+DX

";

                this.CrystalReport11.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)GetPapersizeID("Wipro LQ 1050+DX

", "11x6";