AThompson_1

Hello, I would like to have a public (JRXML. Not view-based) report use the datasource defined in the organization of the user running the report. Basically, Org_1 points to a different source database then org_2. How can this be accomplished? Thanks, Andrew

Hello, Is there a way to see or capture the SQL query once the paramaters have been substituted in? i.e. Whats actually submitted to the DBMS? Thanks, AT

Hello, I would like the default for "Output to Respository" to be unchecked on the Output Options tab. Is there a way to change this? Thanks, Andrew

Yeah, and it says to create to one of type Date, which doesn't work.

Hello, I need to create an input control such that I can enter a relative date value like DAY-7 (for weekly scheduling). When I create an input control with data type DATE and enter a relative value, I get an error "Specify a valid value for data type Date". I don't see DateRange data type as an option when creating the control. How can I achive this? Thanks!

Group 1 header = left-most column (Transaction Inf0) Group 2 Header = 2nd column (Tx B) Detail = 3rd column ( Other)

HI All, I need to reproduce the attached report in JS. It's basically 2 groups and one detail section. That's all fine and good. The part I'm having trouble with is getting an object (rectangle) to span multiple report bands. For example, I need a rectangle around the group 1 value in the group 1 header and continue thru the group 2 header and into the detail section, until the group 1 value changes. I really need those report bands to be vertical and not horizontal. Is there any way to accomplish this? TIA, Andy

Hi, I'm experiencing a strange error. Strange because it works just fine in JS Studio but throws in error when executed on the JS Report Server. My stored procedure call is: exec dbo.sp_name @v_P1=$P{p1}, @v_P2=$P{p2}, @v_P3=$P{p3} ,@v_P4=$P!{p4}, @v_P5=$P!{p5} The fourth and fifth paramaters are optional and defaulted in the stored procedure definition. They happen to be muti-select values (java.util.Collection). If I supply at least one value for each when run on the JS Server, it works fine. But, leaving these unassigned in Studio works fine but throws this error from the server: "An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name" My studio and the Server are using the same jdbc driver. (This is against MS Sql Server). Why is this behaving differently? TIA, Andrew

Hi, I'm not finding the doumentation on Domain Expression Language very helpful. I'm trying to calculat the the percentage of 2 intergers. int1 % int2 results in a blank result with no error message. I'm thinking it's a data type issue but don't see any functions to convert. Any ideas? TIA, Andrew

Hello, Is it possible to update the hostname in the JDBC string of a saved datasource? Our DWH has a failover node. But it does not failover sessions and has a different IP. Given I have the IP, can I update the datasource definition directly in the Postgres repository? Or some config file in the web app? Essentially, pointing to the new active node WITHOUT going thru the UI. If possible, would the app have to be restarted? Or, would it just use the new connection string on the next access of that datasource? TIA, Andrew

Hello, I have a "main" report with a couple of linked subreports which are charts. When I run the subreport, standalone, the hyperlink to another report works just fine. But when the chart is a subreport of another report, there is no hyperlinking (nothing happens). Is this expected behavior? Or, am I doing something wrong(most likely)? TIA Andrew

I found the problem. User error. Didn't actually hit the "add column" link.

Hi, Using ReportServer 6.2 CE. When I publish a report from Studio and create a single-select query input control, it runs but the the values to select are invisible. You can tell there are rows there and if I select on a blank spot, the report works. Yes, I supplied a column in the query to be displayed. Any ideas? Thank You

Relative

Hello All I have 2 linked rpeorts (charts). Each run fine individually as an Administrator. But when drilling to the second report from the parent report the exception: org.springframework.security.access.AccessDeniedException: Access is denied is thrown. Any ideas? I'm using Jasper Report Server Communitiy Edition 6.1.1 Thanks, Andy