Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mcrisf
  • Content: Threads
  • Order by date
  1. mcrisf

    Subreport linking problem

    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...
  2. mcrisf

    PlaceHolder in a Cross Tab

    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...
  3. mcrisf

    Grand totals and Conditionally Page Break

    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...
  4. mcrisf

    Ranking

    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
  5. mcrisf

    Again Shared Variables

    Hi, i am having this problem with shared variables: 1.Main report in the report footer GrandTotal of MTD Sales (i need to pass this to subreport) 2.subreport in the repor theader Sum(MTDGoals) (if i put this in other section of the report header i get 0) Main report (define the shared var)...
  6. mcrisf

    Suppress just only one column in a CrossTab

    Does someone know how to suppress just only one column in a CrossTab (depending on a condition)? I have this CrossTab (products on column, models on columns, salesrep on row) Prod1 Prod2 Mod1 Mod2 Mod3 Mod4 salesrep1 10 12 4 5 salesrep2 7 4...
  7. mcrisf

    Record Selection

    Someone can tall me why my selection formula does not work?(it means the dealer ID filter works, but the discount filter doesnt work, i got always all discounts, even i select the filter "59") {vDW_KPI_SALES_MASTER.SHIPPED_DATE}>={?Start Date} and {vDW_KPI_SALES_MASTER.SHIPPED_DATE}<={?End...
  8. mcrisf

    sum of sum

    Does someone know if it is possible to do : sum(sum(amount, salesrep), product) or sum(max(goals, salesrep), product)? I tried but CR says that is not possible to summarize ....even i use whileprintingrecords.... thx
  9. mcrisf

    shared variable

    How to pass parameter fields from Main report to the subreport?I tried with shared variables, but it does not work.... Main report Formula: @shMonth shared numvervar shMonth; shMonth={?Month}; subreport: Formula @shMonth shared numvervar shMonth;
  10. mcrisf

    Cross Tab- Totals

    How can i use in a formula the total of a crosstab? Crystal doesnt show me those in the report fields.I need to subtract 2 different totals. thx
  11. mcrisf

    Crystal Report SUM OF SUM?

    Hi all my problem with Crystal ReportX: I do NOT want to use a CrossTab, because i have too many measures to include (MTD, YTD, % etc) and i need to have the difference beetween the grand totals (the crosstab doesnt let me to do that). So i created 2 groups Products (1st group) and Sales Rep(2nd...

Part and Inventory Search

Back
Top