ely78144

Hello, How can I declare/create a name of an object in ireport 5.6.0? I am a beginner please help. Thanks.

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?

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_purchasedFROM 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_purchasedFROMservice_card join `user` user on user.id = service_card.received_byJOIN `items` items on service_card.item_id = items.idwhere 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

thank you sir.

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

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

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.

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

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.

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

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.