Page 2 of 2
Re: select report columns by end user
Posted: Sun Jan 27, 2019 9:53 am
by javadAbedi
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 !
Re: select report columns by end user
Posted: Sun Jan 27, 2019 1:15 pm
by davidboies
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
Re: select report columns by end user
Posted: Mon Jan 28, 2019 11:36 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Re: select report columns by end user
Posted: Sat Feb 02, 2019 10:32 am
by davidboies
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
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>
Re: select report columns by end user
Posted: Mon Feb 04, 2019 9:06 pm
by Lech Kulikowski
Hello,
Unfortunately, in the Java version, excel as data source is not supported.
Thank you.
Re: select report columns by end user
Posted: Thu Feb 14, 2019 10:34 am
by davidboies
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.
Expression with Containing
Posted: Thu Feb 14, 2019 1:08 pm
by davidboies
how can change this Expression to Containing :
Note : I want to do this but just with Expression Code
Code: Select all
Building.Code == (IIF(Code == "",Building.Code, Code))
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.
Re: select report columns by end user
Posted: Thu Feb 14, 2019 10:52 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Re: select report columns by end user
Posted: Sat Feb 16, 2019 8:55 am
by davidboies
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 :
Code: Select all
Sheet1.Country == (IIF(country == "",Sheet1.Country, country))
but it dosen't work
Re: select report columns by end user
Posted: Sat Feb 16, 2019 9:45 am
by Lech Kulikowski
Hello,
Please check the sample report at the following link:
https://demo.stimulsoft.com/#Net/Parame ... ingCountry
Thank you.