How to use different standard query

Conte Ercole

Hello all,
I have a customer who has to print for all A/R documents all the item in the document except whose in wich U_Print_YN = False.

Can I change the standard query behind the TCMARKETINGDOCUMENTDIN to exclude these items? It's the best work to do? I need to continue to have all object as shown in the attached file (.Jpg)

I suppose that if in the GenareScript I set the value visible = false if U_Print_YN = False in the report there will be a freespace, not used.

Thank a lot

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/conerc/PerCoreSuite.JPG]PerCoreSuite.JPG[/url]

Philipp Knecht

Hi Conte

You wont have freespaces so it should work by setting the whole detail to visible = false in case of U_Print="N" because the aggregates are also set on this detail.

Elsewise yes its possible to change the defaultquery.

Just get the original query out of the datasource (swa_ld/0995/companies/mycompany/queries/marketingservice.xml)
There you should look for a query with the id "Row".

Then copy this query over to b1 queries.

Save it also under the name "Row" or add
/* Name=[Row] @@Overwrite */
to the query. It's mentioned in the documentation.

hth