I don't think I can use this quite as you suggest since I have everything in one report, using a UNION JOIN. Filtering like you suggested on the one join did not work.

Yes, certainly: User enters into the dashboard prompt two product_ids: product01;product02 The first query returns product01 and the associated custumer01 etc. The second query returns customer01 and all other products they ordered, ie. product11,product22,product33. Or like this: product_idcustomer_idproduct_id (other…

Never mind I figured it out. You can just enter custom CSS Style for sections/columns. Under Custom CSS Style just enter: font-size: 14px Correction: I did figure it out for display but it still does not work for PDF. If you have any tips for this, that would be great. Thank you!

I trued this but it didn't work: "Product ID" IN (REPLACE(@{pid},'V',',V') Each product ID starts with a V, so this would be an easy way to add a comma before. Of course, then I'll have to figure out how to ignore the first V in the string, but one step at a time.

Thanks for the clarification, Michael. I just want to add that when I post here, I don't 'expect' anyone to help me. I post in the hope that one of you more knowledgeable folks will be kind enough to offer advice - and I am truly grateful that some of you do. I do not believe that I have blamed anyone for anything here, as…

Thanks, Michael. I marked your answer as correct. I had to change the code a little bit, bit worked out in the end. The cool thing about it is that I was then able to also combine multiple rows by doing this: min(case when rank("ADDRESS_FIELD) = 1 then "ADDRESS_FIELD" end by "USERNAME")||min(case when rank("ADDRESS_FIELD)…

I really don't understand what the purpose of your posts is, Christian and Berg. I would understand if you posted once to point out this should be fixed elsewhere, but continuing about it in this way doesn't serve any purpose that I can see. I already explained my permissions don't allow me to do much beyond custom…

Sure, that is all true, but it's not in my hands to change right now. I do appreciate your help and working with me within the limitations I have though.

Thanks for replying, Thomas, but your critique helps me in no way to produce the report I need to produce.

Okay, so how could I use this to filter the column? Re- business value: it might, but I would have to try it and see the results first.

Thank you, Thomas, but I do not have administrator privileges.

I don't have a direct way available in the database to identify each row but I'm using RCOUNT to 'rank' the addresses in a custom column like this: RCOUNT("Address" BY "Client ID"). This creates a custom column which has a number corresponding to each address: Client IDNameAddress rank…

Thanks, Christian. My access is really limited - I cannot create opaque views nor do I have direct access to the database.

That is unfortunate. An alternative solution would then be to find a way to use line breaks in tables, since I could then massage the table layout to produce what I need without using LISTAGG to combine rows. But for this I would need line breaks in the table view. Any ideas? Note that I asked this in my other thread and…

I tried using that but it did not work and on closer inspection, it seems I don't actually have access: Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. I had incorrectly assumed I had access to EVALUATE because the function was available in the list of functions in…

Thanks, Joel. I tried using listagg but couldn't for the life of me figure out how to correctly call that function. I do have access to evaluate and evaluate_aggr.

Yes, I don't have the option of "treat text as html" but will try the narrative view tomorrow. This looks promising. I do not have administrator privileges so cannot give myself the html option by the way.

Thanks for your response, Gianni. I'd like to have several lines per row. so I can write up the output in complete sentences: "product id" sold "number" of copies. "number" of those were "color". That sort of thing. I intended to do this with a line break, but if it's possible otherwise, that is wonderful too. I think the…

This is all I've got to choose from:

Thanks for this example, Thomas, however I would need the months to be columns, not rows. This is so I can visually compare March this year, to March of last year, for example. Something like this: My database also has the months in YYYY/MM format, so I have to do some conversions to get it to display as above.