Jump to content
Changes to the Jaspersoft community edition download ×

Rashmi Nagaraja

Members
  • Posts

    16
  • 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 Rashmi Nagaraja

  1. I have 100,000 account numbers. I want to randomly give any 5 (as per my requirement. Could be 1 or 2 or 20) account numbers and see the information about them. I have tried the following. I tried with string input control, cascading input control with one string and one list parameters. But none of them works. 1) String Input Control: I tried entering the 3 random account numbers comma separated. But my query dosent accept the same since I have to use a list parameter and $X variable. ($X{IN,acct_no,test}). 2) Cascading Input Control: I thought let me take a string input control and a list list input control and use the string input control within the list input control. So I tried like the following. Created a parameter and an input control with string datatype (where I can enter comma separated account numbers). The parameter name is $P{account_no}Created a list parameter and an input control with list datatype as an multiselect query using the string parameter as below. The parameter name is $P{test}select account_no from customers where account_no IN ($P{account_no}) Note that I have used the first parameter. This works fine for only 1 account number and not for 'n' account numbers.I also tried something like select account_no from customers where ($X{IN,acct_no,account_no}) . For obvious reasons this does not work.I am using Jasper 5.0.1 Is there a way to dynamically populate a list based on the input values. Could anyone kindly let me know how to achieve my desired output? Any help would be appreciated. Many Thanks.
  2. Thanks Ajinkya. But user will not have access to ireport. This is report creation from adhoc view. I have uploaded a jrxml file as a topic from which the users will create a view and a report from the same. As an alternative, I have increased the size of the topic. But this doesn't serve the purpose. I would require more realistic approach like the documentation have said. But I do not know where to set the size to actual size in adhoc editor.
  3. Hi, I would want to set the page size to actual size in the adhoc editor. I am facing the similar problem faced by the below user (refer question No 3). http://community.jaspersoft.com/questions/531242/questions-about-ad-hoc-reports I am unable to see the screenshot in the above link. Also, In JasperReports-Server-User-Guide.pdf, to overcome this, they have said the following To prevent horizontal truncation of an Ad Hoc report when exported, set the Actual Size option in the Ad Hoc Editor. Also, I looked around in Manage Settings as well but was unable to find the place to set the page size. Could someone kindly let me know where to set the page size to actual size so that when I preview the view, I can see all my fields on the pdf so that there is no horizontal truncation of the fields? I have created the view from a topic. Any help would be really appreciated!!
  4. I wanted to create role based jasper server home pages. I followed the instructions specified and created the same so that when the specified user logs into the system, he would see his home page which would be the dashboard itself. But when I logged in with the created user, I see the home page which is the specified dashboard but only half of it.i.e, the dashboard has 4 charts, but only the first 2 are displayed. While creating this dashboard, I had set the guide to 1280*1024. Is there something else that needs to be done so that the entire dashboard is seen as the home page?[Now only half is being displayed] I am using JasperReports Server 5.0 Any help would be appreciated!
  5. Hi, I am using jaspersever 5.0 I would want to customize and rebrand the jasper UI. I refered to the below document (White paper for jasperserver 2.0) http://www.jaspersoft.com/download/customizing-and-rebranding-jaspersoft-user-interface. Since I am using jasper 5.0, the instructions given dosent match up with the actuals. I just want to change the logo, title and color of the UI. Is there a document I can refer to fior jasperserver 5.0 and do the required changes. Any help would be highly appreciated. Many Thanks!
  6. I want to save the dashboard in pdf or print the same. Is there a way to do it since I cannot find any keys to save the dashboard? Each component of the dashboard can be openend in new window and then the options appears to save in the required format. But is there a way to save/print the dashboard? I am using jasper 5.0. Any help would be appreciated. Many Thanks!
  7. Thanks Sanda for all your inputs. It really helped me . I forgot to mention Bar Chart 3D. I have now changed it into 2D Bar Chart and it works perfectly. I will surely paste the sample for future references. Thanks again.
  8. This works like a charm for Line Charts. Thanks a ton.I had a query for Bar Charts. Show labels works for bar Chart. But the value of the shortest bar doesn't get displayed. I reduced the font size to the possible level('6' to be precise) where users can view the values, but the shortest bar doesn't show the value since it is very small in size. Is there something I need to do so that value is displayed for the shortest bar?
  9. Thanks Ajinkya. Yes, I unchecked and checked again to get the 'Show Labels' property to get the values and it did work. For the shortest bar, the value doesn't get displayed. I reduced the font size to the possible level('6' to be precise) where users can view the values, but the shortest bar doesn't show the value since it is very small in size. Is there something I need to do so that value is displayed for the shortest bar?
  10. I am facing problems with Bar chart of Ireport. In Pie Charts, for legend and legend labels I use 0,1,2 and display values along with their percentages. I want to do a similar thing for Bar Charts. I want to display the value for each bar along its category as below. http://i.stack.imgur.com/ey4CP.jpg Across forums, suggestions have been placed to use customizer class. Is there a simpler way to do what I require? If I need to use customizer class, is there a sample available? I am using the latest I report and jasper server 5.0 Any help would be highly appreciated. Thanks
  11. Apparently, one cannot do it. So created 2 tables with their respective datasources and combined them to achieve the result.
  12. I have 2 datasources A and B. I have 2 datasets 'a' and 'b' respectively from them. I need to use datasets 'a' and 'b' and generate a report from them. [i.e, Create a table and use the fields from both dataset 'a' and dataset 'b'] I cannot use a subreport or a jar. Is there a way in Ireport to acheive my requirement? I am using Ireport 4.7. Thanks for the help!
  13. Hi, I have a table which looks like the following ID Name Year Jan Feb Mar Apr May [These are the column names] 1 abc 2012 2.5 3.2 2.5 2.3 6.2 [These are the values in the rows of my table] 2 abc 2011 3.9 6.2 7.5 6.5 6.8 I am trying to create a line chart where x axis is my column names i.e, Jan, Feb and so on and my Y axis should be its corresponding values. Series expression would be the year. Could some one please help me in creating the category expression and value expression since I am unable to do so? Any help would be appreciated. Thanks in advance.
×
×
  • Create New...