fabricerd

Hi you can also try jasperstarter you can launch a jaspereport () from command line to view print or export the data source defined in a conf file and you can also pass parameters to your report https://sourceforge.net/projects/jasperstarter/ For example My report is launched by command line "F:Program Files (x86)JasperStarterbinjasperstarter.exe" pr "F:Program Files (x86)JasperStarterbindocsage.jasper" -f view @"F:Program Files (x86)JasperStarterbinsagebijou.conf" -P dopiece=%1 -a For example my sagebijou.conf file content -t generic --db-drivernet.sourceforge.jtds.jdbc.Driver--db-urljdbc:jtds:sqlserver://localhost:1435/BIJOU-uUsername-pPassword

If you already setup with token authentication and configured externaltokenauth xml file You should find (like in samples) an section related to role mapping that could help you mapping external role in token for exemple EXTERNALJASPERADMIN to role ADMIN in jasper Then you can have new users (externally defined) logged with same role as Jasperadmin

Did you activate logging verbosity for your authentication as I explained? It helps a lot for debugging looking in web-Inf/logs/jasperserver.log What is the password encryption in your db?are they stored in clear plain text?

I Aldo add problem but jaspent support helped me with these infos: You should store your authentication dB infos in properties file open configuration file jasperserver-proWEB-INFjs.externalAuth.properties add the information about the database that stores your users/roles (below is only a sample from my environment, for your reference only) : external.jdbc.driverClassName=org.postgresql.Driver external.jdbc.url=jdbc:postgresql://localhost:5432/mydb external.jdbc.username=postgres external.jdbc.password=postgres - click menu Manage->Server Settings - navigate to the Log Settings tab and in the very bottom of the list add the line: com.jaspersoft.jasperserver.multipleTenancy.security.externalAuth.db.MTExternalJDBCUserDetailsService - set the verbosity level to DEBUG Application server should be restarted to apply the changes that have been done. You should Then be able to adjust your application-context-external-db-mt properties file and debug don't Forget to reset your externaldatasource Bean as sample supplied by jasper To be sure if you have done some testing in your xml restart your conf from jasper externaldbmt sample just put your queries in, debug and then go ahead with bean conf Fabrice

just define your nimber of Columns in report properties and detail height in mm according to your label sheet The layout Will change showing you columns and then your design your label in the detail left column

Maybe your db engine could provide you a serie of data with a query and you can use a dataset

With ireport or jasper studio you should be able to add parameters at report level with type and default value For example a Boolean printDetail1 and another printDetail2 At the detail band level you will find a property "print when expression" that you can fill with your logical test in your case printDetail1==true and printDetail2==true on your other band

you are saying that password hashing is broken "user reading from db". Does it mean that sample-applicationContext-externalAuth-db-mt.xml is completly broken and we can't use external db authentication anymore until 5.6 or 6? How can we fix it, if we plan to deploy very soon a pro version with externalAuth-db-mt mechanism? Thanks

Please Find below my Eclipse log !SESSION 2011-07-18 17:21:01.123 ----------------------------------------------- eclipse.buildId=M20110210-1200 java.version=1.6.0_26 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=fr_FR Command-line arguments: -os win32 -ws win32 -arch x86_64 -consoleLog -debug !ENTRY org.eclipse.osgi 2 0 2011-07-18 17:21:04.889 !MESSAGE One or more bundles are not resolved because the following root constraints are not resolved: !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.889 !MESSAGE Bundle reference:file:plugins/com.jaspersoft.studio_1.0.0.jar was not resolved. !SUBENTRY 2 com.jaspersoft.studio 2 0 2011-07-18 17:21:04.889 !MESSAGE Missing host Bundle-NativeCode_0.0.0. !ENTRY org.eclipse.osgi 2 0 2011-07-18 17:21:04.904 !MESSAGE The following is a complete list of bundles which are not resolved, see the prior log entry for the root cause if it exists: !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.904 !MESSAGE Bundle com.jaspersoft.studio_1.0.0 [297] was not resolved. !SUBENTRY 2 com.jaspersoft.studio 2 0 2011-07-18 17:21:04.904 !MESSAGE Missing host Bundle-NativeCode_0.0.0. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.904 !MESSAGE Bundle com.jaspersoft.studio.barcode_1.0.0 [298] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.barcode 2 0 2011-07-18 17:21:04.904 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.2. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.chart_1.0.0 [299] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.chart 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.2. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.crosstab_1.0.0 [300] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.crosstab 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.4. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.data_1.0.0 [301] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.data 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.2.5. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.html_1.0.0 [303] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.html 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.2. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.list_1.0.0 [304] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.list 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.2. !SUBENTRY 1 org.eclipse.osgi 2 0 2011-07-18 17:21:04.920 !MESSAGE Bundle com.jaspersoft.studio.table_1.0.0 [305] was not resolved. !SUBENTRY 2 com.jaspersoft.studio.table 2 0 2011-07-18 17:21:04.920 !MESSAGE Missing required bundle com.jaspersoft.studio_0.0.6.

I can't find any ReportDesign Perspective, i can only find a view called JasperResport Preview

I tried to install jaspersoft studio from http://jasperstudio.sourceforge.net/updates/site.xml and i can't find the jasperstudio perspective both installs are fresh new eclipse classic package eclipse-SDK-3.6.2-win32-x86_64 and eclipse-SDK-3.7-win32-x86_64 what am i doing wrong ?