select report columns by end user

javadAbedi · Post by **javadAbedi** » Sun Jan 27, 2019 9:53 am

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 !

davidboies · Post by **davidboies** » Sun Jan 27, 2019 1:15 pm

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

Post by **Lech Kulikowski** » Mon Jan 28, 2019 11:36 pm

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

davidboies · Post by **davidboies** » Sat Feb 02, 2019 10:32 am

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>

Post by **Lech Kulikowski** » Mon Feb 04, 2019 9:06 pm

Hello,

Unfortunately, in the Java version, excel as data source is not supported.

Thank you.

davidboies · Post by **davidboies** » Thu Feb 14, 2019 10:34 am

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.

davidboies · Post by **davidboies** » Thu Feb 14, 2019 1:08 pm

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.

Post by **Lech Kulikowski** » Thu Feb 14, 2019 10:52 pm

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

davidboies · Post by **davidboies** » Sat Feb 16, 2019 8:55 am

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

Post by **Lech Kulikowski** » Sat Feb 16, 2019 9:45 am

Hello,

Please check the sample report at the following link:
https://demo.stimulsoft.com/#Net/Parame ... ingCountry

Thank you.

select report columns by end user

Re: select report columns by end user

Re: select report columns by end user

Re: select report columns by end user

Re: select report columns by end user

Re: select report columns by end user

Re: select report columns by end user

Expression with Containing

Re: select report columns by end user

Re: select report columns by end user

Re: select report columns by end user