Print screen was a feature of OpenERP which enables the user to take the printout of the tree view of the selected records. This feature was available in OpenERP 6.1 GTK client was not available in OpenERP 6.1 web client and OpenERP 7. In OpenERP 7, there is an option to take printout of the tree view. But in OpenERP 7 we cannot select the particular records which we want to print in the report.
OpenERP 7.0, The full featured ERP making the switch from an ERP to a suite of integrated business applications. So far, the world was split between ERPs and best of breed applications. With 7.0, OpenERP combines the key benefits of stand-alone apps (ease of use, quick to deploy, highly customizable, ...) with the integrations and feature coverage only ERPs used to provide to their customers.
This in an interesting module in OpenERP which I found useful recently for importing different csv file templates to a single object(model) in OpenERP. For example when we create a crone job (scheduler) to import csv files from different suppliers with their invoices which has different structure to the Customer Invoices in OpenERP. Below is a generic explanation of the existing module.
iReport is an reporting tool used for designing jasper report in OpenERP. In OpenERP it is difficult to create a report that has a dynamic column. For instance consider an example of a project report that has details regarding the project task completion date. The task name will be the name of the column. In such cases, the cross tab in report comes handy.
Jasper report is an reporting tool used in OpenERP for printing the reports in formats like pdf, Excel, HTML etc. Lets consider an example about the accounting reports. The report contain details regarding the credit amount, debit amount balance etc. It would be very useful if the report is printed in excel format. In excel sheet we will be able to specify the formula based on which each cell value is calculated. So if we are generating the excel sheet from jasper report we should be able to specify the formule in jasper report which should be used in the excel sheet.
Hello sir,
I am presently working with excel based reports in ireport,
you have aware of excel insert comments property in ms-excel ,which will provides information to particular cell,
so my question is is any option is available in jasper soft ireport or any other solution is there to get dynamic data in each excel cell ?
Hi,
I didn't get your question exactly. But there are ways in ireport itself to get dynamic data in excel cell. Please give somemore details so that it would be helpful to me to solve your query correctly.
hi sir...
i want to store my jrxml and .jasper files in my running application rather than saving it in other folders.i came to know that we can create a package and store only .jasper files and we can run the application but i am getting file not found exception.
do we have to change it here also?
<defaultValueExpression><![CDATA["C://JasperReports//"]]></defaultValueExpression>
please tell me the way to store these files in my application itself.initially i stored these in c://jasperreports//
what is the way and what are the changes to be made in jrxmls or the code?
please help it is important and urgent and i dont have any idea about it ..
thanks in advance...
Hi,
I didn't get your requirement exactly. Are you trying to develop a module with jasper report?
hi sir...
i want to store my jrxml and .jasper files in my running application rather than saving it in other folders.i came to know that we can create a package and store only .jasper files and we can run the application but i am getting file not found exception.
do we have to change it here also?
please tell me the way to store these files in my application itself.initially i stored these in c://jasperreports//
what is the way and what are the changes to be made in jrxmls or the code?
please help it is important and urgent and i dont have any idea about it ..
thanks in advance...
could you send me links to download Jasper report 4.5.1, iReport 4.5.1 please ?
Hi,
You can download the iReport 4.5.1 from here . There is no need to download jasper_report4.5.1.jar file. You can find it inside iReport4.5.1 itself.
If you are using OpenERP jasper_reports module, to update jasperreports-4.5.1.jar and other lib files to latest for iReport_4.5.1,
This will update all the libraries in jasper_reports module to the latest.
Can I use any other formula? e.g. =BDP(AB21,"PX_CLOSE")
I met my success in porting the Drupal 6 module, OpenERP Proxy API to Drupal 7 (D7). Now it is working with OpenERP 5 and OpenERP 6. I faced many complications to make the data communication between Drupal and OpenERP. Even though we can have specific methods to tranfer projects, leads anything like these from OpenERP or from Drupal and make both to communicate each other, I wished if I had a specific API module in Drupal 6 my task will be easier. Later, I found this module will do the nice. Thanks to BoogieBug who developped the Drupal6 version
Hi.
Is it possible to share your D7 version of the OpenERP Proxi API?
I´m trying to install the API module in D6 with OpenERP 6.0 and I get a lot of errors...
Thanks.
MMoura
Hey
I'm interested in using the OpenERP Proxy API in a project of mine and i want to know if its possible to use Drupal7 as an OpenERP client instead of the default web client
Thanks
Hi all recently I was assigned the task of restricting multiple logins of a single user in OpenERP. Since I'm a newbie to OpenERP, I searched the web for some kick-start articles but for vain. That is why I'm summarizing my points in this, my first ever, blog.
Thank you very much, it's very good for me
well written Vinod. A good feature indeed..
Hi vinod
i read ur blog u have explained beautyfully........
i have followed steps exactly what u have explained
but i am not able achive the expected result
can u help me out plz
In today's aggressive business environment it is essential to be prepared to face a vast and competitive world. Like any other industry manufacturing companies also are facing so much competition. To withstand the competition, organization must have a proper system and software that supports whole system with integrity. Enterprise Resource Planning is one of the ways to improve and streamline the system.
appreciate the writing..
do you have any more details about a comparison of OpenERP with others?
Runny, i have gone through a paper which has a made pretty good effort in comparing open source ERPs. Eventhough, the papaer work is an old one, it worths a read.. http://www.big.tuwien.ac.at/system/theses/20/papers.pdf?1298476232 Here Open ERP is termed as Tiny ERP, which was the old name of the same. The product has been improved so far within these years. The paper will guide you in evaluating an ERP.
The Openoffice Report Designer is a plugin used to create reports for OpenERP. It is an easy to install and use plugin. The main advantage of this plugin is that anyone can easily create and modify reports for OpenERP.
Installation Procedure
Install using Extension Manager in Openoffice.org Writer
Hi
I have a problem about editing OpenERP report in OpenOffice:
Window add a field is empty.
Hi,
I have 2 problem about editing OpenERP report in OpenOffice:
1) i can't Add a loop - after i select Objects to loop on, i can click Ok button but nothing happen (the dialog box still open and not closed after click Ok button)
2) i can't Add a field - no Variable appear in drop down list.
Hope u can help me about this matter. TQ
Hi Nizam,
Well i'm having a bad time because of the same problem as yours.
Did you figure out how to solve this problem?
Contacted openErp for this, they don't seem to care :(
Please advise.
Thanks
Anthony
Hi
Have you tried to switch over to Fields.
Button: Conversion Brackets -> Fields in Openoffice
Hi Prajul T. Thanks for your
Hi Prajul T.
Thanks for your help.
I am working with ireport and crosstab and right now i have a issue with a final report.
I need see in each column, the months of year but in order, for example: january, february, march, and so on, but I can to display that columns but in disorder.
The query was written in postgres:
with client as
(
select codclient, sum(total) as totalc
from v_sales
group by codcliente
order by totalc desc
)
select
vc.*,
cp.name as periodname,
date_part('year',cp.enddate) as anio,
date_part('month',cp.enddate) as numeromes,
date_part('month',cp.enddate) || '-' || initcap(fnc_period(cp.startdate, 1000000) ) as namecomplet ,
cp.periodno,
tc.totalc,
cp.enddate
from v_sales vc
inner join c_period cp
on vc.c_period_id = cp.c_period_id
inner join client tc
on tc.codcliente = vc.codcliente
order by namecomplet asc, anio asc;
Thanks a lot...!
Omar
I have created a crosstab, if
I have created a crosstab, if placed in Summary section it works fine, but if in any other section means it is not giving any errors but it is not shown.
I think if we give increment type as Report it should work but it is not. Kindly help.
Hi , In my report i am
Hi ,
In my report i am getting null value for one column even though data is there .Can any one help me and thanx in advance
Hi, Can you please tell me
Hi,
Can you please tell me that how can we add a Serial Number in cross tab.
hi sir,i have a problem when
hi sir,i have a problem when i keep all my subreports one by one in detail band all the reports are overlapping..if i keep them in summary then i have to set it like giving gaps between subreports...so if there will be more data for first subreport then it overlaps with second sub report how to remove it?
and in crosstab if complete row or column is null that is no value i want it to show 0(zero) but it doesnot give that row or column at all...what to do?
thanks...plz reply
Hi, For your first
Hi,
For your first query, ie; the overlapping of subreports , first select the subreport from main report go to properties, there you can see a field "Position Type". Set it to "Float" so that the subreport will not overlap.
For Your second query, if the data in a crosstab is null it will be shown as null in the report. Please check weather you are retriving the data correctly. For example:
In the above report the the column group is the partner name and the measure is the phone. if there is no phone number for a partner, it will be shown as null.
Please check you are retriving the data correctly.
Hope this helps...
Hi sir ,thanks for the reply
Hi sir ,thanks for the reply first answer which you gave has worked...my second doubt was if we have a task1 in row andtask1...n in column and if its having no value then i should get null/0 but that column is not visible at all what to do...for betteer understanding of my doubt i am trying to show it as table
task1 task2 task3 task4 task5 task6 total
task1 5(somevalue) 6 7 0 0 10 x value
task2 0 0 0 0 0 0 x value
task3 0 0 0 0 0 0 x value
task4 1 2 4 0 0 6 x value
task5 1 2 3 0 0 7 x value
task6 1 1 1 0 0 8 x value
total x x x x x x x value
if this is a cross tab,as u can see that columns task4 and task5 and rows task2 and task3 are having null values so in ireports its completely deleting or not showing that but i want it to display as i shown in the example not considering whether row/column is null...please help waiting for reply...thanks in advance...
hope you will understand the
hope you will understand the above given example..as its not that clearly visible..but please clear my doubt..sorry for any kind of trouble in clarity..
Hi, Please send me your
Hi,
Please send me your data retrieving details like whether you are using a JDBC connection or XML etc. It would be better if i could have a look at your .jrxml file.
HI, I am Working With
HI,
I am Working With iReport(jasper reports) and OpenERP 6.1.
I downloaded the integration addon of jasper_reports from community.
I am facing some problems while integrating it.
Can U Upload a blog for this?
Regards,
Murali