Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 31, 2015 at 01:20 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • The challenge is that you have to combine the queries in such a way that you have the cost as well as the price in the same query.  I'm not sure that it will be a simple task to do this and you would be better off getting the person who sent you the queries to do the combination for you.

      -Dell

  • avatar image
    Former Member
    Nov 18, 2015 at 10:49 PM

    Hello Dell

    hope things are well for the Holidays. I took your advise and tried to track down the person who created these querys. Of course they no longer work for the company, so I am back to square one. These queries I sent you I feel as though should not be hard to put together by someone who has more experience in Crystal Reports. I tried putting a piece together myself the problem I seem to be experiencing to me is that there are soo many pieces of selections on the back side when I start a new report, I tried placing them together, with no success so far. How about you? How did you get really good at doing reports? I have a book at home on how to do Crystal Reports for Dummies. I even paid for two classes at New Horizons, but still pretty lost to understanding how this all works.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ted,

      great advise and helpful information about the book. "SQL Queries for Mere Mortals". I just purchased my book from Barnes and Nobles. Should be arriving this Friday Nov 27! Of course I have to hit the hardest part of getting Data from Crystal for a beginner. I would like to ask you something else. On my computer desk top I noticed an application called Teradata SQL assistant. Do you know what that is used for?