XAF DevExpress XtraReports, 10 Feb 2022

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Part 09 Advance concepts Scripts

Description

Click Here to Subscribe: http://xaf.life/35

Websites:
https://xafmarin.com/
https://www.xafers.training/
http://xafersweekly.com/
https://www.xari.io/

Free XAF Support Hour
https://calendly.com/xari/free-xaf-support-hour

Facebook Group
http://xaf.life/4g

A

Okay: let's continue with this software training about level express reporting.

A

Our last chapter is about scripting.

A

A scripting are very useful tool in the report.

A

As I show you in last video, we see that now in the web. We're gonna have this a useful, a property in the designer in the web, because now in the web we have now. This is no available. Okay, so we're gonna. We're gonna use this scripting to make some change in the repo in runtime.

A

So let's go and see what we can do with the scripting.

A

Scripting are very long topic, so I just gonna talk about a little bit about this and make a sample that I have for you, okay, so scripting. If you go to scripting here, you have to you, have this code window that you can write code here. So in this side you have all the elements that you can create a screen.

A

You can create a split from bottom margin. You can create a script from any details. You can create a script for the report itself. As you see the records here. If you see every element has his name and what is this labeled a page aim for anything. If you select report or import header, you have here the events that have report header and in this event you can select and create some a code. A the same is with the report.

A

If you see we have the report here, but the report have more evidence that we can use to create an script okay. So what we're gonna do here? Okay, we first we're gonna, create a new parameters.

A

We're gonna create a new parameters. We're gonna call this parameter paper, size.

A

Paper size, so the okay, this parameter is gonna, be a string and then here we're gonna create a static list. You remember, the dynamic list is from the database, but this is tactics list is enter manually going to create manually. Here I just add a letter.

A

Let me add another paper, legal and my third one is f a4 e4, okay. By default, I want to appear selected okay, because this is that that we use to create a report. Okay, perfect, then, if we preview this report, then we have these new parameters. You see there they got a4.

A

So if you select, no things is gonna be changed because we haven't do anything with this new pattern, so we go back and go to the scripts. Okay in the script. We're gonna look here for the report report and then we're gonna look for all after printing. Let me see hold up because I have the code here before: printing okay before printing in this before printing.

A

This is from the report. You see. Okay, this means before the report is gonna print. It's gonna make all the code here. Okay, I just want to copy this code and paste it over there, because I have tested another report.

A

What I have to show you here this is c chart is the first thing style is the language by default. Why is hr? Because if you go to the settings the designer setting- and you see the scripting language is c chart.

A

If you change for visual basic javascript, you have to write your code in this language that you select. Okay, so now is c chart. So what we do in the first line, we just receive the report and create a buyout with this variable. We can do a lot of things. We can make this a autofit in the face, but if you see we have something special here, we can write this report point.

A

If you see, we have here intelligence that we can just look for pre-table and look for all the properties inside this report, printer name, a printer setting unit. We can change the uni from inches to centimeters or anything you know. So if you see we have access to almost everything here, uh almost everything and we can go to any labels. uh This is this is crazy, crazy, good!

A

um You have. You can create anything here inside here, but as I, as I say to you, this is just introductory.

A

If you want to know more about all the things that you can do inside here, you can go to devexpress documentation. I give you a link in the powerpoint that is going to be yours. It's powerpoint in the same page, I I put this link that is documentation about this scripting.

A

I put this everything that you can change with the scripting report: bands control, styles, appearance, data source, anything almost anything so now. Our goal here is to change the perfect paper size. Okay, so I I asked for is parameter paper size. You remember, this is the name you have to use the name here for the parameter and then the value, if it's legal, we're gonna, take this report and paper kind is where the information of the paper is, and we can change for this. Why why I use the whole name of the invite.

A

How I say to you the system drawing and because, if I don't use like this, I have to insert using um so on. So is better approach to use like this, because you don't have to add anything else. Use this code can work anywhere. I I copy okay, so you ask for paper: psi a4, perfect, side, layer, okay, so in each case you change for the paper size for each one. Okay, so let's save it other things that I that I want to show to you.

A

You have this validation if you say validate- and there is some issue- the issue is gonna appear here, because they check for this code and if the code is not good, it's gonna be a problem. Okay, perfect uh other things. You can just put this a bigger short field.

A

Okay, this is an editor inside your web and when you copy this repo to another platform, if you put here put this report in web page on or another viewer, this gonna be useful because it's inside the reference, this scripting is with the reference all the time in the web. You have to take some consideration in the documentation is the consideration you have to achieve the scripts and so on something else: okay, okay, let's go back and let's preview our report with the new script.

A

Okay, now we're gonna. Take this as letter. Okay, I'm gonna.

A

Take this report out here, if you see I'm gonna, put my device here, because I need to see what happens when I, when I change my paper side. So let's begin with this, if you see we have this paper and you see what the distance between the final line and the bottom so we're gonna change for legal and submit.

A

If you see now, we have a long page. If you see this legal is long page and this change every page.

A

Now we have a long page for our report is the same, a quantity of page, because in each a group we just make up a great page very, but we have here a our new site of paper, okay and we're gonna test, the other one that is a4 so me, and if you see we have a long page tool and then we can go back to our letter.

A

This is good because you can use this for change the paper side. If you have a crosstab or you have another, a elements that you want to to use a you. Can you can just let the people that the user change the paper side and they can see the report horizontally, more debates, more more laggers and anything else? Okay, so we can go back to the visual studio here we can put the report again, but you know you can just take it. Take it out and test anything.

A

You want okay, so with this we can just finally, a in other advanced course. We can see another things about scripting and other audience like crosstab, um a lot of other audios that we have here in the report, but for now it's over.

A

Thank you for your time. Seeing this course and see you in the advanced course bye.