Recent content by mcrisf

no problem....i found out the solution!

Hi, a new problem with subreport I have a main report, where the user can select the SALESREPs.In the main report there is a Parameter Field that link to a Table-field "SALESREP", and i added the "*ALL" to let the user to select all the salesrep without picking every salesrep. The problem is...

thx for the answer ..i have crystal rep X and SQL server 2000. I made my view and i linked it in crystal. I will try with Left outer join...

I have a Cross tab with Product (1 level) and Models (2level) in Columns and Sales Reps in Rows.Amount Sales as Measures For all the SalesReps i dont have Amounts for some Models (ex.MOD3)...I would like to have anyway a place holder for these Models, eventually to show 0 as Amount. Any idea...

Thanks a lot..it works!!!!!!!!!!!!!!!!

Hi, my problem is... i have a group "sales rep" and i want to show each element of the group in separate page.So i added in section expert/ new page after/x+2 the formula: if {?PageBreak}="Y" then true else false the problem is...if i have Grand Totals....then they go in a new page....i...

thx a lot...now it works

i created the same parameters in the subreport, but i cannot link these parameters to the main report's parameters...i dont see the subreport's parameters in the linking screen....

I have only one group..I orderde it by ID and then by MTD, i used the grouonumber function....but it gave me wrong numbers...for example i have only 2 records and the formula (where is the groupnumber) gives me 95 and 105..!!!!!

i tried it...but i think it doesn't work....do u have some code to post?

yes, but i would like to show the rank to the user...

Is it possible in CrystalRep 10 to rank a group (example i have salesreps and their sales amount ..i want to rank the salesreps depending on their MTD sales and rank on their YTD sales)...? thx

this is the record selection in subreport: month({vDW_KPI_SALES_INSTANT_OBJ.OBJDATE})<=int({?Pm-@MonthToNumber}) and year({vDW_KPI_SALES_INSTANT_OBJ.OBJDATE})=int(tonumber({?Pm-?Year})) and {vDW_KPI_SALES_INSTANT_OBJ.SALESREP_ID}={?Pm-?SalesRep}

the problem is (i think) related to this if I leave in the selection record (in the subreport) the links to the parameters of the main report, then i get 0 for the shared var.

hi, thx for the answer ..but it doesn't work.... I placed the shared var in the main report in the report footer and in the subreport in the report header....but i get always 0....