Skip to main content

Posts

Showing posts from September, 2021

Print Value on Conditional basis in SSRS : Using IIF Function in Business Central / Navision

Hi Everyone, In this blog we will see how we can print expression based on some condition in SSRS Report (RDLC Layout).Like, IF (Value1 = true,"kunal","Huria")..This means if value1 is true then its print Kunal else it prints Huria . Step-(1)  Here i am taking this example of my customized Report, if   "Payee Name"  field value is blank then it will Print  Kunal  otherwise it will print  "Payee Name"  field value. Add this code in Textbox Expression as shown below: =IIF(Fields!Payee_Name.Value="","Kunal",Fields!Payee_Name.Value) Step-(2) Output >> This will show the output while generating Report for below cases:- Case-(i) If   "Payee Name" field value is blank : Case-(ii) If "Payee Name" field have some value: Thanks for Reading!! Stay tuned for more Articles!!!

Modify Navision / Business Central Table Fields Data using SQL Database

Hi Readers, In this article we will see how we can directly modify some fields data of Nav / Business Central Tables directly from SQL Server Database. Step-(1) Run SSMS (SQL Server Management Studio) as Administrator and connect it with desired Server Name. Step-(2) Now select the required Database then Right click on Tables >> Filter >> Filter Settings >> and filterout the table using name. For example: Customer.   Step-(3) Select the desired table & Right click on it, then choose Edit Top 200 Rows. Data pane designer window will Open as shown below: Step-(4) Now the above screen shows only top 200 Rows, If we want to show all records just Right click on any field of the data designer pane then select Pane >> SQL this will open the query window. Step-(5) Now to show all records just remove Top (200) from Query and Right click on it then click on Execute SQL. Step-(6) This Data Designer window will show all the records available in the table, yo...

Display Page x of y in SSRS Report : Business Central / Navision

Hi BC Lovers, In this article we will see how we can display Page No. in the Header or footer part of the page in RDLC Report layout, by using inbuilt functions (PageNumber & TotalPages) in SSRS report. Step- (1) Just Open the RDLC Layout (Edit Mode) and add below Expression in required textbox as shown below: Page [&PageNumber] of [&TotalPages]   Step- (2) Now just save & update the Layout and Run the Report, the output will be: I hope it helps!! Thanks for Reading!!! Your valuable comment & feedback is Highly appreciated.