Search results for query: *

My doubt: AvActual - AvAgreed (OR average of actual minus average of agreed) will be constant value. How can you sort on a constant value ? AvActual and AvAgreed values will be calculated after all the records will be printed and therefore sorting is not possible on these values. You may try...

Do you mean to sort your report by the (group footer 2 formula) column ? Have you used the same formula to specify the grouping for group 2. if yes, then you can specify the sort in Grooup Options. ************************* Pradeep Kumar Gupta Data Warehouse Consultant. pradeep.gupta@wipro.com

Hi Dave, Since you are using Sybase, you can write a stored procedure with the required parameter. Inside the stored procedure you can use this parameter in the select SQL. Use the stored procedure as the source of your report. --PKG ************************* Pradeep Kumar Gupta Data...

Hi "slim2" You need a running total field. Do following: 1.Insert>Formula Field Make a formula by the name "rec_count" and in the formula editor choose any number field from the database table. This will be a temporary one and we will change it soon. 2. Insert>Running...

Hi "pinkstar" You can save a copy of that report and use that copy to make new reports instead of using report expert for every new report. This will help to retain the format of the earlier report. --PKG ************************* Pradeep Kumar Gupta Data Warehouse Consultant...

Your example shows that you want to suppress the whole section containing: | 0 | | Bunny | But you said that........... "...I had tried the suppress formula but it seems that t can only suppress...

There may be other methods of achieving your need. But I would be able to tell you only after knowing exactly what you want to do. Can you tell me what all things are there in and between the group headers and footers. Meanwhile do any of the follwing: 1) Use text-fields instead of boxex...

Right click the field that you want to suppress, click format field and there you will find the suppress check box and conditional suppress formula button. By this method you won't be able to suppress the lines, boxes etc. --PKG ************************* Pradeep Kumar Gupta Data Warehouse...

I thought you want to suppress the whole section. But if you don't want that then write the suppress formulae for the individual items that you want to suppress. --PKG ************************* Pradeep Kumar Gupta Data Warehouse Consultant. E-Mails: pradeep.k.gupta@indiainfo.com...

Don't do guess work!! Try it and see the results. You will write a suppress formula that will conditionally suppress the sections. --PKG ************************* Pradeep Kumar Gupta Data Warehouse Consultant. E-Mails: pradeep.k.gupta@indiainfo.com pradeep.gupta@morganstanley.com

OK then modify the formula like this: 1) Go to select expert and write a formula that excludes all records having {REPORTDATA.READING} = 0. 2)In the group (header & footer) write a suppress formula liek : {REPORTDATA.READING} = 0 Is that right now ?? --PKG ************************* Pradeep...

Hi &quot;Peisy&quot; Its more clear now. There are two ways doing this : 1) Go to select expert and write a formula that excludes all records having {REPORTDATA.READING} <> &quot;cVisit&quot;. 2)In the group (header & footer) write a suppress formula liek : {REPORTDATA.READING} <>...

Hi &quot;peisy&quot; You said..... &quot;......If the ({REPORTDATA.ITEM}) is not &quot;cVisit&quot;, the ({REPORTDATA.READING}) will be converted to 0 ....&quot; How it will be converted to zero is not clear to me. Also following is also not clear to me: &quot;...Is there any way where i can...

Hi &quot;vtgeek&quot;, Crystal doesn't provide Vertical Allignment. You need to move the text box to adjust the allignment. --PKG ************************* Pradeep Kumar Gupta Data Warehouse Consultant. E-Mails: pradeep.k.gupta@indiainfo.com pradeep.gupta@morganstanley.com

S T R A N G E !! I have not come across any such situation. May be there is some problem in database drivers. Try one more thing, Do a &quot;show sql&quot; and copy the sql from there, Run that SQL in another query tool like SQL plus and see what result it is giving. --PKG...

Are you sure that the field which is showing 1,2,3 is &quot;code&quot;. When you move your mouse over the field it shows the database field name. Make sure that it is nothing but the code. It should show the actual values. 01245, 01465, 02546. -- PKG ************************* Pradeep Kumar...

Hi &quot;tsusnik&quot; Try doing a verify database command. Database Menu > Verify Database -PKG