6.Module Task2

Tas2 in 6.module,I have tried to done according to module 6 - episode 4 of your videos,but I couldn't
do it.Please look at the task and say me what is the problem.

Hi Mesut,

The error you're seeing has nothing to do with Task2. This is Task1 that does not pass the check. The Task1 report cannot even be opened now because of the error in your source code. Please, get back to Task1 and fix the issue.

Report settings looks like true , but not.Why?

Attached Files

Download TrueReport.PNG (8.84 KB)

Download MyReport.PNG (8.09 KB)

Hi Mesut,
As I see, your first table is correct but the second is not. You need to show the total of hours for each month also.

I have set total hours for each month.But it is not true.Can you look to this?

You set up the ShiftSchedule periodicity to Monthly. Because of this setting the register requires month to be set when you add a new record. And it's not how you build this report anyway. You shouldn't change any settings of the register.

Please, restore the original register settings and start the report over.

I have set original setting the register but this time Period in table is not shown and gives error.

Attached Files

Download ShiftSchedule.PNG (28.38 KB)

Download Error.PNG (34.74 KB)

Okey I found how can I do.I take month as number but system takes month name and year.How can I do this?

Attached Files

Download MyReportt.PNG (4.11 KB)

Download TrueReportt.PNG (4.83 KB)

Download Month.PNG (6.21 KB)

There are several different ways of achieving the result. One of them would be to use DCS data conversion feature:

Attached Files

Download 2020-10-22_13-47-50.png (451.83 KB)

I have nearly solved.My code shows year with comma.how can I solve this?

Attached Files

Download year.PNG (4.9 KB)

Download year2.PNG (4.91 KB)

I have solved the problem but there is another problem.True code shows 3 column but my code shows more than 3 column.How can I solve this?

Attached Files

Download MyCashiers.PNG (10.31 KB)

Download TrueCashiers.PNG (8.7 KB)

Mesut, you didn't do what I showed you. Let me explain one more time. The Columns setting (see ShiftStart screenshot) tells the report what data you want to group into each column. You set the column to Shift.Start. Each shift starts at a different time. Therefore, only one shift will go into each column. Therefore, you will have as many columns as shifts.

You had to set Columns to the beginning of month (see the BegOfMonth screenshot). This way several shifts will go into the same column because they start in the same month. This will give you the result you need.

Attached Files

Download ShiftStart.png (43.29 KB)

Download BegOfMonth.png (57.67 KB)

I can not enter the 6.Modul.I think , it is open in your computer.Please can you close the system.

Sorry, I forgot to close your infobase after looking at it. It's closed now.

I have already done what you say and because of it doesnt work, I have changed settings.

I have tried it one more time.Date is true but month number is shown.In control report month name is shown.I set format in Dataset section but it is still not true.How can I solve this?

İf it is solved,my exam will be finished.

Attached Files

Download MyTask2.PNG (13.2 KB)

Download TrueTask2.PNG (12.46 KB)

Download MyReport.PNG (53.33 KB)

Download Format.PNG (54.33 KB)

Good day,
for changing month number to month name. My solution is to use CASE WHEN. For example:

CASE
   WHEN Period = 1 Then "Jan"
        ELSE ""
END

Attached Files

Download Screenshot_1.png (29.89 KB)

Hello Good day,

I have done it but there is no any changing?

Attached Files

Download CaseWhen.PNG (32.37 KB)

Download Table.PNG (4.74 KB)

Your Shift attribute is a date type.

The easy solution is to use Month(Shift) to return a number for a simple handle format. For example:

WHEN Month(Period) = 1 Then "Jan"
        ELSE ""

I have wrote that case when month(shift.start)="5/1/2020"

But it doesnt work.Why?

Simply because Month() function will return an integer value which represents the month of a specified date. For example: Month("31/12/2020") will return 12.

You should check more about query syntax on: SQL Date functions

There is a new solution but it doesnt give same result with true report.I have added some pictures.How can I solve this?

Attached Files

Download NewSolution.PNG (58.84 KB)

Download MyNewSolution.PNG (4.92 KB)

Download TrueResult.PNG (4.94 KB)

Here is the thing, Mesut.

When you set up Shift appearance and format on the Data sets tab of the DCS (see pic1), you tell DCS how to show the Shift field. But you never actually show this field in the report, so these settings are never applied.

The fields you actually show are Shift.Start.DateParts.MonthName and Shift.Start.DateParts.Year (see pic2) and they do what you need, but you told DCS to show them in two different columns, which is exactly what it did (see pic3).

I suggest, you remove all formatting from the Shift field on the Data set tab and show Shift.Start.BeginDates.BegOfMonth instead of Shift.Start.DateParts.MonthName and Shift.Start.DateParts.Year on the Settings tab.

Then you can use Conditional appearance setting to format the Shift.Start.BeginDates.BegOfMonth field (see pic4). The trick here is not to specify any condition, so the report always apply this format to this field.

In the format setting you should use the format expression, you've already found: DF='MMMM yyyy'

Attached Files

Download pic1.png (278.96 KB)

Download pic2.png (215.22 KB)

Download pic3.png (151.34 KB)

Download pic4.png (216.2 KB)

The problem was solved.Thank you very much.Thereby Junior developer exam was finished!

Could you send me please junior certification and next exam?

Hi Mesut.

This was NOT an exam. We just used some of the exam tasks to help you learn the platform, that's all. Exam is passed in a very different way: you will have limited time (6 hours) and you won't be able to consult anyone until the end of the certification.

You are welcome to apply for the formal exam, and you will get your certification as soon as you pass it.