function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
PrasunnaPrasunna 

How can we sort Joined reports to get that in date order

Hi All,

I created a joined report combaining opportunities with agreements and opportunities with products. Users are happy with that report but they want that in date order. I tried a lot but it is not possible to me. Does anyone know is there any possibility to get that in date order?

Thanks in Advance,
Pavithra.

 
ManojSankaranManojSankaran
Hi Pavithra,

Do you mean the opportunity Close date. In joint Report normally we can use the parent object fields in filter. So if  the date field is present in opportunity you can sort the report based on that date field.



Thanks
Manoj S
PrasunnaPrasunna
Hi Manoj,

Thank you so much for your response.

Opportunity Open date. Yes, I tried to sort that as ascending and even descending but date order is not changed it remailns same. Is there any other way to sort that?

Thanks,
Pavithra
yasmin priyayasmin priya
SELECT [FirstName] & " " & [LastName] AS Contributor, PledgeAmountRecd, tblPledgesLead.PhoneNumber, FirstName, LastName, Address1, CityName, ZipCode, DateRecd, CCur([PledgeAmountRecd]) AS Pledge FROM tblContributorsLead INNER JOIN tblPledgesLead ON tblContributorsLead.PhoneNumber=tblPledgesLead.PhoneNumber ORDER BY tblPledgesLead.DateRecd, Contributor DESC;
I think this will helps you.. Software Testing Training in Chennai (http://www.traininginsholinganallur.in/software-testing-training-in-chennai.html) | Selenium Training in Chennai (http://www.traininginsholinganallur.in/selenium-training-in-chennai.html) | QTP Training in Chennai (http://www.traininginsholinganallur.in/qtp-training-in-chennai.html)
ManojSankaranManojSankaran
Hi Pavirta,

Only the fields listed under the common fields folder can be added to the filter criteria/grouping. After adding it as a grouping field you can select the field and sort either ascesing or desending. Or you can also sort based on the below options available by default.



Thanks
Manoj S
User-added image

User-added image
PrasunnaPrasunna
Hi Manoj,

Sorry, That is for  Opportunity Close Date. Even After adding this as group by field and sorting it as ascending. Still i didn,t get in date order. Is there any way for this?

Thanks in Advance,
Pavithra.