Search
-
I only use the generate report function to test my reports. I find the preview screen to be extremely buggy and will not show any results at times, even though a generate report with a wide open filter range will show hundreds. I really wish Method would spend more time working with this report designer and work out all the ...
-
Here is an example of what I am talking about (The values with the arrows pointing to them should be a 1 because both criteria are met)
-
I am having nightmares with these functions in the Report Designer.
Here is a simple formula that is not working and I cannot figure out why:
Iif(([CallReport.ComplaintCode] = 'CA' and [CallReport.DateReceived] >= AddDays(Today(),-30)), 1, 0)
Can someone help me out with this. I have been designing reports for almost 15 ...
-
I had everything working fine and with ZERO changes to the above formulas, now it is no loner working correctly. It just groups everything in "<= 30 Days". I did not change a thing and it just stops working.
Can we open this thread back up for suggestions?
-
I figured out a difference approach. I created 3 Date Fields using the AddDay function for 30,60,90 days ago and then made my formula based off that.
I really wanted to see the DATEDIFF fuction get incorporated because this is a great tool for aging reports.
Thanks anyways. I think I figure out what I need!!
Here is my code for ...
-
Thanks for the reply, but I have already tried what you suggested and still get a date showing up in excel. I know I can change the format in excel, but I have another calculated field in the report that runs off the "Days Aged" field.
Here are the calculations for my fields:
AgedDays: Now() - ...
-
I am having a heck of a time getting a Date Difference field to show as an Integer in report designer. I also want to use this calculated field within another field to show Aging (30, 60, 90, >90).
Is this possible? I can get it to show as a date, but cannot convert to an integer or number
Thanks in ...
-
Worked like a charm.
But can you explain the correct way to do this?
"Back in Method just after the Generate Report action make sure clear the fields again"
-
Thanks Chad.. I think I understand what you mean. I will try it out and see if I am on the same page.
We are under the assumption that the end-user will not be able to "update the custom field created above in the company table" each time they want to run teh report.
But I will see if I can get it to work that way
-
I have a report that is using filtering within method. However, the customer wants these filters to be printed on the reports. So my only solution was to create 2 parameters within the report and have method assign values to these parameters based on some drop-down menus within method. The parameters are PARAM_StartDate and ...
|
|
|