Trying to do a simple parameters report.....

[Davide]

Hi i'm davide, in these days i'm working for a project that requires telerik on windows form c# desktop application.        So i'm trying to figure out what i need to do it but i don't find pretty much anything online, i can't find a solution please help me.

My little exercise consist in asking a year of school (1 to 5) to print only the ones students in that year, cvyear is a int from 0 to 5, I'M ITALIAN SO 1) ANNO = YEAR, classes is a type class, stu is a list of student. CODE:

string year = cvyear.ToString();
            var report1 = new Telerik.Reporting.Report();
            report1.DataSource = null;
            reportViewer1.ReportSource = null;
            var objectDataSource1 = new Telerik.Reporting.ObjectDataSource();
            objectDataSource1.DataSource = null;
            objectDataSource1.DataSource = classes.Stu;
            report1.DataSource = objectDataSource1;
            Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
            reportParameter1.Name = "yearParam";
            reportParameter1.Text = "Enter Value for year";
            reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
            reportParameter1.AllowBlank = false;
            reportParameter1.AllowNull = false;
            reportParameter1.Value = year;
           
            reportParameter1.Visible = true;
            
            reportParameter1.AvailableValues.DataSource = objectDataSource1;
            reportParameter1.AvailableValues.ValueMember = "= Fields.Anno";
  
            Telerik.Reporting.Filter filter1 = new Telerik.Reporting.Filter();
            filter1.Expression = "= Fields.Anno";
            filter1.Operator = Telerik.Reporting.FilterOperator.Equal;
            filter1.Value = "="+ year;
            

            Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
            reportSource.ReportDocument = report1;
            reportViewer1.ReportSource = reportSource;
            reportViewer1.ClearHistory();
            
            reportViewer1.RefreshReport();

 

[Dimitar]

Hi Davide,

Thank you for the provided information!

Please note that creating reports purely from code is not recommended. I highly suggest one of our report designers instead - Report Designer Tools at a Glance - Telerik Reporting.

I created a sample report, that I believe fits your scenario, with the Standalone Report Designer and have attached it to my reply, please have a look and let me know if you have any questions.

Also, if you are new to Telerik Reporting, please make sure to have a look at the Step-by-Step Guide on Designing Telerik Reports - Telerik Reporting article to get a good idea of how the attached report works.

Regards,
Dimitar
Progress Telerik

[Davide]

 

Hi dimitar,

thank u for you reponse, actually i used the report designerfor the structure of the report that i connected to my database, the report in the code that i sent is reportViewer1.

in the rest of the code i have created a parameter and a filter, i wanted to add all these stuff in my reportViewer1 but i've tried for 2 days without succed in. It's true that i've watched only seen people do it with web application but i'm using it for desktop one. how can i give you more information?

 

[Dimitar]

Hi Davide,

In the code above, you create a brand new report at the very beginning - var report1 = new Telerik.Reporting.Report();, so you are not actually using the report that you have created with the designer.

If you have used the Standalone Report Designer, you need to unpackage the report and then use the create report object to edit it before wrapping it in an InstanceReportSource - Packaging Report Definitions Explained - Telerik Reporting.

If you have used Visual Studio Report Designer, then you would need to initialize your custom class instead of unpackaging: var report1 = new MyReport():  

For more information, you may have a look at the Managing Reports with code - Telerik Reporting articles, hope that will help.

Let me know if you have additional questions.