Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

I cannot get this Script to Work Please help

Hi everyone, I am brand new to Crystal reports which I am not sure how to make this script work. I was given this text file script to enter in the Add command for Crystal reports.: The benefit plan summary. Which I want to combine this other Script that would give me the at cost for my Frames which is the second file. Calle Frame Usage and Cost and Sales Price. How do I combine the pair?

replied

Aurthur, 

You can only have one command ( or stored procedure ) per crystal report. 

so you then have a couple of options.  

You could rewrite the command into a single command.  ( How to do that is a different forum and I'm assuming that writing SQL code is beyond your current abilities )    or have whoever gave you the code do it.

....or  you could make the plan summary command drive the main report and than build a subreport using the frame useage command  and then you would need to add the subreport to the main report and link them based on a common field  (  Like Plan number ???   - I don't have the time to dive deeply into the code someone gave you.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question