Search results for query: *

Thanks a million - I appreciate the time you have put in to this. But as you can see I am stuck. I am the Administrator on the Catalog butI will have a look around to see what comes up at that end I knew I wssn't going mad!! Thanks again

Hi drlex OK I created a new report using just SQL and then inserted a prompt select T1.Plant_code , T1.PLANT_Name from regions T1 where ?Plants? like CONCAT(CONCAT('%',T1."PLANT_CODE"),'%') and it works fine. mmm.....

Hi I followed your instructions to the letter - I promise - and still when I go to add the Plant Column from my report (number 5 above) it is not available. The only options here are Access Security, string, user ID, Prompt Manager Maybe you see my issue. could it be something to do with the...

I am using Cognos Impromptu 7 against Oracle. The issue with your example above is that the Catalog column Loc is not available in the list on the left hand side of the screen. I got the SQL statement working alright though. select T1.Plant_code , T1.PLANT_Name from regions T1 where '217...

You can't do that - the only things available are USER ID, Access Security, STRING, Prompts Manager - you can't select a Column or Database column Can you please try this with something of your own data. I kow it is a lot to ask but.... Lisa

Hi I can't get even the simplest of CONTAINS statement to work. I successfully got [Plant Code] contains '401' but when I type in [Plant Code] contains '401 402' nothing comes back and I know both exist. I am trying to do the basic here with two plants being typed into the CONTAINS within...

OK so say I split the prompt at the @ symbol how can I send over several Plants - I can obviously make the Plant code a string or a number. My plant numbers are all three digits so I shouldn't encounter the issue you mention above. I want to send over an initial text of 201,202,203 or maybe...

Hi OK I can do this for one prompt for each but now I need to send multiple Plants and multiple product categories. I can send over a prompt such as '401,402,405@12,13,14' from the macro (as above). So before the @ symbol are one or many Plants and after the @ symbol are one or many Product...

Of course Thanks a million !! All the best Lisa

Hi I am successfully sending out via email reports with one prompt sent to the report using a DAT file but I am having an issue with two. This is how I send over one select case Plant case "101" strTo="email@email.com" the "101" coming from a DAT file. but how do I change this...