Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to generate a report such that selection of the report will be any two months(Dynamic) and what the report should generate is the details of the employees who are available in the minimum month selection but not available in the maximum month selection.
Regards,
Kavya
In your load script
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
LOAD *, Num(Month(Date#(Month,'MMM'))) as MonthNum
INLINE [
Month, empname
Jan, a
Jan, b
Jan, c
Feb, a
Feb, b
Mar, a
Mar, b
Mar, d
];
Then in the frontend, e.g. in a text box:
=Concat(
{<empname = p({<MonthNum = {$(=Min(MonthNum))} >}) * e({<MonthNum = {$(=Max(MonthNum))} >}) >} empname)
Maybe like
=Concat(
{<EmployeeName = p({<MonthNum = {$(=Min(MonthNum))} >}) * e({<MonthNum = {$(=Max(MonthNum))} >}) >} EmployeeName)
Post some sample data if you need more specific help with the set expression.
Hi kavyasri,
You Can you Start Date and End Date Function in Expression Set or by Set analysis you can easily got data from two dates
post your app with sample data....that will help us to provide the solution
Hi,
LOAD * INLINE [
Month, empname
Jan, a
Jan, b
Jan, c
Feb, a
Feb, b
Mar, a
Mar, b
Mar, d
];
if i click on Jan and March (any month)i should get empname 'c', i.e details of the employees who are available in the minimum month selection but not available in the maximum month selection.
In your load script
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
LOAD *, Num(Month(Date#(Month,'MMM'))) as MonthNum
INLINE [
Month, empname
Jan, a
Jan, b
Jan, c
Feb, a
Feb, b
Mar, a
Mar, b
Mar, d
];
Then in the frontend, e.g. in a text box:
=Concat(
{<empname = p({<MonthNum = {$(=Min(MonthNum))} >}) * e({<MonthNum = {$(=Max(MonthNum))} >}) >} empname)
Thank you