Topics started by BMORGAN

6 Topics

B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Lobby Data Source - Case in 'Condition' not working for all users

Hi,I have the following case in a Data Source condition:SOURCE_REF1 IS NOT NULLANDCASE WHEN TO_CHAR(SYSDATE, 'D') = 1 AND TRUNC(PLANNED_SHIP_DATE) > TRUNC(SYSDATE)-100AND TRUNC(PLANNED_SHIP_DATE) < TRUNC(SYSDATE)+2                      THEN                      1WHEN TO_CHAR(SYSDATE, 'D') = 2 AND TRUNC(PLANNED_SHIP_DATE) > TRUNC(SYSDATE)-100AND TRUNC(PLANNED_SHIP_DATE) < TRUNC(SYSDATE)+2                      THEN                      1WHEN TO_CHAR(SYSDATE, 'D') = 3 AND TRUNC(PLANNED_SHIP_DATE) > TRUNC(SYSDATE)-100AND TRUNC(PLANNED_SHIP_DATE) < TRUNC(SYSDATE)+2                      THEN                      1WHEN TO_CHAR(SYSDATE, 'D') = 4 AND TRUNC(PLANNED_SHIP_DATE) > TRUNC(SYSDATE)-100AND TRUNC(PLANNED_SHIP_DATE) < TRUNC(SYSDATE)+2                      THEN                      1WHEN TO_CHAR(SYSDATE, 'D') = 5 AND TRUNC(PLANNED_SHIP_DATE) > TRUNC(SYSDATE)-100AND TRUNC(PLANNED_SHIP_DATE) < TRUNC(SYSDATE)+4                      THEN                      1WHE

3
A
Superhero (Employee)
8 months ago
B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

How to schedule the IAL to run annually?

Hi all, I need to schedule an IAL to run once a year on the 1st OCT.  Is this possible in APP10?Many thanks,Ben

4
B
Sidekick (Customer)
9 months ago
B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Trendline on Bar Chart

Hi,Does anyone know if its possible to add a trendline over a bar chart in App10? If so, how please? 

3
B
Sidekick (Customer)
9 months ago
B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

BLOB Field is causing Crystal Reports to crash

Hi,I hope someone can help.I’ve created a SQL Expression in Crystal Reports to select the BLOB field (FILE_DATA column) from the edm_file_storage view, however, when I include the field and refresh the report, Crystal crashes. I changed the statement to select a different column within the view and the report ran fine.Could anyone suggest why Crystal would crash when selecting in the ‘BLOB’ field, from the FILE_DATA column?

0
B
Sidekick (Customer)
2 years ago
B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)

Attached a PDF image in a Crystal Report

Hi,My current placement has a library of images associated to parts. It was initially thought all images were to be .jpeg which would be easy enough to insert into a Crystal report using the “(BLOB)” field. However, it has now been decided that all part images will be .pdf file format. Is it possible to attached a .pdf file and view as per a .jpeg in a Crystal report?Regards,Ben

0
B
Sidekick (Customer)
2 years ago
B
Sidekick (Customer)
BMORGANSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Remove Label from a Custom Field

Hi,I hope someone can help.I have created two custom fields, one for Region and the other for Description. The fields will sit side by side, however, I would like to hide the label from the second Custom Field (Description). For Example: currently I have “Region: Description:  *Field*   *Field*”I would prefer to amend the Region label to include Description, so would like “Region Description:  *Field*   *Field*”So to omit the unwanted colon after Region.Is this possible?

8
B
Sidekick (Customer)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings