[Unable to login in mobile demo site of jaspersoft <EOM>]

Unable to login mobile demo site of jaspersoft

[How to Graph bar char with decimal´s?]

Hi,

I am not sure but you can check y axis scale property, where you can set scale of Y axis at lower level so that you can see difference between bars.

Let me know if need help.

 

Thanks,

Ajinkya 

[Horizental scrolling in Jasper server 6.0]

Hi ,

Can you provide any screenshot which may give more clearification and if problem is that you can not able to see crosstab properly on report then you may increase report width at maximum so that crosstab able to see properly on horizontal report as well.

Please mention exact issue.

Thanks,

Ajinkya

[If we want to generate report using JasperReport do we need to use both iReport & JasperReport Server or any one ?]

Hi,

you can create report with iReport and deploy on jasperserver or you can directely create report on jasperserver through domain.

1. Static reports based on iReport

2. Adhoc reports based on Domain

These two main way of report generation and another way is to create OLAP based report through jasper analysis workbench.

Based on your reporting requirtement you can choose any one of them.

Thanks,

Ajinkya

[Construct drill down report under Jasper?]

Hi Emily,

You can do drill down in jaspersoft using hyperlink but hyperlink work with jasperserver based reports which you can publish through iReport or jasper studio. You can pass parameters to another report or same report through theough hyperlink and then pass these parameters to your input controls and then it works as drill down report.

Thanks,

Ajinkya

[Dynamically showing columns]

Hi Sanjay,

I think this can be achievable using crosstab and filter, You can add filter for required columns for which you may use union query.

Thanks,

Ajinkya

 

[Show input control by role]

Let me know if you find any solution or workaround for this.

Thanks,

Ajinkya

[Multiple options for date input controls: 1. Default 2. User defined]

Hi,

This can be possible with optional prompt.

For example if my database is oracle then i create my optional propmt(input controls) like if i provide startdate and enddate then it takes these value to the where conditiion, if user not provide values, that is startdate enddate null then my where condition is like Startdate=(next_day(sysdate,'SUN')-7) and Enddate=(next_day(sysdate,'SUN')). similarly use date function of respective database to findout sunday dates. 

You can manage these two where condition based upon starttdate and enddate input control null or not null. Use P!{} parameter for optional where condition.

Hope this may help.

Thanks,

Ajinkya

 

[jasperserver multi select query default value]

Hi,

You can add preselected condition direct in query.

like where col1=Naveen OR col1=sharad OR col1=$P{Multiselect_Parameter}

this might one way to select predefined solution.

Thanks

Ajinkya

[How to subtract two values fetched from table of same colomn ?]

Hi,

This type of requrement i think should be handle at etl side where we can use previous and current record easily or you may need to use stored procedure for that.

Thanks,

Ajinkya

 

[Multi Select Query - Select Options Disappear]

Hi

If you found this is an product related issue then raised it on tracker as bug. Assign bug to someone based on priority.

Some one help you to solve your product related issue in tracker.

Regards,

Ajinkya

[How to print a teble component on a single page having 31 rows ?]

Hi,

I don't understand your requirement but i think you might want the functionality of group band where no of rows separated by group of data.

Can you please elaborate your requirement.

Thanks,

Ajinkya

[send a parameter to a sub-dataset]

Hi,

Create parameters which holds multiple values like parameter with datatyoe java.util.collection or java.util.list and asssign the value of parameters as field.

So that you will get all the values of field to parameter and map this parameter with your other dataset parameter.

Hope this helps.

Thanks,

Ajinkya

[Problem with parameter type of date in conditional query]

Hi,

 Try to use an EmptyDataSource...from that it looks may be issue in datasource.

Just open query designer and and try to fetch sample rows (read fields) if your query is ok then it shows sample rows in query designer.

Try this out may you find something over there.

Thanks

Ajinkya 

 

[Simple SQL Query Yet JRS Fails Validation]

Hi,

Try Startdate with alias a.startdate that may be the issue.

Thanks,

Ajinkya

[How can we pass multiple values in a single parameter in iReport ?]

Hi,

Use java.util.collection as datatype for parameter and use it with $X{In, column name, parameter name} in your sql query.

So that you can able to provide multiple values to parameter in iReport. Provide (,) comma separated multiple values to input control.

Hope this helps.

Thanks

Ajinkya

[send a parameter to a sub-dataset]

Hi,

You can pass the value by using parameter of main dataset to subdataset parameter.

Open the properties of table where you have to select datasource for table on same window you can provide the main parameter value to subdataset parameter.

Hope this helps.

Thanks

Ajinkya

[Problem with parameter type of date in conditional query]

Hi,

Report not opened means is it give any error or blank report displayed.

Run the same query on your database. May your condition not having data.

Thanks,

Ajinkya

[dashboard hyperlinking to detailed reports in same dashboard not working in firefox ?]

Hi,

Check with IE and firefox properties to run scripts on browser. That may be an issue.

I am not sure about this but may helps you.

Thanks

Ajinkya

[how to pass values of resulted by query of main report to subreport parameter?]

Hi,

Use parameter mapping in subreport properties where you can mapp your subreport parameter with main report parameter.

 

Thanks

Ajinkya

[How to print a teble component on a single page having 31 rows ?]

Hi,

You can increase the page height according to number of rows.

OR

you can also set pagination property true so that all records display on single page of report whether rows 1000 or 31 it display in one page.

OR

you have requirement like 31 records per page.

Thanks

Ajinkya 

[Select query input control not selecting all records.]

Hi,

Check with query in your oracle DB.

Also check if any default value set in parameter becouse if query return more than one row then it should display same records in your single select input control.

Let me know if any additiional thing you made in your secnario.

 

Thanks,

Ajinkya

 

[How can profile attributes be used in derived table]

Hi,

I am not sure about this but try to crete domain based report from ireport and use parameter in your query for profile attribute.

Thanks

Ajinkya

[Getting problem while print the Jasper iReport]

Hi,

If you are creating report without query means with static data then you can use band like header, footer or detail to display static data.

may this helps you.

Thanks

Ajinkya

[How to read data from a flat file to produce a new file?]

Hi,

You can use jasper ETL to make new file format from older one not sure about the iReport tool becouse it is client tool.

Thanks

Ajinkya