Search results for query: *

Guys need help to calculate the following Need to calculate b4 and after, below shows the data example The idea is to find the total of stock (Which I can calculate) and then use this value at the earliest transaction hence the last transaction in this case, and add qty to the total per...

That's correct Ibass, I have changed it to the following now and it seems to be working, not sure why the orginal did not work whileprintingrecords; numbervar a; if {@ccrsgrp} = 1 and a =1 then "Taught course part time" else if {@ccrsgrp} = 1 and a =2 then "Revision" else...

yes it is thanks

error, says the remaining text does not appear to be part of the formula. it actually works when i run it on crystal on it own, but when i deploy the report in our ERP apps then i get the error i calculate a distinct sum to get this value {@ccrsgrp} and if it meets the criteria i am...

CR 8.5 Hi Can any body tell me if there is anything wrong with this syntax whileprintingrecords; numbervar a; if {@ccrsgrp} = 1 then select a case 1 : "Taught course part time" case 2 : "Revision" case 4 : "Revision" case 20 : "Distance...

Any idea Ibass boss

i have a main report where i get a list of customers with some data, i have also written a another report which uses pivot tables to get similar information. i have inserted the second report as sub report ( In group footer ) so that it can be used as a drilldown. My problem is that when i...

Sorry Ian, may be i am not doing this right, but unless i summarise on paper i cant get to this position, the data you see below is what i get after summering by cust/paper/type, if i summarise on cust/type only then i cant work out what combination of type a student had for a paper, which is...

So Ian are you saying I don't need the grouping on paper then

HI Ian, i wonder if you can suggest what i need to do here, i have done the following on what you have suggested and am very close to the result but not there yet. i Havee grouped the data as below G1 Cust G2 Paper G3 Type i acuumulate the data using this formula and then dispaly this on 2...

Thanks Ian and Ibass for all the help, I think this one is too complicated for me to do ( not one to give up too quickly but have spent too long on it), I may get the data exported to excel and write a macro to do it thanks guys

Ok Ian would you able to just explain how i would go about doing this in version 8.5 in little bit of details since i have never done this before sorry for asking so many question, i really appreciate the help you guys are giving me thanks

Thanks Ibass, for this i will need to create Views in Oracle DB and I am trying to avoid this, there are restriction to what we can do on the DB.

Hi Ibass You did response to my post on a another account ( thank you for that) but unfortunately for some reason i could not access my account and had to create a new account. Ian has suggested an idea which i am going to attempt but seems there will be lot formulas for this. the...

Ok Ian seems it will have to be formulas then, :( only other issue is when i have to check for the below it needs to establish if they have a combination of these types any ideas, thank you again for the help Taught course and revision FEEDER or BESPOKETAU) and (WEREV or QBREV or STDREV)

HI Ian, Thank you very much for the quick response i will give this a try, only issue is i have 14 papers and many more method of study with a huge permutation of type. does this mean i will have to write formula's to include all possibility's thanks

I did try to write a report which had multiple sub-reports for each method of study, but this makes the report to slow. is it possible to use the whileprintingrecords statement to some how accumulate the paper and type to do some grouping on this on the same report. Ibass my man where are you...

Information Method of study ( needs to be calculated) Type ( data form system) Taught course part time FEEDER or INTENSIVE or BESPOKETAU or BESPOKEIN Revision WEREV or QBREV or STDREV Taught course and revision (FEEDER or BESPOKETAU) and (WEREV or QBREV or STDREV) Distance learning and...