Search results for query: *

HI Thanks for both you answers. The last Form line is something that is added extra in SQL plus. The line is already in the beginning so that's why the; seems to be missing. This is one problem. But I also have another appliction which doesn't add this line and the question doesn't work there...

Hi I have created a question in Access and then copied the SQL question from it. When I try to run it in eg SQL plus I get an error.From the error I understand that there must be one more Select statement but I can't figure out where. SQL> SELECT MC_POSUM.ID, MC_POLINE.ID,MC_INVTRANS.TQTY_AMT...

Hi I did something similar some time ago. I wanted to suppress a group if the value was 0. I put a Supress if on the group and then added a formula. Sum ({MEWTACTGVALUES1.TOTLABTIME_AMT}, WORKORDERTYPE1.ID}) <= 0.00 You might be able to ues any of it. // Christina

Hi Thanks for the help I tried the second solution but I get the same message. The first doesn't work I tried that before. What I want do is to show maintent_1.id that has a melink.dtend_date that is equal to xxxxxx. The melink.dtend_date can be of various dates but I want to show the...

Hi Can anyone help me with what is wrong with my formula. It is not creted as a SQL formula, just Crystal formula. select {MAINTENT_1.ID} where {MELINK.DTEND_DATE} = Date (3000, 12, 31); The date format may look funny but this is taken straight from the DB so the error is probably that some...

Thanks for your replies. Even if I rename the subreport to a mainreport I still have the problem of getting a second page with the same information.

Hi I tried the tip to add a subreport in a new section in order to print out a copy of it. The advise was fine but it doesn't work. The subreport I want to print out is a copy of the main report + one line. The main report contains a lot of other subreports and therefore also my new subreport...