I am trying to add a new paramater to the report so that it pulls data from different divisions within the company.

 

The way it is setup now is that i pulls sale data from the database what i want it to do is pull data from the different divisions seperatly.

 

i added a new paramater to do this but i am having trouble updating the sql query so that it only pulls the data for that division.

 

I am not sure what is needed so i will post the sql query

 

 SELECT "job_hdr"."order-no", "job_hdr"."enter-date", "job_hdr"."name", "job_hdr"."item-desc", "job_hdr"."prod-code", "job_hdr"."unit-price", "job_hdr"."x-dec", "job_hdr"."parent-order", "so_hdr"."x-char", "job_hdr"."so-no", "ship_log"."tran-date", "ship_log"."quantity", "job_hdr"."country"
 FROM   {oj ("PUB"."job-hdr" "job_hdr" LEFT OUTER JOIN "PUB"."so-hdr" "so_hdr" ON ("job_hdr"."company"="so_hdr"."company") AND ("job_hdr"."parent-order"="so_hdr"."order-no")) LEFT OUTER JOIN "PUB"."ship-log" "ship_log" ON ("job_hdr"."company"="ship_log"."company") AND ("job_hdr"."order-no"="ship_log"."order-no")}
 WHERE  "ship_log"."tran-date"={d '2011-07-07'}
 ORDER BY "job_hdr"."country"

 

Not sure what else is needed please let me know.

 

And where would i add that option in the record.  Sorry for the hand holding request here but i am just not real familar with it at the moment.

 

There exsisting formula is

 

{ship_log.tran-date} in {?StartDate} to {?EndDate}

 

So i added this to the end

 

for {?Company} = {Company.company}

 

But i always get the message "the remaining text does not appear to be part of the formula"

 

I looked it up and it suggested that i set the data source location which i believe i did. But it is still not working properly.

 

Is there anything else i can look at.

 

So if they don't specify one it defaults to everyone instead of seperate ones.

 

Edit: I tried the formula you specified i get the field name is not known.

 

when i created the formula i used the wizard and double clicked the options into the formula but every time i get either the field name is not known or the remaining text does not appear to be part of the formula.

 

Verify?  i thought i did that by selecting the database but the more i read about it i think i did it wrong..  I go to database-> set datasource location -> then i ctrl click the fields that correspond to the paramater, insert the sql query and click ok. 

 

But the more i see i think i am doing that wrong but i am not sure.