Bug #5500

Post Event >> JPPPA Reports

Added by Lim Leonard about 9 years ago. Updated almost 9 years ago.

Status:Work Completed-End life cycleStart date:September 21, 2015
Priority:NormalDue date:September 22, 2015
Assignee:Lim Leonard% Done:

70%

Category:TPMS_TestSpent time:-
Target version:-

Description

**-for fastfact by ministry, sector, programme type please refer the attachment.
-the search filter are not working,
e.g. the data from year 2015 is the same with the data from year 2007
-fast fact by months is not showing/ no data.
-most of the reports are still empty, not showing/ no data.

Please kindly assist
Thank You

Reports - No of programme by Region and country.png (235 KB) Lim Leonard, October 26, 2015 17:24

Reports - Programme by Country.png (243 KB) Lim Leonard, October 26, 2015 17:24

Reports - Programme by Ministry.png (346 KB) Lim Leonard, October 26, 2015 17:24

Reports - Programme by Month.png (239 KB) Lim Leonard, October 26, 2015 17:24

Reports - Programme by multiple location.png (276 KB) Lim Leonard, October 26, 2015 17:24

Reports - Programme by Sector.png (352 KB) Lim Leonard, October 26, 2015 17:24

Reports - sales by region and country.png (282 KB) Lim Leonard, October 26, 2015 17:24

Outcome Impact By country.png (268 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By country (Detailed).png (284 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By sector.png (194 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By Ministry.png (264 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By month.png (265 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By programme type.png (234 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By programme type (Detailed).png (227 KB) Lim Leonard, November 02, 2015 17:00

Outcome Impact By programme type (summary value).png (212 KB) Lim Leonard, November 02, 2015 17:00

OUTCOME IMPACT BY PROGRAMME TYPE , SUMMARY VALUE.png (163 KB) Lim Leonard, November 05, 2015 11:11

sales by region and country.png (284 KB) Lim Leonard, November 05, 2015 11:11

outcome impact by programme type Detailed.png (210 KB) Lim Leonard, November 12, 2015 10:49

outcome impact by ministry.png (293 KB) Lim Leonard, November 13, 2015 15:11

History

#1 Updated by Norhaidah Md Dasuki about 9 years ago

  • Due date set to September 22, 2015
  • Category set to TPMS_Test

#2 Updated by Ong Wei Kuan almost 9 years ago

  • Status changed from New - Begin Life Cycle to Internal Testing
  • Assignee changed from Ong Wei Kuan to Lim Leonard

Hi Leonard,

I've pushed the fixes, you may retest after redeployment later. TQ.

#3 Updated by Lim Leonard almost 9 years ago

  • File outcome impact by programme type (summary).png added

Hi WeiKuan,

there are some bugs that need to be solved:

fast fact -No. of Programme by month -> no data
reports - programme by Country -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
reports - programme by Sector -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
reports - programme by ministry -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
reports - programme by month -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
reports - No. of programme by region and country -> no data
reports - list of programme with multiple location -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
reports - top 10 generated sales by country -> no need to show the data if the value is RM0.00
reports - sales by region and country -> no data
outcome / impact by country -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by country (detailed) -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by sector -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by ministry -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by Month -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by programme type -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by programme type (Detailed) -> incorrect date format , use abbreviation (for Ministry and Lead agency), alignment of the margin to look better.
outcome / impact by programme type (summary) -> refer to attachment.

*date format should be : 1 January 2015 - 31 December 2015
*all reports need to include the date range, month or year depending on the search filter that user use. for the indicator in the reports

Please kindly assist
Thank You

#4 Updated by Lim Leonard almost 9 years ago

  • Assignee changed from Lim Leonard to Ong Wei Kuan

#5 Updated by Ong Wei Kuan almost 9 years ago

  • Assignee changed from Ong Wei Kuan to Lim Leonard

HI Leonard,

1. fast fact No. of Programme by month -> no data
-
> I tested at my local, there are data in the report, please help to check in database by using below query.
--> Query : select * from event_main a inner join r_programme_type b on a.r_programme_type_id = b.r_programme_type_id where b.r_programme_category in('J','B') and year(a.em_start_date) = 2015;

2-5. Fixed(date format & abbreviation). About the alignment adjust, can you assist to explain further?(what to adjust?)

6. No. of programme by region and country > no data
-
> I tested at my local, there are data in the report, please help to check in database by using below query.
--> Query : select * from event_main a inner join event_city b on a.em_id = b.em_id inner join r_country c on b.r_country_id = c.r_country_id inner join r_region d on b.r_region_id = d.r_region_id inner join r_programme_type e on a.r_programme_type_id = e.r_programme_type_id where e.r_programme_category in('J','B') and year(a.em_start_date) = 2015;

7. Fixed(date format & abbreviation). About the alignment adjust, can you assist to explain further?(what to adjust?)

8. Fixed.

9. sales by region and country > no data
-
> I tested at my local, there are data in the report, please help to check in database by using below query.
--> Query : select * from event_main a inner join event_detail b on a.em_id = b.em_id left join event_city c on a.em_id = c.em_id inner join r_country d on c.r_country_id = d.r_country_id inner join r_region e on c.r_region_id = e.r_region_id inner join r_programme_type f on a.r_programme_type_id = f.r_programme_type_id where f.r_programme_category in('J','B') and year(a.em_start_date) = 2015;

10-16. Fixed(date format & abbreviation). About the alignment adjust, can you assist to explain further?(what to adjust?)

17.
a. The title cannot covers 2 columns. The length of title is fixed, if the column is 1, it will looked weird. Are you sure to change the title length to cover 2 columns?
b. Fixed.

TQ.

#6 Updated by Lim Leonard almost 9 years ago

Hi WeiKuan,

-for the reports with no data, i have already checked the database. there is data in the database, but the in the reports its not being shown,

-Please add the Reports title in the center top of the reports as in URS, (Not the title in the table, it should have 2 title as in the URS)

-please put padding(2) between the line and the text. to make it more easier to read

-for the rest please refer to the attachment,

Thank You

#7 Updated by Lim Leonard almost 9 years ago

  • File fastfact.png added
  • File Reports 2.png added
  • File Reports.png added
  • Assignee changed from Lim Leonard to Ong Wei Kuan

#8 Updated by Ong Wei Kuan almost 9 years ago

  • Assignee changed from Ong Wei Kuan to Lim Leonard

Hi Leonard,

1. For the report desgin, please get Jeng Wei to assist on this. TQ.
2. For the data checking, can you send the data to me?

#9 Updated by Lim Leonard almost 9 years ago

hi Wei Kuan,

the data, do you mean the result from the query?

thanks

#10 Updated by Ong Wei Kuan almost 9 years ago

Yes.

#11 Updated by Lim Leonard almost 9 years ago

  • Assignee changed from Lim Leonard to Ong Wei Kuan

Hi Wei Kuan,

Please check your email,

Thanks

#12 Updated by Ong Wei Kuan almost 9 years ago

Hi Leonard,

Kindly assist to revert the result for below query. Thanks ya.

select month(a.em_start_date) as month, count(*) from event_main a inner join r_programme_type b on a.r_programme_type_id = b.r_programme_type_id where b.r_programme_category in('J','B') and year(a.em_start_date) = 2015 group by month order by month asc;

#13 Updated by Ong Wei Kuan almost 9 years ago

  • Assignee changed from Ong Wei Kuan to Lim Leonard

Hi Leonard,

I've updated the sql queries for the 3 reports(no data) and tested fine in db. Kindly retest.
And also, I've added the data range in the title in fast fact - No. of Programme by Ministry. Kindly retest, if it is ok, i will add into all reports.

Thanks.

#14 Updated by Lim Leonard almost 9 years ago

  • Assignee changed from Lim Leonard to Tan Jeng Wei

Hi Jeng Wei,

Please assist in look and feel modification,
you can refer to the previous print screen and list

Thanks

#15 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

fixed....

#16 Updated by Lim Leonard almost 9 years ago

  • File fastfact - by month.png added
  • File fastfact - by status.png added
  • File fastfact-by programme type.png added
  • File reports - all generated sales by country.png added
  • File reports - by months.png added
  • File reports - country detailed.png added
  • File Reports - prog. by country.png added
  • File reports - prog. by multiple location.png added
  • File reports - prog. by sector & Ministry & Month.png added
  • File reports - program type detailed.png added
  • Assignee changed from Lim Leonard to Tan Jeng Wei

8/10/15

there is some issue still havent fixed.

1. Padding between line and text.
2. borders problems.
3. missing main title,
4. missing 1 reports 'Outcome / Impact by type of Programme'
5. other problems can refer to attachment.

Please, refer to URS.

Thank You

#17 Updated by Lim Leonard almost 9 years ago

  • File reports - program type summary.png added
  • File reports - top 10 country.png added

#18 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

fixed, please test after deployed....

#19 Updated by Lim Leonard almost 9 years ago

  • Assignee changed from Lim Leonard to Tan Jeng Wei

1. Same Issues still exists. Please Refer to all the attachment.
2. for Outcome/Impact by Programme Type (Summary Value) > to remove the data that has 0 value on it.
3. for the detailed reports and outcome / impact > in the table 'Impact Feedback' to remove the data that has 0 value
5. and put grouping for the reports. Please follow this format
Fast Fact :

No. of Programme by Ministry
No. of Programme by Sector
No. of Programme by Type of Programme
No. of Programme by Month
No. of Programme by Status

Reports :

Programme by Country
Programme by Sector
Programme by Ministry
Programme by Month
No. of Programme by Region and Country
List of Programme with Multiple Locations
All Generated Sales by Country
Top 10 Generated Sales by Country
Sales by Region and Country

Outcome / Impact :

by Country
by Country (Detailed)
by Sector
by Ministry
by Month
by Programme Type
by Programme Type (Detailed)
by Programme Type (Summary Value)

Please Kindly Assist,
Thank You

#20 Updated by Norhaidah Md Dasuki almost 9 years ago

  • Status changed from Internal Testing to Development / Work In Progress

#21 Updated by Lim Leonard almost 9 years ago

  • Description updated (diff)

#22 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

Fast Fact :

No. of Programme by Ministry
No. of Programme by Sector
No. of Programme by Type of Programme
No. of Programme by Month
No. of Programme by Status

Reports :

Programme by Country
Programme by Sector
Programme by Ministry
Programme by Month
No. of Programme by Region and Country
List of Programme with Multiple Locations
All Generated Sales by Country
Top 10 Generated Sales by Country
Sales by Region and Country

Outcome / Impact :

by Country
by Country (Detailed)
by Sector
by Ministry
by Month
by Programme Type
by Programme Type (Detailed)
by Programme Type (Summary Value)
all the report is already fixing
1. Padding between line and text.
2. borders problems.
3. missing main title

please test after deployed....

missing 1 reports 'Outcome / Impact by type of Programme'
1) doing now....

#23 Updated by Lim Leonard almost 9 years ago

  • File deleted (fastfact-Ministry.png)

#24 Updated by Lim Leonard almost 9 years ago

  • File deleted (fastfact-Programme.png)

#25 Updated by Lim Leonard almost 9 years ago

  • File deleted (fastfact-Sector.png)

#26 Updated by Lim Leonard almost 9 years ago

  • File deleted (outcome impact by programme type (summary).png)

#27 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (fastfact.png)

#28 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (Reports 2.png)

#29 Updated by Siti Norahayu Mohd Desa almost 9 years ago

  • File deleted (reports - top 10 country.png)

#30 Updated by Siti Norahayu Mohd Desa almost 9 years ago

  • File deleted (reports - program type summary.png)

#31 Updated by Siti Norahayu Mohd Desa almost 9 years ago

  • File deleted (Reports.png)

#32 Updated by Siti Norahayu Mohd Desa almost 9 years ago

  • File deleted (reports - program type detailed.png)

#33 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (reports - prog. by sector & Ministry & Month.png)

#34 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (fastfact - by month.png)

#35 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (fastfact - by status.png)

#36 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (fastfact-by programme type.png)

#37 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (reports - all generated sales by country.png)

#38 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (reports - by months.png)

#39 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (reports - country detailed.png)

#40 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (Reports - prog. by country.png)

#41 Updated by Norhaidah Md Dasuki almost 9 years ago

  • File deleted (reports - prog. by multiple location.png)

#42 Updated by Lim Leonard almost 9 years ago

Fast Fact :
No. of Programme by Ministry
- please put the title 'No. of Programme by Ministry'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Sector
- please put the title 'No. of Programme by Sector'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Type of Programme
- please put the title 'No. of Programme by Type of Programme'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Month
- please put the title 'No. of Programme by Month'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Status
- please put the title 'No. of Programme by Status'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

Reports :
Programme by Country
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Programme by Sector
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Programme by Ministry
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Programme by Month
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Region and Country
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
- Please add on the Title 'Programme by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
List of Programme with Multiple Locations
- Remove the event, if the event's venue is in one location only
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
All Generated Sales by Country
- Please put the title 'All Generated Sales by Country'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Top 10 Generated Sales by Country
- Please put the title 'Top 10 Generated Sales by Country'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Sales by Region and Country
- Please refer to Attachment
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
- Please add on the Title 'Programme by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')

Please kindly assist
thank you

#43 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Norhaidah Md Dasuki

ALready grouping based on report type.
fixed padding , column header repeat , colour...
- fixed disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

#44 Updated by Siti Norahayu Mohd Desa almost 9 years ago

  • Assignee changed from Norhaidah Md Dasuki to Lim Leonard

#45 Updated by Lim Leonard almost 9 years ago

all the date range, to put validation that end date cannot be earlier than start date.

Fast Fact :
No. of Programme by Ministry
- please put the title 'No. of Programme by Ministry'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Sector
- please put the title 'No. of Programme by Sector'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Type of Programme
- please put the title 'No. of Programme by Type of Programme'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Month
- please put the title 'No. of Programme by Month'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
No. of Programme by Status
- please put the title 'No. of Programme by Status'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

Reports :
Programme by Country
- Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Programme by Sector
Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

Programme by Ministry
Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

Programme by Month
Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.

No. of Programme by Region and Country
- Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
- Please add on the Title 'Programme by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
List of Programme with Multiple Locations
- Remove the event, if the event's venue is in one location only
- Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
All Generated Sales by Country
- Please put the title 'All Generated Sales by Country'
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Top 10 Generated Sales by Country
- Please put the title 'Top 10 Generated Sales by Country'
- please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
Sales by Region and Country
- Please refer to Attachment
please disable the 'DATE RANGE' Field, to avoid user enter inappropriate date format.
- Please add on the Title 'Programme by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')

Outcome / Impact :
by Country
- please put the title 'Outcome / Impact by Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Country (Detailed)
- please put the title 'Outcome / Impact by Country (Detailed)'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Sector
- please put the title 'Outcome / Impact by Sector'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Ministry
- please put the title 'Outcome / Impact by Ministry'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Month
- please put the title 'Outcome / Impact by Month'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Programme Type
- please put the title 'Outcome / Impact by Programme Type'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Programme Type (Detailed)
- please put the title 'Outcome / Impact by Programme Type (Detailed)'
- Please change 'type of Product' to 'Type of product/service'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment
by Programme Type (Summary Value)
- please put the title 'Outcome / Impact by Programme Type (Summary Value)'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
- Please refer to attachment

Please kindly assist
thank you

#46 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard
  • % Done changed from 0 to 40

Hi leo,

Fast Fact :
-No. of Programme by Ministry
-No. of Programme by Sector
-No. of Programme by Type of Programme
-No. of Programme by Month
-No. of Programme by Status
  1. fixed title 'No. of Programme by Ministry'

Reports :
-Programme by Country
-Programme by Sector
-Programme by Ministry
-Programme by Month
-No. of Programme by Region and Country
-All Generated Sales by Country
-Top 10 Generated Sales by Country
-Sales by Region and Country

##above all fixing title
  1. fixed searching filter

Outcome / Impact :
-by Country
-by Country (Detailed)
-by Sector
-by Ministry
-by Month
-by Programme Type
-by Programme Type (Detailed)
-by Programme Type (Summary Value)

##above all fixing title
  1. fixed searching filter

kindly please test after deployed....

#47 Updated by Lim Leonard almost 9 years ago

  • Assignee changed from Lim Leonard to Tan Jeng Wei

#48 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

Hi leo ,

i already double check all the report, please test it after deployed.

#49 Updated by Lim Leonard almost 9 years ago

Fast Fact :
No. of Programme by Type of Programme
- wrong query

Reports :
No. of Programme by Region and Country
- please fix the borders in 'total' column
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
Sales by Region and Country
- Please refer to Attachment
- the total amount is not correct
- Please add on the Title 'Sales by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')

Outcome / Impact :
by Country
- Please remove the line in 'Total No. of Activities'
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Country (Detailed)
- Please remove the line in 'Total No. of Activities'
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
- Please change the second 'No. of Participant' to 'No. of Participant (SME)'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')
by Sector
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Ministry
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Month
- Please remove the line in 'Total No. of Activities'
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type (Detailed)
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type (Summary Value)
- Please refer to attachment

Please kindly assist
thank you

#50 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

Hi leo,

Fast Fact :
No. of Programme by Type of Programme
-fix query

Reports :
No. of Programme by Region and Country

Outcome / Impact :
-by Country
-by Country (Detailed)
-by Sector
by Ministry
by Month
by Programme Type
by Programme Type (Detailed)
by Programme Type (Summary Value)

Statement above was fixed....
--> fix recheck on the 'impact feedback' column.
-->
Please test after deployed ....

statement below not yet to fix.....
Sales by Region and Country
- Please refer to Attachment
- the total amount is not correct
- Please add on the Title 'Sales by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')

#51 Updated by Lim Leonard almost 9 years ago

Reports :
Sales by Region and Country
- Please refer to Attachment
- the total amount is not correct
- Please add on the Title 'Sales by Region and Country'
- please specify the search filter used (eg. 'programme by region and country - 2015', 'programme by region and country - January 2015-December 2015', 'programme by region and country - 1 January 2015-31 December 2015')

Outcome / Impact :
by Country
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Country (Detailed)
- Please change the second 'No. of Participant' to 'No. of Participant (SME)'
by Sector
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Ministry
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Month
- Please remove the line in 'Total No. of Activities'
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type (Detailed)
- please refer attachment
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact
by Programme Type (Summary Value)
- Please refer to attachment (Prev attachment)

#52 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard
  • % Done changed from 40 to 70

Hi leo,

Reports :
Sales by Region and Country
- fix the layout.
- Fix total amount is not correct
- modify again on the Title to 'Sales by Region and Country'
- please specify the search filter used date ---> this one already fix last few week again.

Outcome / Impact :
by Country
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact --> was fix...
by Country (Detailed)
- Please change the second 'No. of Participant' to 'No. of Participant (SME)'
by Sector --> was fix...
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact --> was fix...
by Ministry
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact--> was fix...
by Month
- Please remove the line in 'Total No. of Activities'--> was fix...
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact--> was fix...
by Programme Type
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact --> was fix...
by Programme Type (Detailed)
- please refer attachment --
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact --> Not fix yet..

by Programme Type (Summary Value)
- Please refer to attachment (Prev attachment)--> was fix...

#53 Updated by Lim Leonard almost 9 years ago

Outcome / Impact :
by Country (Detailed)
- Please change the second 'No. of Participant' to 'No. of Participant (SME)'
by Ministry
- refer to attachment
by Programme Type (Detailed)
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact

#54 Updated by Tan Jeng Wei almost 9 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

Hi leo,

Outcome / Impact :
1) by Country (Detailed)
- Please change the second 'No. of Participant' to 'No. of Participant (SME)'
  1. this one i already change to 'No. of Participant' to 'No. of Participant (SME)' , it just didn't show in matrade website.anywhere i try to increase width of columns. please try test it after deployed.
2)by Ministry
  1. layout was fixed.

3)By Programme Type (Detailed)
- please recheck on the 'impact feedback' column. these value should be displayed if the value is NOT '0.00' : Generated sales, Actual Sales, Potential sales, Media Value, Potential Investment, No. of Exhibitor, No. of Visitor, No. of Participant, No. of Participant (SME), No of Buyer, No. of Enquiry, No. of Business meeting, and Other impact

  1. Already add on other impact to the last columns. please check it after deployed.

thanks.

#55 Updated by Lim Leonard almost 9 years ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle

Also available in: Atom PDF