Maree Palmer's Page

In Alchemex ive created a container linking AR ivoice headers and detail and customeri wrote the report to list detailed sales by AR Items but each customer has Optional fields on it for district and resturant. now i can link the Ar Customer optional fields Table in the container but this will create the following problem because of the way the table is it will list it Custno District value custno Resturant value this will give me 2 lines for the detail and i would like to make it come through…See More

Hi therei have a few small clients that use the free version with the default containers created when the use the purchases master and they add docdate they always get 11th of the monthbelow is your formula for the date expression spot the issue CAST(SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 1, 4 )+'-'+SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 5, 2 )+'-'+SUBSTRING(CAST("POHSTL"."TRANSDATE" AS CHAR(8)), 3, 2 )AS DATETIME) now this is not a problem for me i have a connector lic so i…See More

i am running the purchases master report on a clients database.The "date" column on the data sheet(sheet 1) is showing the wrong date. It seems to have taken one date and repeated it on every line.This is not the first database i have seen this happen to.Is there a way to correct it?See More

To get your Free Report Templates, be sure to join this Group in the BI Community.If you have Free Report Templates feel free to share them here.See More