Abhijit Kamatkar writes:
> I have been working on Jasper Reports. I have created few reports using
> ireport and I was able to export these reports within java. Of course these
> reports were simple. Now I want to get deeper in Jasper reports. I want to
> know how one can execute jasper report in
"John Dunn" writes:
> Thanks, but my problem relates to a date used in the SQL in my report
> query
Ah, other direction - sorry.
> I have tried using a value that is a java.util.date in my SQL query.
> Here is the relevant bit of my SL query :
>
> AND submitted_date >= $P!{PARAM_TO_DATE}
>
> pa
"John Dunn" writes:
> Where?...I can't see anywhere to change it
You can change the display format of a date field as one of the
properties of that field in the report, or by manually formatting the
field when constructing a string field.
For simple date/time fields, use the Pattern propert
kulbir writes:
> I have writen a function . When i run that function in orcale backend , its
> giving proper values from data base. But when i run that function from
> ireport , ireprot does gives any values .A blank page sis displayed
First, are you sure that you have selected the right data
Peter Jin writes:
> Let's take a look at activity1 and activity2. If activity1 has more records
> than activity2, some of the records of activity2 will be joined multiple
> times. This is incorrect. Does it make sense?
Drat, yes, dumb error (and obviously too quick 'n dirty test data) on
my part
Peter Jin writes:
> We have an audit system which uses separate tables with similar structure to
> store different kinds of activities for a user. We want to report the number
> of activities per activity type per user.
Still sounds pretty standard in terms of database schema. Can I
assume that
Peter Jin writes:
> Grouping can not solve my issue because it works on one data source only. In
> my case, data for a user scattered in 5 tables. UNION might be a way to
> combine all tables to a data source, but I can not use it either (explained
> in the first post). any thoughts?
It's still