Cannot View the Data when using the Print Preview of the Not-Save Sales Quotation

[Former Member]

Hi Everyone,

Good day!

Can you help me to solve my issue on unable to view the data in the Sales Quotation document when  I tried to print preview the document?

I tried to create a Sales Quotation document but haven't saved it yet. I fill out all the items that I need and specified all the information for the said document but upon trying to print preview the document, no data has been displayed on the form. I really don't understand why it happens. But when I save the document then try to print preview, the data will now appear.

The form is a crystal report and SAP Business version is 8.80 PL 20.

Please see the attached screen shot for your reference.

Please advise me of the things that I must check to solve this issue.

I will greatly appreciate your response on this matter.

Thank you very much.

Warm regards,

Anthony

[former_member196081]

is this standard layout or created by you?

[Former Member]

Hi Deepak,

Good day!

Actually my colleague created this report. And upon executing print preview no data were displayed on the form but when you added/posted it, the data will now reflect.

Warm regards,

Anthony

[former_member196081]

Hi

give me your mail id and I will send you some standard layouts. import the same for quotation document only and try. I did check at my system and its working fine for me without added the document.

[Former Member]

Привет Дипак,

Спасибо. Отправьте, пожалуйста, на этот адрес электронной почты: <personal email removed by moderator>

Теплые пожелания,

Энтони

[former_member196081]

check ur mail.

Import the same through report and layout manager in administration

[former_member196081]

as below

[Former Member]

Hi Deepak,

Thank you for sending the report. I'll check it first then try to print preview. I'll update you once on the result.

Thank you very much.

Warm regards,

Anthony

[Former Member]

Hi Deepak,

Good day!

I have tried the template that you gave and it runs fine. But the template that I have still does not show any data.

What are the things or setup that I need to check on the crystal report layout that I have? It seems that I missed something or I have an incorrect setup.

Thank you very much.

Warm regards,

Anthony

[former_member196081]

ask your colleague to edit the standard layout as per your requirement.  he is missing something  either at parameter declaration or with connection. reason could be anything.

[Former Member]

Hi Deepak,

Thanks but may I know the things that you configure or setup on your crystal report template or layout. Maybe I just missed something that I can apply or have to check as well just by myself.

Thank you very much.

Warm regards,

Anthony

[julie_jamieson2]

Hi Anthony,

The system layouts use a stored procedure to allow this. The system saves the document as a draft when you choose to preview & the stored procedure works out that it needs to look at the draft table.

There is some documentation on the portal that shows how to create crystal layouts, but I have found it easier to take the system ones and modify them, that way you don't miss any functionality.

If you get the report designer to look at the database expert in the system layouts, they may be able to work out what is needed.

[Former Member]

Hi Julie,

Good day!

I have checked the form's layout and it gets the data using the DocKey. I think this is the reason why no data have been shown or displayed since the document is draft. Am I correct?

What are the other things that I can do aside from creating new form's layout for me to fix this one?

Thank you very much.

Warm regards,

Anthony M.

[julie_jamieson2]

Hi Anthony,

You need to join the Stored Procedure as in the system layout  add the @dockey and @objecteid parameters in the hidden report header, as in the system layout

[Former Member]

Hi Julie,

Good day!

How will I do that? Can you give some steps for me? or maybe just tutorial links with your suggestion. Actually i'm not expert in crystal report that's why I don't understand some of its behavior.

Thank you very much.

Warm regards,

Anthony

[julie_jamieson2]

Hi Anthony,

If you are not familiar with Crystal, it is probably best not to try to develop an invoice report from scratch as there are a lot of legal requirements and some tricky SQL to manage.

There are a number of resources available via google that might help - try these:

https://www.youtube.com/watch?v=CJw_vtuv7Dy

SAP also have a document on working with Crystal Reports available on the portal

[Former Member]

Hi Anthony,

If your crystal report is query based, then you wont get the data if you havent added the documents. You can get these if you use tables in your crystal report and not sql command.

Thanks,

Joseph

[kothandaraman_nagarajan]

Hi,

This is current limitation of crystal report. Tested in 8.82 version, behaviour is same as above.

Refer SAP note:

2055214 - Limitations of Crystal Reports for SAP Business One

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan,

But upon trying it on the other marketing documents such as Delivery, A/R Invoice and etc all the data that I specified/key-in on the document appear once I print preview it. I just experiencing it in Sales Quotation.

Thank you very much.

Warm regards,

Anthony

[former_member188586]

hi

can you Post design mode to understand and explain to you

Thanks&regards

Andakondaramudu