Crystal Reports Stored Procedure (StorProc) Tutorial - SAP Business One: Tips & Tricks

Просмотров 12 тыс.

% 195

🎦 Video Description
Training on writing an SQL Stored Procedure and using it with Crystal Reports, formatting it and deploying it. I go faster than usual but you could take my courses to learn a lot more about these topics.
📚 Chapters
00:00 - Introduction
01:58 - Start of Stored Procedure Tutorial
10:40 - Start of Crystal Reports Tutorial
20:40 - Deploy in SAP
22:49 - Outro
💼 Working Remotely: Efficiently and Effectively Free Course ☕
remote.battleshipcobra.com (Free)
🧮 SQL FOR SAP BUSINESS ONE COURSE NOW AVAILABLE 📈
sql.battleshipcobra.com (50% off)
📊 CRYSTAL REPORTS FOR SAP BUSINESS ONE COURSE 💎
crystal.battleshipcobra.com (50% off)
🎉ADVERTISE IN MY VIDEOS 🎊
advertise.battleshipcobra.com
😎 More About BattleshipCobra
battleshipcobra.com/
💸 Support These Videos
donate.battleshipcobra.com/

Наука

Опубликовано:

21 окт 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@ashutoshshandilya3321 3 года назад

Hello Michael I also tried with same way and it is working fine but when i deploy on pre production environment then it is giving unexpected database connector error. So may because of SCHEMA NAME is changed but my data source name is same.

@farleyasouza1792 10 дней назад

Hello Michael, Tks for excellent video! I tried to execute on Crystal rep, but the my Crystal don't have the option 'store procedure'. This is the my Crystal version or SAP B1 version? (SAP 9.3 yet)

@BattleshipCobraSAP 10 дней назад

Thanks for watching! Try to rebuild your connection and make sure you're using a database user that has access to the objects. Might need some IT help. Good luck!

@farleyasouza1792 9 дней назад

@@BattleshipCobraSAPI use 'sa' user. I'll verify where I was wrong. tks a lot Michael

@valterdebrito3990 Месяц назад

Hello Michael, Excellent video! I saw that with the import it was possible to create the menu, but is there any way through the SAP DI API to call a report?

@BattleshipCobraSAP Месяц назад

Not sure exactly what you mean but Crystal Reports can be imported and run from the menu. Queries Manager in V10 has a new button called "Assign to Menu" to place queries in the menu as well. Let me know if this is what you mean. Thanks for watching!

@shannnonANDtori1357 3 года назад

Hello Michael! I’ve been wondering whether is possible to design and import a fully functional crystal report for BP Summary(Payment Wizard). No matter how i set up the parameters, when i run it in SAP, i have to enter them again, otherwise it won t work like a report. Thanks in advance, man!

@shannnonANDtori1357 3 года назад

Thank you so very much! It worked

@tomborton1398 3 года назад

hmm Crystal Report works for dunning wizard as well? I mean whether you can create a crystal for dunning levels and to actually work. Should i use BP CardCode as a parameter (next to WizardId) so it will generate a dunning letter per BP? The Crystal I created works just fine in Crystal Reports, but stops working in SAP

@kirksmithson 8 месяцев назад

Hello Michael, great video. I have an SP that i create a temp table in, i then do a select into that temp table. I follow that up with two updates to the temp table to fill other columns. Final step in SP is Select column1, column2, column3, column4 from #temptable. When i pull the SP into a blank crystal report it shows the SP in the Database fields in field explorer but the + sign beside the SP does not pop it open, any ideas on what I might be doing wrong?

@BattleshipCobraSAP 8 месяцев назад

When you execute the SP manually do you get results? (HANA or SQL)

@rajeshkhater2462 2 года назад

Hi Michael, How to avoid the Grand Total line coming all alone in the last page?

@BattleshipCobraSAP 2 года назад

Hi Rajesh, you would want to try the "Keep Together" option for the sections you are using in the "Section Expert" area or "Group Expert" if you are using groups. BUT, sometimes the way a report works it just ends up that the total is on the final page. It's just how data works and you should be very direct with your client. If it was one record less it might all fit on one page but it would not be the right data. So people who are used to making Excel documents by hand need to chill out on the "needs to be on one page" thing.

@mimima4577 3 года назад

Question, I have a TCODE F30 in SAP where I need to apply payments. My problem is, I have 10k lines that I need to enter. Instead of entering them manually, is there an easier way to enter 10k lines of payments in one shot? I've been trying to figure this out forever. Like let say 1 account has 50k worth of payments and need to pull just 10k lines, wondering if anyone on RU-vid can help?

@mimima4577 3 года назад

@@BattleshipCobraSAP thanks. I was talking about SAP PR1. Sorry about that. Thanks for the response

@germanmesa8532 4 месяца назад

Hello Michael, thank you for this valuable information, I was watching this video and also another one about the stored procedures that you have published, I want to make a crystal format for invoices but in the stored procedure I cannot write dockey@ only @dockey but sap does not help me. recognizes the @dockey parameter for crystal generation, can you please tell me what I can do?

@BattleshipCobraSAP 4 месяца назад

A good way to check is to edit one of the system Crystal Report layouts from SAP (Sales Order or AR Invoice, etc.). Then copy the exact parameters (make sure you copy the right case).

@AM-sj7pl 2 года назад

what is the version of crystal report

@BattleshipCobraSAP 2 года назад

Hello, could be 2013/2016? It's basically impossible to tell between them. Doesn't matter much either, only based on what version of SAP Business One you are running.

@noorulqamar 3 года назад

Sir, There is some error during executing the below... SELECT 'Invoice' as 'Type' ,T0.[DocNum] ,T0.[DocStatus] , T0.[DocDate] , T0.[DocDueDate] , T0.[CardCode] , T0.[CardName] , T0.[DocTotal] FROM OINV T0 UNION ALL SELECT 'Credit' as 'Type' ,T0.[DocNum] , T0.[DocDate] , T0.[DocStatus] , T0.[DocDueDate] , T0.[CardCode] , T0.[CardName] , T0.[DocTotal] FROM ORIN T0 ERROR= "Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string." Without "UNION ALL" it's working. Kindly suggest !!

@noorulqamar 3 года назад

@@BattleshipCobraSAP Thanks