Search results for query: *

Thanks entaroadun. That helps a lot. I wonder what logic or method MTSR implements to join different SQL tables in a report created from different fields? My clients try to create a report using attributes(or metrics) from different SQL tables but the report sometimes throws an error or has...

Thanks entaroadun. People view the reports via Web interface. I create the reports via Desktop interface. Is there a way to control or suppress the filter on a child report when drilling from a parent report? For example, I only need a filter for the child report from the column I am...

I couldn't find a way to filter the attributes of the template neither. However, you can do something with metrics of the template by adding Report Limit. If you use the template to create a report, you can apply a filter to the report. If you use the template for drilling from an attribute...

In this scenario, MSTR generates the child report with filters by ORDER_No and TRANS_TYPE. ORDER_DATE is different from TRANS_DATE. ORDER_DATE is actually 11/06/2003 (PO date). I still got TRANS_No ORDER_No TRANS_TYPE TRANS_DATE 103 1 INVOICE...

Thank you entaroadun. This is another one. Let say there is another field for Latest_Transaction in my report. Data looks like ORDER_No CUSTOMER_No ORDER_DATE Latest_Trans 1 1 11/12/2003 INVOICE and the dat in TRANSACTION table looks...

I have a report created from ORDER table with the fields: ORDER_NUMBER, CUSTOMER_NUMBER, ORDER_DATE, etc. For example, data looks like ORDER_NUMBER CUSTOMER_NUMBER ORDER_DATE 1 1 11/12/2003 There are two filters. One is to...