[Sequence number in iReport]

Thank you. I am able to fix with the suggestions provided

[Sequence number in iReport]

My doubt is whether is it possible to generate sequence number in iReport?

[Sequence number in iReport]

I want to display same sequence number for a group as shown in below example. Please help with SQL query

 

Ex: I have data as below in the table.

 

Facility   Store    Stop  

620592     S0722     1     

620578     S0308     2     

620578     S0631     3    

620590     S0678     4     

620590     S0444     5     

620590     S0237     6  

 

I need Sequence number for these record as

 

Facility Stop Sequence  

620592   1    1   

620578   2    2  

620578   3    2          

620590   4    3      

620590   5    3   

620590   6    3

 

The sequence number is same for a group of Facility and ordered by minimum of stop.

Is it possible to generate sequence number as shown above in iReport designer? 

[SQL : Same serial number for a Group and should increment with group change]

Is it possible to generate sequence as mentioned above in through iReport designer? If so, can you please suggest how to do it..

[SQL : Same serial number for a Group and should increment with group change]

I want to display same sequence number for a group as shown in below example. Please help with SQL query

 

Ex: I have data as below in the table.

 

Facility   Store    Stop  

620592     S0722     1     

620578     S0308     2     

620578     S0631     3    

620590     S0678     4     

620590     S0444     5     

620590     S0237     6  

 

I need Sequence number for these record as

 

Facility Stop Sequence  

620592   1    1   

620578   2    2  

620578   3    2          

620590   4    3      

620590   5    3   

620590   6    3

 

Here Sequence should be based on group by Facility and order by Stop. Please help in creating sql query for this.

[SUM two different fields]

I have two variable 

$V{SUM_ITEMS_SHIPPED} and $V{SUBREP_COUNT}

I want sum of these two variables using Groovy. For this, I dragged a new text field to summary band and in the "Text Field Expression" i have given as 

$V{SUM_ITEMS_SHIPPED} +$V{SUBREP_COUNT}

But the result of this concatenation of these two values and not the sum.

For ex: $V{SUM_ITEMS_SHIPPED} = 1

             $V{SUBREP_COUNT} = 0

output is "10" and not "1"

Please help me how to do this.

What "Text Field Expression" is needed to sum these two variables together ?

[Null check]

Hi,

I am trying to pass the count of records from sub report to main report using REPORT_COUNT. If the count is null or blank from subreport i want to pass 0 from subreport. I did this as below

$V{REPORT_COUNT}== null or $V{REPORT_COUNT}== " " ? 0 : $V{REPORT_COUNT}

But still am getting the value as null instead of 0 when there are no records in subreport.  Please help. It is very urgent.

[Report_locale]

Hi,

I was loading the existing jasper files in iReport where i found static text fields like below

Bundle.getMessage("Name_", $P{REPORT_LOCALE}, "Languages" )

Bundle.getMessage("Cust_Ord_Nbr", $P{REPORT_LOCALE}, "Languages" )

But the report shows actual value of static text like Name, Customer Order Number after execution.

Do we configure values for these fields somewhere ? I mean like Name_ = Name, Cust_Ord_Nbr = Customer Order Number etc

 

[Blurry image in iReport 4.7.1]

Thank you. Will try this option

[iReport - Print when expression to control page layout]

My requirement is to print a message in the page footer for one scenario and barcode for another scenario. Lets say i need to print return message for regular orders in page footer and barcode for emergency orders.

I need to use the same template for both cases. But show different page footer for each case. 

I checked "Print when Expression" property, but that does work at field level and not at the layout level.

Need help on how to acheive this.

[Blurry image in iReport 4.7.1]

Hi,

I have an image with some text in it which is of 358 x 222 pixels. When i use this image in iReport 4.7.1 and export in docx, image looks blurry and text is not clearly visible

Is there a way that i can make the image sharp.

Please help as it is very urgent. Thank you

[How to call a stored proc with more than one OUT parameters in iReport]

Hi,

How can we pass more than 1 OUT parameter in stored procedure and call it in iReport.

Lets say, I have a variable and ref cursor to be passed as OUT parameters. Will it work? If yes, how can we call that in IReport?

Can someone give sample code of stored proc with a variable and ref cursor as OUT

[Page break is not working]

Hi,

My requirement is to show only 5 rows per page in detail band. I tried to use page break, by dragging it to detail band and set the "Print When Expression" as $V{PAGE_COUNT}==5. But I still see more than 5 rows per page. Am I missing something? Please help

[How to deploy reports developed in iReport to Prod Servers]

Are there any scenarios where we don't require JasperReports Server? Can you please share few?

 

[How to deploy reports developed in iReport to Prod Servers]

Hi,

I am new to iReport development. I would like to know what steps should be followed to deploy reportdeveloped in iReport to production servers. Should we install JasperReports Server in the prod servers to run the report or can we execute the reports without that? 

If we need JasperReports Server, which version should we install for iReport 4.7.1?

What are the steps which we should take care while deploying?

 

[Which version of jasper server should be used for iReport 4.7.1]

Hi,

I am new to iReport develpment and would like to know which version of JasperServer be used to deploy reports developed in iReport 4.7.1?

 

[Restrict text size in iReport]

Is there a way to do it in ireport designer instead of java code as we are here not doing build in Java and am not much comfortable in Java development

[Barcode generation in iReport 4.7.1]

Hi,

I want to generate barcode in ireport 4.7.1. Please let me know how to create it, what are different properties i should set. 

Do we need some jar files? if yes, where can we  download those ?

Thank you

[Restrict text size in iReport]

Hi,

I need to print a message in report which should be of maximum 125 characters. Which property should i set for the same? Please help.. Urgent

Thanks