Hi,
I am working on making dynamic excel report using jsreport where columns will be dynamically added and removed. I wanted to know how can I make formulas dynamic so that the columns are independent of each other. Can anyone please help me in this.
Thank you.
My mistake. Thank you.
Here's the link of playground workspace : https://playground.jsreport.net/w/anon/FxUJFByX
Link for playground workspace : (Folder Name - testDataModel) : https://mayur-itt.jsreportonline.net/studio/templates/S1gFfMdxGP
Dear Js-report team,
I am using two separate tables from two separate sheets and creating their pivot tables and, then I was trying to connect them via a data model by creating a relationship based on primary and foreign keys. I want to connect these two tables to a single slicer. However, after uploading my xlsx template and after downloading preview, I am getting an error "an issue with a data model is preventing excel to open this workbook." Can you please help me in understanding the cause of this error and how it can be solved.
Can someone help me, I am creating a xlsx template with charts and will be using this template in jsreport. How can I make charts behave dynamically. If I add more data or remove some data the chart should automatically update. Please can someone help. Thank you.
I am using xlsx recipe. Sorry for replying late. Will try this and come back to you. Thank you
Yes I am using xlsx recipe. I will try the way you said. Thank you
Hi All,
Can you please help me to understand how to dynamically hide charts when there is no data related to that chart using jsreport. Thank You in advance.
Hi, I was working on jsreport and I was able to render excel sheet. After downloading excel sheet which has 4 worksheets and opening it in windows system it is landing to default worksheet(sheet 2) as expected but the tab of default worksheet is going behind 3 dots and tabs of sheet 3 and sheet 4 are displayed. It is working fine in Linux system and online excel, only in windows system I am facing this problem. Can you please help me. Thank in advance.
The above pic is how I am getting after opening the excel report.
The second pic is how I want the output. All tabs should be visible.