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 Mike Lewis 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: *

  1. abhi900

    copy values from 1 sheet to another

    On sheet 1 I have 4 cols and the 5th col contains 2 values ("Name of the resource" and "TBC"). So what I want is > I need these 4 cols(from sheet1) to be replicated in sheet 2 BUT only based on "TBC". Hence if out of 50 rows in sheet 1 If I have 10 TBC, then in SHEET 2 I want to see just these...
  2. abhi900

    financial year...

    hi, I have the following logic that needs to be implemented at universe level the filter for timesheet data should be based on timesheetperiod_full.enddate so IF timesheetperiod_full.enddate >30/6/2012(begning of financial year) THEN (if day of week > wednesday then...
  3. abhi900

    Conditions for each chart...

    Hi, I wanted to know how can I apply conditions for each of the 4 graphs individually. I have 4 graphs and they are based on individual field value. Each graphs needs to display for a particular area. Graph 1 = CX, Graph 2 = DE etc... How do I acheive this ? I presume I will need to lay down...
  4. abhi900

    Display MTH.YTD and FY values at same grp level..

    Thanks for all your help mate. All working perfectly... Probably I will have few queries with respect to Graphs but will post it here and wait for it to get commented on. Thanks again.
  5. abhi900

    Display MTH.YTD and FY values at same grp level..

    yes you are correct in terms of using only Summaries and that does work for my FY values. But I cannot do a summary on MTH values as for some reason it gives me only MAX value in the field across each Group and SUM or AVG actually sums everything and likewise for Average. So you think I can get...
  6. abhi900

    Display MTH.YTD and FY values at same grp level..

    Hi Ian I get what you mean but then how do I resolve this ? I do want to view MTH YTD and FY values side by side and in Groups than viewing it in DETAIL section. Thus how can I satisfy those individual conditions for @MTH @YTD and @FY formulas and then make it work? advise please...
  7. abhi900

    Display MTH.YTD and FY values at same grp level..

    HI, I can say that Basically if I just have KPI ID as GH1 and when I insert @Period = "MTH" it returns FALSE but for "YTD" its TRUE. Why would it return me FALSE, where the only condition I have for Record Selection is {KPI.Calendar Month (YYYYMM)} = "201303". I want to run the report on a...
  8. abhi900

    Display MTH.YTD and FY values at same grp level..

    Hi Ian, Irrespective of the brackets or use of just KPI ID and not NAMES and vice versa I cannot see the values against MTH. If i place the same @formula Field in Details then YES I can see the values. But thats not the place I want. I tried using Case Statement too but of little help. When I...
  9. abhi900

    Display MTH.YTD and FY values at same grp level..

    hi Ian, if Period is <> MTH then its null for sure and likewise for KPIName as in the groups I have specified list of values to be choosen and discarded all other values. So my data is restricted to what I have selected in the groups. If there are no values against anyone of them for FY / YTD...
  10. abhi900

    Display MTH.YTD and FY values at same grp level..

    I am using BO XI R3 SP5, Crystal Reports 2008.
  11. abhi900

    Display MTH.YTD and FY values at same grp level..

    Hi, I have 2 groups :- GH1 - KPI ID (using only selected KPI ID) & GH2 - KPI Name (Only those names that are assigned to KPI ID) Need to display MTH / YTD and FY Actual/Target values for each KPI ID based on KPI NAME(GH2) on same line. eg:- KPI NAME MTH_Actual MTH_Target YTD_Actual...
  12. abhi900

    missing field names when inserted as a subreport

    thanks for that advise. I took that approach as well as moving my headers to Report Headers and that did work nicely...! cheers AB
  13. abhi900

    missing field names when inserted as a subreport

    hahahha..what? what does that mean? So when you import import as a subreport then does it NOT import the PH ?? but then how do i get the OLE image used in the PH for the subreport in the main report. and what about linking the formatedate fields with the main report ?
  14. abhi900

    missing field names when inserted as a subreport

    Hi, A bit unusual over here.. HAve 4 sub reports to be inserted into the main report 3 /4 reports have a common formula {@formuladate}. So when inserting subreport I do link them against this formula field. However when inserted I can see that Field names in PageHeader goes missing. But its...
  15. abhi900

    Customize Sort Order for Pie Chart

    I have usually typed in the values in the Specified field irrespective of the value showing in the drop down list or not. Try that if you want in OTHERS tab - either u can discard or leave it in a group or leave in its own group. However 60 is a big list. The reason they are missing from the...
  16. abhi900

    Divide the same group in 2 sections along with header...

    Hey guys, thanks for viewing, I eventually got this to resolve. The only way I could do it was apply individual condition on each fields used in the report (suppressing / display) and then couple of conditional statements in section expert area. So it do3s work seamlessly. thanks.
  17. abhi900

    Divide the same group in 2 sections along with header...

    Hi, 1.I have field 'Name' that I want to list but issue lies is WHEN I try to segregate the 'NAME' to 2 sections. So the first section of 'Name' work absolutely fine but the next section of 'Name' does not come up as I want to (picture inserted to get better understanding). I did try to insert...
  18. abhi900

    Hide columns in a crosstab but not that straight fwd...

    yes you are correct in a way but... values are still there.. and I used this formula under col where I want to supress for YTD and likewise for FY too :- IN SUPRESS condition :- (CurrentColumnIndex=1) OR (CurrentColumnIndex=3) So your above advise wont have any affect on this. Cause ultimately...
  19. abhi900

    Hide columns in a crosstab but not that straight fwd...

    No worries mate...!! You did help me a lot. and I guess its a bit tough to get that feature as its not incorporatable in crystal. Also issues with other fields to be displayed alongside with Periodicity. So not worth spending sooo much time when its nto gonna happen and you do have another...
  20. abhi900

    Hide columns in a crosstab but not that straight fwd...

    Hi, This cross tab never worked the way I wanted it. It still leaves a lot of dead space between the col and there is no way you can minimize the dead cols. So Stuck to normal design layout and calculating fields manually than using the crosstab. So yea.. thanks to all and I still did learn...

Part and Inventory Search

Back
Top