Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: jwlewis; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. ISEXPORTTYPE("table/excel") will return true or...

    ISEXPORTTYPE("table/excel") will return true or false depending if the output of your report is Excel or not. You can use that to hide or suppress any of the data in your report you do not want to...
  2. Replies
    1
    Views
    841

    ISEXPORTTYPE("table/excel") will tell you if the...

    ISEXPORTTYPE("table/excel") will tell you if the report is being generated for Excel. Put =NOT(ISEXPORTTYPE("table/excel")) in the visible property to exclude any items when generating as Excel.
  3. Replies
    0
    Views
    797

    Crosstab Summary Column Formatting

    I added a summary column to my crosstab report and set the Summary Header to display Total. When I view the report I don't get my text, instead I get the name of the field from the database. Even...
  4. Replies
    11
    Views
    4,290

    I am currently using 3.9 of the report designer...

    I am currently using 3.9 of the report designer and 4.5 of the server and it works fine. In my testing of version 5 I get the same errors you do. I am trying to fix it but no luck yet. For version 5...
  5. Replies
    11
    Views
    4,290

    Check this post:...

    Check this post: http://forums.pentaho.com/showthread.php?136669-Dynamic-Datasource

    I have had some success with it.
  6. I have used Pentaho with SQL Server 2005, 2008...

    I have used Pentaho with SQL Server 2005, 2008 and 2012 with no issues. You just have to make sure you include the database driver in the driver directory for all of the client tools and the server.
  7. Table With Bullet Charts: Setting Chart Colors

    I have a table with bullet charts. Is there a way to change the color of the chart based on whether my measure meets the target value? I would like to make the chart red, yellow, or green depending...
  8. Replies
    2
    Views
    2,444

    Thanks, that helped. The MarketPlace is now...

    Thanks, that helped. The MarketPlace is now installed. I do have a few issues:
    - I tried to update the MarketPlace but even after restarting the server it still says it needs to be updated. I know...
  9. Replies
    2
    Views
    2,444

    Marketplace On Enterprise Edition

    How do I add the MarketPlace to my Enterprise Edition of Pentaho 5?
  10. Thread: Pentaho 5.0

    by jwlewis
    Replies
    1
    Views
    887

    Pentaho 5.0

    Are CTools supported in Pentaho 5.0? If not, when do you expect them to be supported?
  11. Replies
    10
    Views
    5,078

    I have a similar structure in my Pentaho...

    I have a similar structure in my Pentaho environment and I was able to find a solution. I am still testing it but it seems to work for me. It is based on a solution I found with a google search for a...
  12. Replies
    3
    Views
    3,106

    This happened to me and my fix was to make sure...

    This happened to me and my fix was to make sure Use Authentication was checked and have a valid user and password entered in the Authentication User and Authentication Password fields.
  13. Thread: QR Code

    by jwlewis
    Replies
    7
    Views
    3,889

    A Crystal Report is not my target. I need QR...

    A Crystal Report is not my target. I need QR Codes and other 2D barcodes (like PDF-417) for a Pentaho report.
  14. If you can't use a SQL where clause then use the...

    If you can't use a SQL where clause then use the visibility property of the details section. Use a formula like IF([Amount]>100;TRUE();FALSE())
  15. Replies
    3
    Views
    1,494

    I cleared them and nothing has changed. I had the...

    I cleared them and nothing has changed. I had the bar-width set to 1 and with it cleared the barcode is the same size. Also, it will not allow me to enter a value less then 1.

    I am trying to use...
  16. Replies
    3
    Views
    1,494

    Barcode Settings

    Is there a way to control the size of the barcode generated? I am using a Code39 barcode and I am only giving it 7 characters but it is almost as wide as the report I am creating. When I make the...
  17. Replies
    1
    Views
    893

    Create a function called BradsApples. Use an If...

    Create a function called BradsApples. Use an If statement, If name = "Brad" then Apples else 0. Then create a sum function called BradsTotalApples which sums BradsApples. Do the same for each name.
    ...
  18. Replies
    5
    Views
    1,091

    I have a couple of reports with subreports and...

    I have a couple of reports with subreports and have the same issue. Since there are only a few I get around that by defining all of my data connections in the report, one for each of my JNDI...
  19. Replies
    5
    Views
    1,091

    Yes, all of my queries are in the x-action and...

    Yes, all of my queries are in the x-action and the resultsets are passed to the PRPT. That is the only way I could get a dynamic JNDI name to work.
  20. Replies
    5
    Views
    1,091

    I am looking for the same functionality. I am...

    I am looking for the same functionality. I am currently using x-actions to achieve this since they allow a variable to be used for the JNDI name. I would prefer to get rid of my x-actions and use the...
  21. Replies
    3
    Views
    1,559

    I had to edit...

    I had to edit pentaho-solutions\system\marketplace\settings.xml and add the following:

    <marketplace-users>my_user_name</marketplace-users>
    <marketplace-roles>my_role</marketplace-roles>
    ...
  22. Thread: QR Code

    by jwlewis
    Replies
    7
    Views
    3,889

    QR Code

    Is it possible to generate a QR Code for use on a report?
  23. Replies
    3
    Views
    1,559

    MarketPlace Security -- Roles

    When I try to install a plugin with the marketplace I get:

    Unauthorized Access. Your Pentaho roles do not allow you to make changes to plugins.

    What role do I need? Our security configuration...
  24. Replies
    1
    Views
    2,686

    I found a fix for my issue. I upgraded to Report...

    I found a fix for my issue. I upgraded to Report Designer 3.9.0 -- it does a much better job deciding on the values for the y axis and it has a y-auto-range property where the y-min and y-max values...
  25. Replies
    1
    Views
    2,686

    Chart - Dynamic Y-Axis Settings

    I have a report displaying a line chart. When I preview the report the values the report decides on for the y-min, y-max, and y-tick-interval make the chart hard to read and useless to end users. The...
  26. Replies
    4
    Views
    1,268

    Do you have an example of how to do this?

    Do you have an example of how to do this?
  27. Replies
    4
    Views
    1,268

    Access The Logged In User ID

    Is there an easy way to display the logged in user id in a CDE dashboard and use the id as a parameter in a CDA query?
  28. Replies
    0
    Views
    1,252

    CDA Excel Output

    I am using version 11.11.23 of CDA in biserver-ee-3.10.0-GA.

    I am using the Web API to call a query and output an Excel file. This works fine in Firefox but i am getting issues in Internet...
  29. Replies
    4
    Views
    1,622

    I tried upgrading to Internet Explorer 9 but I...

    I tried upgrading to Internet Explorer 9 but I get the same issue.
  30. Replies
    4
    Views
    1,622

    I have been using the ctools-installer. I updated...

    I have been using the ctools-installer. I updated the components yesterday to make sure I wasn't missing any recent fixes.

    When will your change be available?
  31. Replies
    4
    Views
    1,622

    Issues In Internet Explorer 8

    I am trying to run a dashboard I built using CDE in Internet Explorer 8 but the graphs are not displayed and I get javascript errors. The dashboard runs fine in Firefox.

    I then tried the CDE...
  32. Replies
    2
    Views
    976

    Draw A Line In A Bar Chart

    I have a bar chart but I need to draw a couple of lines to mark some thresold values. For example if I have bars ranging from 0 to 100 I would like to draw a line at 50 and 75.

    Thanks
  33. Replies
    1
    Views
    1,287

    Call CDA Query From Excel

    Is it possible to call a CDA query from inside Excel using a URL? I seem to remember seeing an example of this in one of the Community Technical WebEx presentations but I remember how to do it and I...
  34. Replies
    14
    Views
    4,204

    -- using a parameter to set the locale for report...

    -- using a parameter to set the locale for report translations
    -- using a parameter to set the datasource for a report
    -- saving a report to the filesystem
  35. Thread: CDF Updates

    by jwlewis
    Replies
    1
    Views
    880

    CDF Updates

    I was wondering if there are any updates coming soon to CDF? In particular I am looking for some additional charting options. We are just starting to develop dashboards and one of our requirements is...
  36. Thread: CDA Issues

    by jwlewis
    Replies
    7
    Views
    3,628

    I just updated system\olap\datasources.xml in my...

    I just updated system\olap\datasources.xml in my 3.6.0 system to include the connection information for my cube and it is now working. I don't remember seeing this as a requirement anywhere, I...
  37. Thread: CDA Issues

    by jwlewis
    Replies
    7
    Views
    3,628

    I installed the 3.5.2 version and while I get a...

    I installed the 3.5.2 version and while I get a bunch of errors at start-up and while running the CDA file it does work. The exact same file in the 3.6.0 version does nothing.

    I have tried to...
  38. Thread: CDA Issues

    by jwlewis
    Replies
    7
    Views
    3,628

    My connections are correct. I have tried both the...

    My connections are correct. I have tried both the jdbc and jndi mdx connections but neither works. My query is also correct, I used a query that I took from an existing dashboard.

    My cda file is...
  39. Thread: CDA Issues

    by jwlewis
    Replies
    7
    Views
    3,628

    CDA Issues

    I am having some issues with CDA 1.0 in Pentaho 3.6.0 GA EE. After installing CDA when I log into the user console the Pentaho log gets some errors:

    2010-07-30 15:01:10,913 ERROR...
  40. I also have the issue of both columns displaying...

    I also have the issue of both columns displaying the same value instead of the value for each measure. Did you find a solution? Is the issue with the MDX?
  41. Are any of the examples shown in the presentation...

    Are any of the examples shown in the presentation available?
  42. Replies
    0
    Views
    1,048

    Designing Reports For Zebra Printers

    Now that the report designer supports barcodes I was hoping to start using reports for our label printing instead of using a commercial label printing software package. Has anyone designed reports...
  43. Replies
    3
    Views
    1,630

    Issues With Internet Explorer

    I have built a few sample dashboards that all work fine in Firefox but I am having problems when trying to run them in Internet Explorer. None of my openflashchart charts work. I get the following...
  44. Replies
    35
    Views
    16,257

    Has anyone found a fix for this issue? I am...

    Has anyone found a fix for this issue? I am having the same problem. I get the following error in IE only:


    Open Flash Chart

    JSON Parse Error [Syntax Error]
    Error at character 0, line 1:
    ...
  45. Replies
    9
    Views
    6,446

    Here is some additional information: In our...

    Here is some additional information:

    In our situation we have users who need to see reports in multiple languages. We built our reports based on the Pentaho localization documentation. Each report...
  46. Replies
    9
    Views
    6,446

    I fought with this for a long time before finally...

    I fought with this for a long time before finally getting it to work. I pass in the locale (en_US or es_MX) in s_localeCode and then use a javascript action with the following:

    function...
  47. I have tried to implement this example but all I...

    I have tried to implement this example but all I get is an Action Successful message, I can't find where the file was saved and there are no errors in the log. Any suggestions?
  48. I have tried the same report in version...

    I have tried the same report in version 1.7.0.M1.0472 (the latest I have downloaded) and get the same issue.
  49. I have seen the same issue and can't figure out...

    I have seen the same issue and can't figure out how to get around it. I am using version 1.6.0.348.GA
  50. Replies
    1
    Views
    1,340

    Date Parameter In xaction

    Most of my reports use date ranges. How can I had a calendar control to my xaction so users can select a date instead of typing one into a textbox? I have seen a few posts where people mention...
Results 1 to 50 of 80
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.