[Declare a name of an object in ireport]

Hello,

 

How can I declare/create a name of an object in ireport 5.6.0?

 

I am a beginner please help.

 

Thanks.

[Getting a data from 2 different data sources]

I have a stock card report then I have 2 different data sources: mysql and mssql. I will get the stock item on the mysql and the number of stocks in the mssql. My question is, Is this possible using ireport and jasperserver? 

[CREATE IF STATEMENT FOR 2 SQL SELECT QUERIES IN IREPORT]

Hello I am new in this,

I have a 2 sql select statement.

this is the first sql statement:

SELECT

     service_card.`no` AS service_card_no,

     customer.`customer_name` AS customer_customer_name,

     serial_numbers.`no` AS serial_numbers_no,

     items.`item_description` AS items_item_description,

     defect.`description` AS defect_description,

     service_card.`date_received` AS service_card_date_received,

     user.`first_name` AS user_first_name,

     user.`middle_name` AS user_middle_name,

     user.`last_name` AS user_last_name,

     service_card.`complaints` AS service_card_complaints,

     service_card.`store_name` AS service_card_store_name,

     service_card.`receipt_no` AS service_card_receipt_no,

     service_card.`date_purchased` AS service_card_date_purchased

FROM

     IF(service_card.customer)

     `customer` customer INNER JOIN `service_card` service_card ON customer.`id` = service_card.`customer_id`

     INNER JOIN `serial_numbers` serial_numbers ON service_card.`serial_no_id` = serial_numbers.`id`

     INNER JOIN `defect` defect ON service_card.`received_by` = defect.`id`

     INNER JOIN `user` user ON service_card.`received_by` = user.`id`

     INNER JOIN `items` items ON serial_numbers.`item_id` = items.`id`

WHERE

    service_card.id = $P{service_card_no}

 and service_card.`approved_by` IS NOT null

 

the second statement is this:

 

SELECT 

service_card.no as service_card_no,

service_card.customer_name as customer_customer_name,

items.item_description as items_item_description,

items.id AS serial_numbers_no,

service_card.complaints AS defect_description,

service_card.date_received as service_card_date_received,

user.first_name AS user_first_name,

user.middle_name AS user_middle_name,

user.last_name AS user_last_name,

service_card.complaints as service_card_complaints,

service_card.store_name as service_card_store_name,

service_card.receipt_no as service_card_receipt_no,

IFNULL(service_card.date_purchased,'') as service_card_date_purchased

FROM

service_card 

join `user` user on user.id = service_card.received_by

JOIN `items` items on service_card.item_id = items.id

where service_card.id=31

 

my question is how can I do the IF else statement inside the sql qeury of the ireport

 

any answers will be appreciated. thank you.

 

Eleazar Embuscado

 

[Problem in Viewing PDF and view in print setup pdf]

thank you sir.

[Installing the Jasperserver in ubuntu without privillege gives me internal server error?]

I am installing the jasperserver 6.2.0 without priviledge in ubuntu 14.04. Then when  I am deploying all of the report in the folder, I am experiencing internal server error in the control and resource tab. what is the worng in my installation?

by the way I am base the installation guide in this link 
 

 

http://techiearea.com/install-jasperserver-6-2-0-on-ubuntu-14-04-lts/

thanks for help

[Problem in Viewing PDF and view in print setup pdf]

In Viewing PDF, It look like this.

 

When I viewing it in the Print SetUp view it look likew this 

 

How can I fix this? Help me please. The size of the paper is A6

[getting the data from the specific jasperserver report using yii]

We have a report that are on the jasperserver. Now, we want to get the data from the report server to the main server. My question is, Is there a chance to get the data from the jasperserver to the php? We are using Web Application. 

[Adjust margin on detail band]

GUys only the the details band at the middle that I want to have no margins. thanks

[Adjust margin on detail band]

Hello fellow Jasper Users,

 

I have a problem in my report.

I want to adjust the margin of each row under the detail band Please refer to th picture below.

 

Can you help me please? This is urgent thanks.

 

[Problem in entering date range in url]

I just did that but not working. thank you for answering 

[Problem in entering date range in url]

Hello,

 

I have a problem in date range. When I typing the exact date referenced from the database the data are showned (first picture). But when I am typing a date in url that will show all of the data, It become empty.

(second picture) I am a beginner using Jasper Ireport and Jasper server. How can I make a scripts for a date range for this? thanks for help.