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

[@farleyasouza1792]

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]

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]

​@@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!

[@kirksmithson]

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]

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

[@ashutoshshandilya3321]

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.

[@rajeshkhater2462]

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

[@BattleshipCobraSAP]

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.

[@noorulqamar]

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]

@@BattleshipCobraSAP Thanks

[@shannnonANDtori1357]

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]

Thank you so very much! It worked

[@tomborton1398]

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

[@germanmesa8532]

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]

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).

[@mimima4577]

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 KZbin can help?

[@mimima4577]

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

[@AM-sj7pl]

what is the version of crystal report

[@BattleshipCobraSAP]

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.