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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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 ?
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...
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...
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.
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.