on 08-10-2012 8:27 AM
Dear Experts,
I have imported a crystal report as Layout for AR Invoice and Set it as default report. When I take print preview of AR Invoice (Crystal Report Layout), it opens but it starts asking for parameter i.e. AR Invoice number. In fact it shoud not be asking for Parameter AR Invoice should with asking for Parameter.
Is there any specific setting we need to make ?
Help required please,
Thanks & Regards,
Hi Shazad,
Make a parameter with the name DocKey@
and set the Record Selection formula {Command.DocEntry} = {?DocKey@}
Feel free for any help..
Regards,
Rafaee M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Rafaee, it worked in AR invoice, but tried to apply the same in Journal Voucher prinout i.e. using {?DocKey@} parameter in crystal report and import it as Layout in SBO. When I take the preview it started asking for parameter, whereas in AR it worked fine.
Can you please help !
Thanks & Regards,
Hi
If your thread is closed then close the thread with correct or helpful answers.
Cheers!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Shehzad
Make a parameter with the name DocKey@
In record selection type this formula
{?DocKey@} = OINV.DocEntry
Regards
AAMIR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shazad,
I believe it is due to the data source not properly updated.
Open the layout in crystal designer-under database menu-set datasource location,
make sure you do update all the tables or stored procedures including sub reports.
Then try reimporting the crystal layout,it should not prompt to enter the dockey.
Hope its helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I have the same problem on the object service call. I tried to define parameters and set the Record Selection formula {Command.CallId} = {?pCallId@}, but it doesn't work.
It doesn't work neither when I use it directly on the table OSCL like {OSCL.CallId} = {?pCallId@}.
I tried to export a system Crystal Reports from Sales module to see how does it work, but it still doesn't work, the prompt asks me to give a value to my parameters each times.
Did you find a solution ?
Thanks
Charly Lesgourgues
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naga,
Thanks for your answer. But my problem is not an error message like said in the SAP note 1555170.
My problem is when I run a personnalized CR Layout using File > Preview Layouts on a service call object, the system asks me to enter my parameter (the callId of my service call) whereas I would want my layout to be generated on the current service call without the step of entering a parameter.
Thanks for your time.
Charly
Hi Shazad,
Didi you creat the new parameter for this or just rename it ?? Make a new parameter and make sure there is no other parameter in SQL Command for transid or number
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create the Parameter
DocKey@=DocEntry
ObjectId@=Object type
Thanks,
Nithi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a connection in CR using OLEDB, this will not prompt user id and password.
Else check the authorization.
Pls try.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply,
No I am just asking about the parameter of Invoice number, system ask me invoice number. I used to run this rpt file as report in SBO. Then after that I tried to use it as layout, I import the file as Layout in SBO. When I made this newly uploaded rpt file as default layout in AR invoice. It opens the report from AR invoice form but started showing parameter (for invoice number) and asking invoice number to show the report.
Regards,
HI Shazad Nazir
SAP Business One channel partners, superusers, and authorized regular users can work with the Report and Layout Manager window to do the following:
Regards,
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.