Hello,
I am hoping someone much smarter than I can help solve this puzzle.
I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords()) formula query in order to showcase how many records the user can expect to generate.
The first thing I did was to go to the report, unswitch the 'new style', choose 'more', and then select "show expanded url for this report".
Which gives me this (made minor change to allow the formula query to save):
Size(GetRecords((("{'33'.IR.'this+wk'}OR{'33'.BF.'today'})AND{'76'.XEX.'No+Street+Address'}AND{'61'.XEX.'No+Employer+Name'}AND{'68'.XEX.'0'}AND{'19'.EX.''}AND{'82'.EX.'Send+Letter'}AND{'60'.XEX.'ABC'}AND{'69'.XEX.'Paid'}AND{'69'.XEX.'Promise+to+Pay'}AND{'69'.XEX.'Escalated'}AND{'17'.EX.'Delinquent+in+30+days'}")), [_DBID_ACTIVITIES]))The above expanded url equals the below (report parameters)
How can I modify this expanded url and turn it into a workable formula query?
Any and all tips/ tricks are welcomed.
Thank you!
