[accessing param data in call to Visualize.js]

Ugh - sorry for the bad code formatting.  Thanks for any help!

[accessing param data in call to Visualize.js]

 Visualize question that should be obvious (but obviously not to me …)

Doing a demo.  I want to flip between params to show different data.  Is there a way to read the param that was passed in, in javascript, so I can do a conditional?  This is what I have – want to make the button toggle between “test” and “Evan Hospital”:

    vConfig = {
        auth: {
            name: "superuser",
            password: "superuser"
        }
    };

    visualize.config(vConfig);

    //container1 with param
    visualize(function (v) {
        var report = v.report({
            resource: "/organizations/organization_1/Reports/Total_Savings_Report",
            container: "#container1",
            params: { "CustomerName": ["test1"] },
            error: handleError
        });

        $("#button").click(function () {
            report.params({ "CustomerName": ["test2"] }).run();
        });
    });

[Can't create SQL Server JNDI data source in jasperserver 6.0.1]

Thank you both for your suggestions. I changed the driverClassName to tibcosoftware.jdbc.sqlserver.SQLServerDriver and it connects.

[Error configuring a new datasource to SQLserver 2008 R2 with a named instance in Jasperserver]

Have you tried this:

jdbc:sqlserver://SQL01PROVSQL01;databaseName=Navision

When you use a named instance, don't include the port.  You will have to make your changes in the URL textbox, and let the Host and Port textboxes fill themselves in.

Just came across this old post, but hope it helps!

[Can't create SQL Server JNDI data source in jasperserver 6.0.1]

When I try to create a JNDI data source to my SQL Server database I get this error:

Invalid JNDI name: jdbc/AbtgSplitter

The details start with:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' for connect URL 'jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitter' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory

The context.xml entry is:

    <Resource name="jdbc/AbtgSplitter" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="sa" password="password"
        driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        url="jdbc:tibcosoftware:sqlserver://10.212.35.229:1433;databaseName=AbtgSplitter"
        factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory"/>

The web.xml entry is:

  <resource-ref>
    <description>340B AbtgSplitter</description>
    <res-ref-name>jdbc/AbtgSplitter</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>

I'm confident about my URL string - it worked in a JDBC connection to the AbtgSplitter database.  Any ideas - what am I missing?

Thanks in advance!

[Access Denied Exception]

Hi

I am trying to open a view in Jaspersoft and I get the following Access Denied error:

The system was unable to complete you request. Your conversation may have been ended, expired or been invalidated.

Please provide the cause and resolution for the issue.

Thanks

[Resized columns do not get exported to excel]

Hi

I have an issue :

When the fields in a view are resized to smaller width and the view is being exported, resized columns do not get exported to excel.

Similarly, when trying to resize column and exporting to pdf, the columns data do not show up.

Any idea how to fix this? Any help?

Thanks

[How to change the timeout message?]

Jaspersoft shows a timeout message "Click OK to keep your session alive, otherwise it will expire at 9:01. The issue is the time shown in the message is an hour prior to the current system time. So when this message was displayed the currente system time was 10:01.'

Is there a way to set the time or change the timeout message?

Any help will be highly appreciated!

Thanks

[Import Web Service Status message]

REST V2 Import Web Service API is called using the URL http://localhost:8080/jasperserver-pro/rest_v2/import?update=true.The response message is read as InProgress. How to confirm if the status is { phase: "ready", message: "Ready!" }

 

If the Import Status is queried through GET, only Finished.

This is not the same as what provided in Web Service guide.

[leave app server running while doing a command line import]

Thanks for the info. Our customers can only access JRS through a browser from our application, and the user they are logged in as doesn't have the permissions to perform an import from the browser. Good to know it's primarily a lock/load issue - we will just restrict usage during an import.

[leave app server running while doing a command line import]

Hi all,

I will have to administer remote installations of JRS, and will push new reports using a ftp'd executable that, when run on our customer's server, will call the js-import.bat and import a zip.  My question - do I really need to stop the Tomcat server before I do the import?  Stopping a service from a script can be flaky - want to avoid it if possible.

Thanks!

[Using Domains in Studio]

Hi Ilona,

 

Thanks for your reply. I'm not sure what you mean by virtual data source. From my report, it allows me to choose an existing domain as a data source, and it sees the fields in the domain, but it won't pull back any on the data. I have verified that the data adapter is seeing the database correctly.

 

Betty

 

[Using Domains in Studio]

Hi,

I had created a domain in JRS, and I want to access it for a report built in Studio.  I create a data adapter that points to the same data source as the domain, then create the report.  In the report's Properties, I click the Edit query, filter and sort options button, and select domain in the dropdown.  My Domain's fields populate the left panel, and I drag selected fields to Fields in the right panel.  Then click Get Fields, and the bottom panel is populated.  But when I go to the Data Preview tab, there is no data.  Also when I drag the fields onto the report form and click the Preview tab, the message is "Document is Empty".

Is this a know issue with Domains in Studio?

Thanks - Betty

[Issues in connecting Jaspersoft Studio to JasperReports Server]

I was finally able to connect to the JRS repository from Studio by changing preferences in Studio -> Window/Preferences, then General/Network Connections, for the Active Provider dropdown I selected Manual.  I restarted the app and the Repository showed up.

HTH - betty

 

[Issues in connecting Jaspersoft Studio to JasperReports Server]

I also am getting this same exception when I try to connect Studio to the JRS on the same server. I don't have a proxy. Any other ideas?

 

-bplummer

 

ps - apologies for the vote down - not paying attention to random clicking...

[substituting tables/columns in the domain]

Hi,

I'm new to Jaspersoft so sorry if this has an obvious answer!

I have a domain with associated adhoc views and reports.  It has been determined that in all my reports, the data from table1.column19 really needs to be coming from table1.column20 instead.  Can I make this change in the domain, so that I don't need to redo all my views and reports?

Thanks,

bplummer