Koha Report Module - Building Guided Report | The CoProfessionals | Koha Tutorials

[@gurjeetkaur9598]

Very useful video.

[@AKStudio143-m7d]

Hi Sir, Hope you're having a beautiful day. Thanks a lot for sharing this informative video!

[@dreamsofasif2101]

So nice vdo sir, Thank you

[@rajeshemlatagupta2115]

Sandar Sir ji

[@rajeshemlatagupta2115]

Sir ji play List Bana do Koha software ke video ka

[@munwarhussainabro4009]

Dear sir, how to calculate the total fines paid reports in koha 23.05 ?

[@vishalsawakare3089]

Thank you so much Sir.🙏

[@dreamsofasif2101]

Sir, Saved reports are displaying barcode wise arrangement. But sir, if I entered 250th book finally, and after I edit the inner any one eg. 195th book once more edit in some details, then its barcode is same but it is displaying most finally sir. I want to it become again in the correct barcode position. How its possibles sir? Help me

[@TheCoProfessionals]

I am not able to understand your problem. Aap hindi me simplify kar sakte ho.

[@sunitarani-gt8pw]

Hello sir thanks for your video Pls. Tell me about report for total no. Of books of a particular author and total no. Of books on a subject

[@TheCoProfessionals]

The author and subject fields are hyperlinked fields. If you click on them it will result all the records on the same name/heading. If you still need a report, you may check koha wiki report page. There you will definitely find what you are looking for.

[@sunitarani-gt8pw]

@@TheCoProfessionals Thanks sir

[@user-uc6mr9fm7p]

How to create a monthly or daily circulation report? Please make a video🙏

[@TheCoProfessionals]

Here is the video of how to add a customised SQL report kzbin.info/www/bejne/oZy4q2mKp5aeZ6M You will get the SQL code here wiki.koha-community.org/wiki/SQL_Reports_Circulation#List_of_books_issued_in_between_two_date_ranges_and_accession_number_range

[@anoopscaria3684]

Dear sir, can we take patrons batch wise total taken number of books? for example we create a group like ug students..that groups are around 185 members. we want, that all members are how many books taken? can you tell me?

[@TheCoProfessionals]

Apply the following SQL code, it may solve your problem. select count(*) as Total_Checkout, borrowers.cardnumber as Card_Number, concat(borrowers.title,' ',borrowers.firstname,' ',borrowers.surname) as Name, borrowers.categorycode as Category_Code from issues left join borrowers on borrowers.borrowernumber = issues.borrowernumber where borrowers.categorycode='AM' group by issues.borrowernumber

[@sunilbiswal5711]

Can we integrate the koha report with other ERP system? If yes pl. describe how?

[@TheCoProfessionals]

If you are asking ERP as in Electronic resources, then no, we can't. That's a complete different thing. But, if we make an entry of those resources in Koha then we can normal reports as it will consider those as other resources.

[@sunilbiswal5711]

@@TheCoProfessionals I am talking about Enterprises Resources Planning software, where entire institute is connected with a single software, report can be integrated from koha.

[@egranthaliya]

You know I have shifted my library from egranthalaya to koha 24.04 and imported 5000 records successfully into koha but I am unable to find the barcodes of books, please help me and let me know if the barcodes gets generated during import process automatically or I have to assign manually

[@TheCoProfessionals]

Barcode is a mandatory field while importing data. If you haven't mentioned the barcode while importing, then how the system accepted it I doubt. If you have mentioned the barcode while importing, check whether it is reflecting on the staff end in a record or search by the barcode directly. If it is not showing on OPAC, then you just need to check whether the barcode option is unchecked in administration. Go to Koha Administration > Additional Parameters > Table Settings > OPAC and then uncheck the item_barcode option under Table id: holdingst.

[@egranthaliya]

@TheCoProfessionals I have installed koha as a fresh instatnce again please suggest necessary instructions before importing records so that I may not face any issue

[@egranthaliya]

@TheCoProfessionals thanks, these instructions are similar to instructions i was using in earlier software

[@mmalik4078]

I want to se all checkout book list in one report

[@TheCoProfessionals]

You can. You need to create a simple report first. You can hava a look to the Koha wiki reports for that. Copy that sql code and paste it and run the report.

[@mmalik4078]

@@TheCoProfessionals thanks sir

[@jayaseelan6173]

Bro i want take subject wice report can you pl how get pl tel me thx urgent need your help.

[@TheCoProfessionals]

You can check on koha wiki reports. Definitely you will find there.

[@sunitarani-gt8pw]

I am having koha 21.05 version

[@TheCoProfessionals]

Is anything to share regarding that..!

[@rohila1968]

which screen recorder u used dear. highly informative vedieo.

[@TheCoProfessionals]

Simple screen recorder in Ubuntu.

[@sonunagaich8309]

सर जी क्या आपका नम्बर मिल सकता है

[@TheCoProfessionals]

[e-mail] Ap ye email par mail kar sakte hain.