Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

tuple() function performance problem ?

Status
Not open for further replies.

NicolaTesla1

Programmer
Feb 9, 2009
37
CA
Hello,

I am using a report with one simple list of 7 metrics + 2 calculated columns.

I run the report and it executes with no problem in 2 seconds.

I ADD another calculated column at the end of my list with the following code:
tuple([METRIC];[Day1])

I run the report and it takes about 5 minutes to execute .... Not normal ?

Anyone knows if there are know performance issues with the tuple function ?

Thanks !
 
Hello to all,

I found a way to do my report.
I am know using a crossTab instead of a list ...
In this case the report runs faster. No need to use tuple functions.

I found out that often the crossTabs reports runs faster than same list report.

Thanks anyhow!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top