jme14
-
Posts
20 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by jme14
-
-
Create an "input control" with type "single select query".
Enter a SQL query to select the date values you want, like "to day", "yesterday" and "last month" like:
select current_date() as id, 'Today' as name
union
select date_sub(current_date(), interval 1 day) as id, 'Yesterday' as name
union
select date_sub(current_date(), interval 1 month) as id, 'Last month' as name
You can add as much "union select..." as you want
-
After installing Acrobat Reader X on the client PCs, users cannot open reports in Pdf (in Internet Explorer). We didn't have this problem with previous versions of Acrobat Reader.
We use jasperserver-ce-3.7.0.
Acrobat Reader X can view the Pdf output of Jasperserver, after first saving de Pdf to file.
What can we do (beside installing a previous version of Acrobat Reader)?
Regards, JanM
-
I have created an input control to select a specific error-code for an error-report. This input control selects also the error-messages and the number of times a specific error occurs (with count(*)).
select vme.id
, left(vme.code,3) as code
, concat(vme.ernst
,lpad(vme.id,3,'0')
,' - '
,vme.message
,' ('
,count(*)
,')'
) as message
from hls_verwerking_melding vme
join hls_verwerking_verslag vve
on vve.id_vme = vme.id
and (vme.ernst = $P{p_error_code} or $P{p_error_code} = '0')
group by vme.idThis works fine, but.... Jasperserver does not (always) refresh the selected data. When I use the input control, I get the same data as yesterday. (Yes, I am sure the data has been modified in the database)
How can I instruct JasperServer not to cache the data in this input control?
I use JasperServer CE 3.7.0
Regards,
Jan
-
I have exactly the same problem with 3.6.0. using compatibility of 3.0.0. I am sure my group footer does not contain new features, because I have created the report with iReport 3.0.0.
Regards
Jan Meijer
-
You can use Runjasperreports.
Website: http://gtwebmarque.com/wikis/gtwm/index.php/RunJasperReports_Usage
Regards, Jan M
-
How can I search in the postings on this forum with more than one keyword? Is it possible?
When I use more than one keyword in the "Search Forum" search field, this search is handled as a phrase...
Regards, Jan
-
How can I search in the postings in this forum on more than one keyword?
When I use more than one keyword, this search is handled as a phrase...
Regards, Jan
-
I have had the same problem on Windows Vista.
I fixed the problem by changing the default MySQL engine to InnoDB.
Regards, Jan M
-
Thanks for your reply, but I do not understand your answer.
I will rephrase my question:
I have a folder e.g. "My Reports" with a sub-folder "MyReportsFinancial Reports".
I want to define "Financial Reports" to be the default folder for the end users of JS (role_user).
How can i achieve this in jasperserver-servlet.xml?
Regards,
Jan Meijer
-
Is it possible to set the default folder after logging in (JS 3.0)?
Regards,
Jan Meijer
-
Sherman Wood
Wrote:Have a look at using permissions.
If you want normal users to not see particular folders, just give them "No Access" to those folders. Then they will never see those folders in the repository manager or in the report list.
Sherman
Jaspersoft
When you set folders to "No Access" (like the images-folder with logo's), a user does not have permission to view reports with logo's.
I am looking for a kind of "run-but-invisable" permission.
Regards, Jan meijer
-
Is there a possibility to hide folders for users (role_user) in JS 3.0?
Users get confused when browsing trough folders they don't understand....
Regards,
Jan Meijer
-
Thanks, I found some useful information in posting "Row level security logged in user as parameter?"
There is also an example in JasperServer, /Reports/Samples/Sales by Month Report
Regards,
Jan Meijer
-
In JasperServer, you can define users an roles to controle authorization.
I want to pass the current user as a parameter to my jrxml report, to filter the data for this user. Is this possible in JasperServer v3.0?
Regards,
Jan Meijer
-
I want to create a new XML/A connection to connect to the mysql schema "Regas".
When starting an analysis view (for this new connection) I get an error:
com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBC01 fault string=XMLA connection datasource not found fault actor=Mondrian
While creating the xml/a connection, I looked at the definitions of the sample connections FoodmartXmlaConnection and SugarCRMXmlaConnection.
Questions:
- Can I create a xml/a connecion in Jasperserver, or do I have to create addional files in a apache/tomcat folder?
- What values do i have to fill in for "catalog" and "data source"? I used:
Catalog: Regas
Data source: Provider=Mondrian;DataSource=Regas;
Regards,
Jan M
-
I want to create a new XML/A connection to connect to the mysql schema Regas.
When starting an analysis view I get an error:
com.jaspersoft.jasperserver.api.JSException: com.tonbeller.jpivot.olap.model.OlapException: Soap Fault code=Client.00HSBC01 fault string=XMLA connection datasource not found fault actor=Mondrian
While creating the xml/a connection, I looked at the definitions of the sample connections FoodmartXmlaConnection and SugarCRMXmlaConnection.
Questions:
- Can I create a xml/a connecion in Jasperserver, or do I have to create addional files in a apache/tomcat folder?
- What values do i have to fill in for "catalog" and "data source"? I used:
Catalog: Regas
Data source: Provider=Mondrian;DataSource=Regas;
-
I don't have any clue yet...
Any ideas? I am still interssted.
Regards,
JanM
-
Thanks for you reply.
For each group, I calculate a subtotal with expression:
$V{v_sum_amount_1}.min( $V{v_sum_amount_2} ).multiply( $F{factor} )
this means:
subtotal := minimum(amount_1, amount_2) * factor
Example group:
a_1 a_2 charge
---- ---- -----------
69,0 48,5 € 2.968,03
22,9 34,0 € 985,42
38,5 22,8 € 1.653,96
---- ---- ------------
130,4 105,3 € 5.607,41 ==> € 4.527,90 (factor = 43)
This factor can be different per group (72.5 or 43)
amount_1 stands for the total hours per employee (130.4) in January 2008
amount_2 stands for the maximum amount to charge per employee (105,3) in January 2008
The subtotal value = min(130.4, 105.3) * 43 = 105.3 * 43 = 4527.90
So, I want to calculate the sum of $V{v_sum_amount_1}.min( $V{v_sum_amount_2} ).multiply( $F{factor} ) on report.
Any ideas?
Regards,
JanM
-
I want to create some kind of timesheet with data of multiple employees. I have created a group on employee lastname.
To calculate a subtotal per employee I have created a variable V_SUM_PER_EMP:
- variable class type: java.math.BigDecimal
- calculation type: sum
- reset type: group
- reset group: lastname
- increment type: none
- variable expression: $F{minutes}
This works fine.
Now, I want to create a summary total to calculate the sum of all minutes for all employees on report. Therefore I can simply create another variable, like V_SUM_PER_EMP with reset group = report.
BUT in my report I want to compute the sum of minutes on report, based on variable V_SUM_PER_EMP (because in my real life report the variable expression of V_SUM_PER_EMP is more complex then in this example), so I created a new variable V_SUM_PER_EMP_REPORT:
- variable class type: java.math.BigDecimal
- calculation type: sum
- reset type: report
- reset group: -
- increment type: none
- variable expression: $V{V_SUM_PER_EMP}
The result value (printed in the summary band) of this calculation is NOT right.
The first group subtotal: 65.92
The second group subtotal: 22.42
The report total: 611.42
How can I calculate the right value?
java.lang.NullPointerException in Jaspersoft Studio when editing style template
in Products
Posted
I get a java.lang.NullPointerException when I try to alter de default "SimpleStyle" after creating a style template (jrtx) in Jaspersoft® Studio.
Im am using Jaspersoft Studio 6.1.0.final
Do I something wrong?
Regards, Jan Meijer