bplummer

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

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(); }); });

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

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!

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!

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

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

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

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.

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.

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!

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

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

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

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...