1. Home
  2. Forum
  3. WPF
  4. How you could change Tablix header and Textboxes from Code Behind WPF
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

How you could change Tablix header and Textboxes from Code Behind WPF

hi Syncfusion Memebers 
 I Am beeing using syncfusion Essentiel report designer for over a month now using my community version so I have two questio I hope you help me 

first I make Report with report design it is in attachment file contains 3 Tablix render from datasource (sql local server ) 

so I want to put it in report viewer i did that and i read topic about it but problems is always counter error Syncfusion.RDL.Data.ReportModel.ParseExpression()
so I enter parameter and I want to keep datasource like same in report file but didn't work , that's all to change 3 Tablix header from codebehind 


second  like i said before i used community version and i install in my computer so and used sdk to load in Refrences to my project in Visual studio , so is this sdk also has a community licence or I have to download it seperatly from other place I hope you provide me with links 

I will Attach my code in forms to make you understand what I am facing , thank you 

Attachment: ReportsTest15_aad1c35b.rar

8 Replies
MM Mageshyadav M Syncfusion Team October 9, 2018 12:11 PM UTC

Hi Ahmed, 
 
Thanks for your interest in Syncfusion Components. 
 
Query 
Response 
first I make Report with report design it is in attachment file contains 3 Tablix render from datasource (sql local server )  
 
so I want to put it in report viewer i did that and i read topic about it but problems is always counter error Syncfusion.RDL.Data.ReportModel.ParseExpression() 
so I enter parameter and I want to keep datasource like same in report file but didn't work , that's all to change 3 Tablix header from codebehind  
 
We have validated your shared sample and the issue occurs while running the sample is due to RDL type specified as “2008” in report definition. Since the RDL report is in “2010” RDL schema, we need to change the RDL type based on this in report definition to render the report without any exception. Also, you have specified “ProcessingMode” as “Local” in your sample, We have to use “ProcessingMode” as “Remote” for processing RDL reports. We have modified your sample based on this with dummy data and the modified sample can be downloaded from the below location. 
 
 
second  like i said before i used community version and i install in my computer so and used sdk to load in Refrences to my project in Visual studio , so is this sdk also has a community licence or I have to download it seperatly from other place I hope you provide me with links 
If you have installed “Syncfusionessentialwpf” at your end, the you can find the reference assemblies from the below installed location. 
 
C:\Program Files (x86)\Syncfusion\Essential Studio\$Installed Version$\Assemblies 
 
You don’t need to refer the SDK assemblies. 
 
Regards, 
Mageshyadav.M 


UN Unknown Syncfusion Team October 9, 2018 01:03 PM UTC

Hi thank you for your help ... i want to remove parameter pannel and i think i passed parameter using GetParameter Method why it is keep shows in image below more details  and if i want to change header cells in Tablix items I could use the same idea like change textboxes is that right ?? 

https://ibb.co/k55aW9      

UN Unknown Syncfusion Team October 9, 2018 01:14 PM UTC

I will answer in that so someone can get help from this from what I read this property for hidden parameters pannel wich is in wpf ShowParametersBlock="False" also u can used in code behind 

MM Mageshyadav M Syncfusion Team October 9, 2018 01:19 PM UTC

Hi Ahmed, 
  
Thanks for your update and we are glad that provided suggestions have helped in achieving your requirement. 
  
Regards, 
Mageshyadav.M 


UN Unknown Syncfusion Team October 10, 2018 09:45 AM UTC

hi thx again it is our duty to make this tools better and better and sharing problems and thoughs can help others 
but I still have two issue with this conversion first Iknow i can use direction right to left or left to right in every tablix but can I make it to reportdefintion property or all body once time and don't have touse it in every tablix (Arabic direction of tablix and all report body )  Second how could I change image source in my code attachement that you had because i can't assign source from DOM.Source to source in window so I hope you put some light  , I want to use external Source of image how could do this 


https://ibb.co/b4mM69

MM Mageshyadav M Syncfusion Team October 10, 2018 12:05 PM UTC

Hi Ahmed, 
 
Query 
Response 
first I know I can use direction right to left or left to right in every tablix but can I make it to reportdefintion property or all body once time and don't have to use it in every tablix (Arabic direction of tablix and all report body ) 
In RDL reporting if we specify layout direction as RTL to tablix then the direction of tablix columns only changes and currently we don’t have support for this in our report viewer, so could you please confirm whether you requirement is to render the tablix and body report items in RTL layout direction or you need to change the direction of text in tablix and textbox report item. It will be helpful for us to provide the solution at the earliest. 
 Second how could I change image source in my code attachment that you had because i can't assign source from DOM.Source to source in window so I hope you put some light  , I want to use external Source of image how could do this 
If your requirement is to pass an external image in code behind, then you can set image source type as “External” and then pass the image path or image url to Image.value property. Please find the below code snippet as per your sample. 
 
Syncfusion.RDL.DOM.Image imagelogo = new Syncfusion.RDL.DOM.Image(); 
imagelogo = (Syncfusion.RDL.DOM.Image)data.Page.PageHeader.ReportItems[3]; 
imagelogo.Source = Source.External; 
imagelogo.Sizing = Sizing.FitProportional; 
imagelogo.Value  = "../../icons/adduserm.png"; 
 
Also, please find the modified sample from the below location. 
 
 
 
Regards, 
Mageshyadav.M 


UN Unknown Syncfusion Team October 10, 2018 06:28 PM UTC

thank you Mageshyadav ,for me i want use arabe language in report view so if you couldn't change direction for report body than i have to change every textbox in tablix question here can iimplement right to left direction to tablix , for report body i think is the only solution is to make other report.rdl wich textboxes and body from right to left and change between the two in runtime ??? 
i used this command but nothing change ?? 
 tablixitems.LayoutDirection = Direction.RTL
how i could change direction then for tablix and textboxes ??  further explain in image below 

https://ibb.co/hdvVzU



VS Vinoth Srinivasan Syncfusion Team October 11, 2018 10:50 AM UTC

Hi Ahmed, 

Thanks for the update. 

Currently, we don’t have a support for changing layout direction of the body and Tablix report item, but logged the requirement as a feature for future consideration. As of now, we don’t have immediate plan to progress this feature and also we request you to visit our website periodically for feature related updates. 

Please let us know if you have any concerns. 

Regards, 
Vinoth S. 


Loader.
Up arrow icon