select report columns by end user
-
- Posts: 1
- Joined: Sun Jan 13, 2019 7:41 am
Re: select report columns by end user
Hello
I use this story for select columns by end user and i have problem:
I designed a form for user that see all columns of report
user can select column
but when I publish to Java and then Upload on Tomcat column filter does not work anymore !
I think there is some problem about publishing to Java but I don't know where !
I use this story for select columns by end user and i have problem:
I designed a form for user that see all columns of report
user can select column
but when I publish to Java and then Upload on Tomcat column filter does not work anymore !
I think there is some problem about publishing to Java but I don't know where !
-
- Posts: 5
- Joined: Mon Jan 21, 2019 8:03 am
Re: select report columns by end user
I used this story about selecting column by end-user
but my variable dosen't work on end-user side and my report is show all data and doesn't change column while variable change
but my variable dosen't work on end-user side and my report is show all data and doesn't change column while variable change
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: select report columns by end user
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
-
- Posts: 5
- Joined: Mon Jan 21, 2019 8:03 am
Re: select report columns by end user
in this sample I have 3 files
1- test3.mrt =====> it's designed in Stimulsoft Report Design 2019.1.1 Trial with one Parameters
2- Test.xlsx =====> it's a Sample data in Excel
3- test3.war =====> it's a War file after publish in Stimulsoft Report Design to Java and Uploaded in eclips
I can't Attach these files so I uploaded on another site the put here...
http://up44.ir/wkky95ti
http://up44.ir/wyza2x7l
so I want to show this report in Java but the parameter Variable dosen't work
this is my index.jsp file
1- test3.mrt =====> it's designed in Stimulsoft Report Design 2019.1.1 Trial with one Parameters
2- Test.xlsx =====> it's a Sample data in Excel
3- test3.war =====> it's a War file after publish in Stimulsoft Report Design to Java and Uploaded in eclips
I can't Attach these files so I uploaded on another site the put here...
http://up44.ir/wkky95ti
http://up44.ir/wyza2x7l
so I want to show this report in Java but the parameter Variable dosen't work
this is my index.jsp file
Code: Select all
<!DOCTYPE html PUBLIC " -//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<%@page import="com.stimulsoft.webviewer.enums.StiWebViewerTheme"%>
<%@page import="com.stimulsoft.report.dictionary.databases.StiJsonDatabase"%>
<%@page import="com.stimulsoft.report.dictionary.databases.StiXmlDatabase"%>
<%@page import="com.stimulsoft.report.dictionary.databases.StiJDBCDatabase"%>
<%@page import="java.io.FileOutputStream"%>
<%@page import="java.io.FileInputStream"%>
<%@page import="java.net.URL"%>
<%@page import="com.stimulsoft.webviewer.StiWebViewerOptions" %>
<%@page import="com.stimulsoft.webviewer.StiWebViewer" %>
<%@page import="java.io.File" %>
<%@page import="com.stimulsoft.report.StiSerializeManager" %>
<%@page import="com.stimulsoft.report.StiReport" %>
<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@taglib uri="http://stimulsoft.com/webviewer" prefix="stiwebviewer" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<title>test3.mrt - Viewer</title>
</head>
<body>
<%
final String reportPath = request.getSession().getServletContext().getRealPath("/reports/test3.mrt");
StiReport report = StiSerializeManager.deserializeReport(new File(reportPath));
report.getDictionary().getVariables().get("country").setValue("");
report.getVariables().put("country", "");
report.render();
StiWebViewerOptions options = new StiWebViewerOptions();
options.setLocalization(request.getSession().getServletContext().getRealPath("/localization/en.xml"));
pageContext.setAttribute("report", report);
pageContext.setAttribute("options", options);
%>
<stiwebviewer:webviewer report="${report}" options="${options}" />
</body>
</html>
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: select report columns by end user
Hello,
Unfortunately, in the Java version, excel as data source is not supported.
Thank you.
Unfortunately, in the Java version, excel as data source is not supported.
Thank you.
-
- Posts: 5
- Joined: Mon Jan 21, 2019 8:03 am
Re: select report columns by end user
hello, Lech Kulikowski
You right and I know that but I send it as excel because you should checking my data
I should say my data source is postgresql and my Problem is why doesn't work variable and parameters in index.jsp which is working in the Stimulsoft Reports Designer
thank you.
You right and I know that but I send it as excel because you should checking my data
I should say my data source is postgresql and my Problem is why doesn't work variable and parameters in index.jsp which is working in the Stimulsoft Reports Designer
thank you.
-
- Posts: 5
- Joined: Mon Jan 21, 2019 8:03 am
Expression with Containing
how can change this Expression to Containing :
actually, I have some variable and I want filling with end_user but if the User doesn't fill that so show all data and if User fill so it use Containing not equal !!
Thank you.
Note : I want to do this but just with Expression Code
Code: Select all
Building.Code == (IIF(Code == "",Building.Code, Code))
Thank you.
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: select report columns by end user
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
-
- Posts: 5
- Joined: Mon Jan 21, 2019 8:03 am
Re: select report columns by end user
Hello,
this is my data source table and I want when I search for example 'ina' filter China and so on ...
but just with expression
I try this now :
but it dosen't work
this is my data source table and I want when I search for example 'ina' filter China and so on ...
but just with expression
I try this now :
Code: Select all
Sheet1.Country == (IIF(country == "",Sheet1.Country, country))
- Attachments
-
- test3_modified.mrt
- (18.03 KiB) Downloaded 110 times
-
- table.jpg (45.64 KiB) Viewed 2033 times
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: select report columns by end user
Hello,
Please check the sample report at the following link:
https://demo.stimulsoft.com/#Net/Parame ... ingCountry
Thank you.
Please check the sample report at the following link:
https://demo.stimulsoft.com/#Net/Parame ... ingCountry
Thank you.