Jump to content
We've recently updated our Privacy Statement, available here ×

parasaniasandip

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

parasaniasandip's Achievements

Apprentice

Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. parasaniasandip
    If you are using sub report then create group and use the print when expression to eliminate extra loop.
  2. parasaniasandip
    Jasper sent the export to excel chart with image. So we must required to set the "ignoreGraphics" property as false in applicationContext.xml file. Need to set below property as false. <property name="ignoreGraphics" value="false"/> Path : \apache-tomcatwebappsjasperserverWEB-INFapplicationContext.xml
  3. parasaniasandip
    PurposeYou are looking to embed Jaspersoft reports/dashboards/views but need the users to be logged in from another application. This is a very simple (yet insecure) way to hide credentials at login. The web application will make a call into JasperReportsServer, passing the user's credentials in plain text, this method will remove them from being visible in the URL InstructionsOpen "loginState.jsp" page. \apache-tomcatwebappsjasperserverWEB-INFjspmodulesloginloginState.jsp Add below java script. {//---------------------------------------------- start java script ------------------------- var param1var = getQueryVariable("singlesingon"); if (param1var == 'y') window.location.href = "http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&ParentFolderUri=/FOLDER_NAME/SUB_FOLDER_NAME&reportUnit=/FOLDER_NAME/SUB_FOLDER/REPORTNAME" function getQueryVariable(variable) { var query = window.location.search.substring(1); var vars = query.split("&"); for (var i=0;i<vars.length;i++) { var pair = vars[i].split("="); if (pair[0] == variable) { return pair[1]; } } //alert('Query Variable ' + variable + ' not found'); }//---------------------------------------------- end java script -------------------------}[/code] Call The below link from your web application. http://localhost:8080/jasperserver/login.html?j_username=jasperadmin&j_password=jasperadmin&singlesingon=y So it will auto login and hide URL parameter. CautionsPassing usernames and passwords plaintext via URL is not a secure method for authentication, please refer to the JasperReports Server Authentication Cookbook for details on a secure Single Sign On implementation
  4. parasaniasandip
    Expression : new java.util.Date().format(“EEEE d MMM y”).toString() LETTERDATE OR TIME COMPONENTPRESENTATIONEXAMPLESGEra designatorTextADyYearYear1996; 96MMonth in yearMonthJuly; Jul; 07wWeek in yearNumber27WWeek in monthNumber2DDay in yearNumber189dDay in monthNumber10FDay of week in monthNumber2EDay in weekTextTuesday; TueaAm/pm markerTextPMHHour in day (0-23)Number0kHour in day (1-24)Number24KHour in am/pm (0-11)Number0hHour in am/pm (1-12)Number12mMinute in hourNumber30sSecond in minuteNumber55SMillisecondNumber978zTime zoneGeneral time zonePacific Standard Time; PST; GMT-08:00ZTime zoneRFC 822 time zone-0800 DATE AND TIME PATTERNRESULT"yyyy.MM.dd G 'at' HH:mm:ss z"2001.07.04 AD at 12:08:56 PDT"EEE, MMM d, ''yy"Wed, Jul 4, '01"h:mm a"12:08 PM"hh 'o''clock' a, zzzz"12 o'clock PM, Pacific Daylight Time"K:mm a, z"0:08 PM, PDT"yyyyy.MMMMM.dd GGG hh:mm aaa"02001.July.04 AD 12:08 PM"EEE, d MMM yyyy HH:mm:ss Z"Wed, 4 Jul 2001 12:08:56 -0700"yyMMddHHmmssZ"010704120856-0700"yyyy-MM-dd'T'HH:mm:ss.SSSZ"2001-07-04T12:08:56.235-0700
  5. parasaniasandip
    This is iReport bug ! To solve this issue please follow the below steps. Open XML File Remove defaultValueExpression tag value.
  6. parasaniasandip
    I am using below method and it work for me. Create one group and shift all your detail band information in group band. select group band set the below property true the group band. Start on New Page = check mark true
  7. parasaniasandip
    Steps: 1. Launch iReport, choose Tools->Options->Fonts 2. Click "Install Font" and follow the wizard to install your desired font.*Remember to tick the option "Embed this font in the PDF document" 3. Select the newly installed font and click the button "Export as extension" 4. Save the export file as JAR file 5. Copy the JAR file to the folder within your application classpath *I choose to put all the JAR files into $(JRE_HOME}/lib/ext
  8. parasaniasandip
    Need to add extra space in legend to set the legend align.
  9. parasaniasandip
    More information about "Add % sign after Value Axis Label."
    We can also provide any pattern to show the data in a particular format. $#,###,### : $1,225,457
  10. parasaniasandip
    More information about "How to create OLAP Analytically view in TIBCO JasperReports® Server Community Edition"
    IntroductionBelow it the sample of Analytical View in TIBCO JasperReports® Server Community Edition Download the JaspersoftOLAP-Workbench from the below link. http://kaz.dl.sourceforge.net/project/jasperserver/JasperServer/JasperServer%204.0.0/JaspersoftOLAP-Workbench-cp-4.0.0.zipOpen: C:JaspersoftOLAP-Workbench-cp-4.0.0JaspersoftOLAP-Workbench-cp-4.0.0JaspersoftOLAP-Workbench-cp-4.0.0workbench.bat Create a Database Connection and OLAP Schema:Generate MDX QueryAuto generate the MDX Query and separately save as it requied to use at the time of create OLAP view on server. Follow the below All step one by one to upload the OLAP Schema on TIBCO JasperReports® Server. Create the connection to the sample Foodmart database Next, Create each level of the OLAP Schema After follow the above all steps, SAVE the OLAP Schema with .xml extenstion. Download / Install JasperReports® Server Community Edition follow the steps below: Create an Analysis Schema Create an Analysis Data source. Create JDBC Connection. Create OLAP Client Connection and configure Schema and Datasource. Configure Schema and Datasource. Create OLAP Analysis View Configure Connection Name which you have specified and provided MDX query whcih auto generated with Jasper Workbench. More detail recheck above section of (Generate MDX Query) Now It is very easy to work with OLAP Analysis view. ^_^
  11. parasaniasandip
    To print the label/heading on every page, it is required to set the below property.
  12. parasaniasandip
    Hi, See the section of "Pass Parameter to table " from below link to get your answer http://community.jaspersoft.com/wiki/tabular-data-pass-comma-separate-alpha-numeric-value-parameter-mssql-datasource-ie-employee
  13. parasaniasandip
    Create Split function in your Sql Server database.[toc]SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE FUNCTION [dbo].[split] ( @RowData nvarchar(MAX), @SplitOn nvarchar(5)) RETURNS @ReturnValue TABLE (Data NVARCHAR(MAX))ASBEGIN Declare @Counter int Set @Counter = 1 While (Charindex(@SplitOn,@RowData)>0) Begin Insert Into @ReturnValue (data) Select Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1))) Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData)) Set @Counter = @Counter + 1 End Insert Into @ReturnValue (data) Select Data = ltrim(rtrim(@RowData)) ReturnEND[/code]Report Queryselect empid from employeewhere empid in ( select * from Split($P{p_emp_id},',');[/code]Dataset Query.Create data set parameter : pds_emp_id select Manager_name,Manager_id,Emp_name from managerwhere empid = $p{pds_emp_id}[/code]Pass Parameter to table Select paletter and select table control.Select subdataset and follow the below steps.Click on edit table datasourseSelect "parameter" tab.Add set dataset parameter name : pds_emp_idclick on right sided edit button so it will open the expression editor.select left sided "Fields" and select main report query field "empid"click Apply.Alternative option
  14. parasaniasandip
    “This functionality is no longer applicable to our latest version. Select used table any field and set the below property. Below is the Output with auto set the row height.
  15. parasaniasandip
    Hi Karuna, Dynamically change the color you can check the below link with example. http://community.jaspersoft.com/wiki/how-use-conditional-html-expression-change-font-fore-color-or-any-html-formatting Thank you.
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore