santosh.audi19
-
Posts
88 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by santosh.audi19
-
Hello, You can use Sub report concept, where put One chart in each sub report and place sub report one above the other in the main report. you can write print when expression on the Sub report. OR you can write Print when expression on the chart itself. Hope this helps. Regards.
-
Open your JRXML in the Jasper Studio, click on the Report in the Outline tab and click on Report inside the Properties window to the Right side of the whole window and check the option "Ignore Pagination " this will make whole report output to display in one Page though you have Break element. Hope this helps
-
Hello Everyone, Suppose if we want a user to access a particular Folder or particular Report can we achieve using Jasper. Please provide any Examples or Screenshots, for better understanding. Thanks.
-
1)First you need to create a folder and upload Image to Server in the same Folder and If you right click on that image and select Properties to get the path 2) Now copy the same path, In studio Click on Image and copy that path in Image Expression. Now publish your report to server. Hope this helps.
-
Hello Everyone, I have opened a Out of the Box report from the CA PPM folder into Jasper Studio there I have found $R{ProjectTypeKey} and this is also found in the folder name Common which is in Input Control folder. Suppose if I change its name to $R{RespourceTypeKey} and which is not there in the Common folder, Does it effects my report while running my report. Please help me with your Explanation.
-
Hello All, I'm Curious to know about this special Parameter $P!{}. I came to know that it is used :- "To send pieces of raw SQL or to pass the entire SQL string to execute" , Could any one suggest me simple report with an example how to use it. Thanks.
-
Hello Dino, Hope this way may helps you. Create 2 parameters of type date where one has Default value and other picks when user enters. Then use CompareTo() in the Some Variable where the you might have to frame the Code like this Param1.compareTo(Param2) .. where Param2= 1/1/1991 and Param1=1/1/1993 then the Expression returns "1" So the Variable expression should be ( Param1.compareTo(Param2) ) ? "GREEN" : "OTHER COLOR" Hope This helps.
-
Hello, Before you run the report just Compile and run it and make sure you may have given Default values in the Expression field in the Parameters. Hope this Helps. Regards, Santosh
-
Hi, Add Last Page Footer band in your report and Add Break from palette in that Last Page footer, now just below to that Break add your Stuff. Hope this Works, Regards, Santosh.
-
Hide the complete band when table in band has no sql-results
santosh.audi19 replied to franky4's topic in Products
Yes we can achieve this. supose if your Query is " SELECT I.ROLLNUM , I.NAME FROM STUDENTS "; However Rollnumber wont be Empty , after you click on Read Fields you will gget ROLLNUM and NAME a in Fields section. Click on the Band then Add a Print when Expression there. $F{ROLLNUM}!=null , So here the Expresssion states that Band Should be printed when the Value in ROLLNUM Column is not null. Hope this Helps, Thanks. -
Hi, This would be little Lenghty Suppose if we create a Jasper server Connection and open the Report in our Studio then the sub report Expression would be "repo:<reportname>.jrxml". Create a Folder in server and upload the sub reports in that folder. Right click on that Subreports and click on Properties and copy the Path After you publish the report to server right click on that report click on Edit and remove the Subreport and click on Add Resources then select these subreports from repository and click on Submit. In your Expression put this ( Your Expression )? "repo:/SubreportFolder/Report1.jrxml" : "repo:/SubreportFolder/Report2.jrxml" Thanks, Santosh.
-
Hi, May be the parameter you have created is Multiselect Parameter, after you publish the report to server then you cannot enter value in it. You should link a Input control for that Parameter ,then you will get a list of values after the Query runs. Thanks, Santosh
-
Hi Everyone, In Clarity we can make a resource to view only few or all Projects/Portlets or other Components by giving Global/Instance Rights to resources. Do we have same Option or facility on Jasper reports? I came to know Resource has right to see Advanced Reporting Right so that resource can see the Advanced reporting link. In the same way is there any option to view specific reports ? Thanks, Santosh
-
Could you please Describe what you are looking for? I didn't understand your problem. Regards, Santosh
-
I faced Bold Issues while exporting through PDF not through Excel. Steps to resolve Bold Issues. This will be lengthy solution. Suppose If you are not getting Bold for Arial. 1) Type Fonts in windows Start button , then open that folder copy that Arial font and paste in your Desktop , search for "ARIAL BOLD" font and at server side create a Folder Fonts and upload the Font at server side. 2) After uploading then right click on it and copy the Path , Open the Studio select the "TextField" for which Bold should be applied. 3)Click the Text Field and go to Advanced window and follow as shown in the screen shot. 4. Publish the report to server. Hope this also Works for your Excel output. Regards, Santosh
-
Hi , It's a Strange Exception When you drag and drop sub report Element then you will be prompted a window where you will be asked to 1) Create Sub report 2) Use Existing report After that In the next window you should select a Radio button having( Use same data source to fill the Master report). Make sure you have selected that. Hope this helps. Regards, Santosh
-
Textfield Borders are not appearing for Power point extract
santosh.audi19 replied to santosh.audi19's topic in Products
Hi , The other way i found is just to include <pen lineWidth="1.0"/> in the <box> ta of the Text Field. Regards, Santosh -
Hi Everyone, Supppose if im using Lines in my report and when I export my report to PDF , Some times lines are appearing completely. They are breaking in between. Regards, Santosh
-
Hi, we can Achieve what you are looking for . I have also Did this before :- Suppose A is main Report and B is Chart as Sub report Step -1 :- create a1 as parameter with same Class(java.lanag.Integer) in both A(main report) and B(Chart ass sub report) Step-2 :- After you create the Dataset there you can see Parameter section there you can Copy paste the Parameter what you created for A(Main report) Step-3 :-Drag and Drop the Sub report Component from Palette then when you click on Sub report right On the right side in your Jasper studio under Properties Tab open the Sub report and there will be Parameters button click on it and Add the Parameter name(a1) and Expression as($P{a1}) Step-4:- Save your report, and compile it . When you run the Report A(Main report) then the Value which you give in a1 Parameter the same would be seent to B(Chart as Sub report) and it will be picked up by the Data set you have created in the Sub report. Hope this Works. Thanks, Santosh.
-
How to frame Date to get this Format 3/24/16 2:36:46 PM
santosh.audi19 replied to santosh.audi19's topic in Products
Hi Everone, I had a Try and this is working new SimpleDateFormat("dd-MM-yyyy HH:mm:ss a").format(new Date()) -
Hi Everyone, Im trying to achieve this format 3/24/16 2:36:46 PM in Jasper , Could you help me out in Framing the Date Functions to achieve this. Regards, Santosh
-
What Property should be used to get a color for the X,Y Axis title names(Lables) Regards, Santosh
-
Jaspersoft 6.1 HTML 5 chart fails, when dataset returns zero rows.
santosh.audi19 replied to Areport's topic in Products
Solution for the Issue "when dataset returns zero rows." Hi Everyone , There is a Issue with Jasper HTML 5 chart in Clarity 14.3 version . ISSUE:- When you run a Report which has PIE Chart but the select Project dosent has Data in it , it means PIE chart has Zero Records then The Report will continously show "Please Wait" Loading Window, this wont stop untill you click on cancel. Solution for this Issue :- 1)Use your HTML 5 Chart in sub report 2) Put some Print when Expression on the Report ( like ex:- $F{ProjectID} !=null ) , so when there are no records your PIE wont appear in the report I have faced the Issue in 14.3 , after Implementing above Solution to my PIE Chart , now its working for me Hope this helps all. Regards, Santosh -
Hi EveryOne, After we create a Jasper Server Connection from Studio , Before we deploy our report to the server when we refresh The Server connection it Dosent show All Folders , After If I wait for a 10-15 Mins I can see all Folders at Studio side and at Clarity Application(At Advanced Reporting). The Problem here is The report where we want to publish the Folder wont be visible, it means we cant Publish it right. Could any one tell me what's the Issue/Problem Behind this. Thanks
-
Hi , I'm Facing the same Issue with the PPTX Export which has no Borders for the Textfields , but I can see the Borders when i export it to PDF and Excel. No one replied to my Question , I have browsed but didn't fin the Relevant answer Hope this Link will help you in other Issues. http://jasperreports.sourceforge.net/config.reference.html Regards, Santosh
