Hi,
I have created reports in Suite and want to either âexportâ or âDownload PDFâ but when I do so, only the headers show up; no data! What am I doing wrong?
Thanks
Hi,
We need a little more information here,
If possible, could you attach a screenshot of your Downloaded PDF
Also, could you attach screenshots of the reportâs Detail view and Edit View?
Hi,
I have attached the screen shots you requested. I think I see the problem. . . there is no information in the Reports view in Admin mode⌠. . I did not create the report in the Admin mode under studio, but in the Create Report screen. Please explain how I should be creating the reports. I reviewed the tutorials for creating reports in Sugar but it didnât seem to translate. Any help is greatly appreciated!
Thanks,
Alyx
Hi,
Sorry, to clarify, I meant the Detail view and Edit view of the Report Record itself, not the admin > studio layouts.
Could you please attach these screenshots so I can see how you have built the record.
Hi,
I realized I sent the incorrect report detail view. . . I attached the correct report detail view and the PDF screenshot
Hi
The issue seems to come from your conditions.
What are you attempting to do with your âDeadline: Sophomore Qualifier Examâ condition?
If you make the condition âEqual to > Field > Noneâ It will most likely not work, so you may need to take another look at that in the Edit View.
Hi,
I have to manually enter the value âDeadline:Sophomore Qualifier Examâ to equal âsophomore qualifier examâ, ie > Equal to>Field>Deadline: Sophomore qualifier exam. Every time I view these types of reports with a date field, I have to manually enter the field and âupdate.â I thought this was a bug in Suite. . . . once I update the field and run the report, it pulls up the data. See attached screen shot.
My problem is this. . . once I run the report and it shows all the data. . . around 70 records or so, I cannot download as PDF
Should I define the Deadline: Sophomore Qualifier Exam in a different way? Iâve tried other configurations, but it doesnât pull the data. Itâs a simple report, I want to know the deadline for all freshman to complete their qualifier exam in order to move to the sophomore level.
Thank you,
alyx
Hi,
Updating the Parameters on this screen wonât update them properly, i.e: in the CRM or DB, this is only a temporary visual update that will allow you to see different results.
As far as I can see in your EditView screenshot, you have set Sophomore Qualifier Exam > Equal to > Field > -none-
To get the results in a way in which you can then download as PDF, you may wish to change it to Equal to>Field>Deadline: Sophomore qualifier exam. in the EditView of the Report record and then save changes.
I have done what you are suggesting, ie, set the field to equal âdeadline: sophomore qualifier examâ The only option I have is to âupdate,â (not save) which will then show a list of records. However, if I leave the reports page and then return, the field reverts back to âNone.â
This is a very simple report and I feel like Iâve done what you have suggested.
I have only created reports from the Reports page. . . I hit the âcreateâ button, define the fields, etc and run the report. I have also duplicated the report, saved it, and the field still reverts to NONE.From what you are saying below, âUpdating the Parameters on this screen wonât update them properly, i.e: in the CRM or DB, this is only a temporary visual update that will allow you to see different results.â If Iâm not to update from this screen, (the create or edit screen) where do I do the update? Am I supposed to create reports from the Admin mode? Please explain and/or send along tutorials.
The âDeadlineâ Sophomore Qualifier Exam" field is a custom date field. . . could this be the problem? Should I un-check âEnable range searchâ? I have created many custom date fields. I have included a screen shot of the field from the Admin>Studio>contacts>Edit Fields view.
Thanks.
Hi,
If you are viewing the report, click on âEditâ to go into the editview.
In this view, change âNoneâ to âdeadline: sophomore qualifier examâ
and click save.
I have attached your screenshot from earlier to show you which view you should change the condition on.
Does it work if you change this field?
Hi,
Iâm sorry if I have not made myself clear, but I have done what you said, over and over and over again. In EDIT mode, I select âDeadline:sophomore qualifier. . .â , click save and when I get to the next screen, the value reverts back to âNONEâ and I have to select the "Deadline: sophomore. ⌠" field again. When I do this, the records show up but when I choose, âDownload PDFâ OR âExportâ , only the headers appear on the report.
I inquired earlier, but since this is a custom created field, could this be the problem? I sent a screen shot of the field in an earlier email. (#23124)
Please help!
Hi,
I tested this with a few different custom fields and there seems to be an issue. Specifically, when you make a Date field Equal itself, it wonât pull through.
Open the Record, Click the Edit button and change the Deadline: sophomore qualifier exam Condition line to the following:
Deadline: sophomore qualifier exam > equal to > Date > Deadline: sophomore qualifier exam
I have attached the format of this, just for clarity.
and click save.
Does it pull through to the next page, allowing PDF printing? If not, could you send another screenshot of the Edit view?
It works!!! Wow. Thank you.
Soooooo, now I have another problem: The print out on the report is off by one day. Ie, In the record for a particular student, the date IN THE RECORD for âDeadline:Sophomore Qualifier Examâ = 7/31/2015.
However, ON THE REPORT, the âDeadline:Sophomore Qualifier Examâ = 7/30/2015. The report is one day off and is consistently incorrect on all records. I tested a couple of the reports, and the date is off by one day on the other reports I have created as well.
Help!
Hi,
I have not received an answer regarding the report being off by one date; did you receive the request? If not, here it is again: âThe print out on the report is off by one day. Ie, In the record for a particular student, the date IN THE RECORD for âDeadline:Sophomore Qualifier Examâ = 7/31/2015.
However, ON THE REPORT, the âDeadline:Sophomore Qualifier Examâ = 7/30/2015. The report is one day off and is consistently incorrect on all records. I tested a couple of the reports, and the date is off by one day on the other reports I have created as well.â
Thank you,
Alyx
Iâm unable to replicate this issue, I Tried a few different reports and all of mine show the correct dates in all fields, including the Printed PDF.
Have you made any modifications to the code that may have affected this?
I could take a look again at your reportâs Editview/Detailview and see if I can notice any issues. Could you post screenshots of these?
Hi,
I have attached the following:
Edit View: Report
Detail View: Report
Student Record
Edit View: Custom Field (EDIT FIELD VIEW)
Thank you,
Alyx
Hi,
It seems as though, when the report is being generated, it takes the Timezone set on your user into consideration.
As the Database stores Date & Datetime fields in UTC:
If the Timezone is anything less than GMT+0:00, it will show the wrong date.
This is because the Date field sets a hidden time value to, for example, 1/01/2001 12:00AM
So, If the Timezone is something like GMT -1:00, the report may generate it as 12/31/2000 11:00pm
Hopefully this explanation helps understand the issue. I have logged it as an issue on our Github: #537
The only way I can see to get around this at the moment is to change your timezone to one that is a few hours further ahead while printing generating Reports. You can do this by clicking your username on the top-right of the screen, clicking the âAdvancedâ tab and changing your Time zone.
Thank you!!! That explains it. The person who set up Suite is in London. ⌠at least now I can explain to my team why the date is off by one day.
Now I have another question. I want to add the primary email address to a report, but cannot find the field when I am creating the report. The default email, as far as I can tell is named âemail1â or âprimary email addressâ and I cannot find it in the drop down selection on the report:create page. I looked at past support posts and tried what they said (going to account and selecting email address from there) but it did not work. Regardless of the module I select: Contacts, Accounts or Email Addresses, I choose Operator: Equal to>Type: Field>Value: These are all the fields in my contact records and does not have the primary email address as an option.
All of our records are âcontactsâ and not âaccounts.â Could this be the problem?
Thanks
Hi, you should be able to add a Contactâs Email address to the report like this:
Expand the Dropdown âEmail Address : Email Addressâ,
Expand the Dropdown within that called âEmail Addressâ
Drag over the field called âEmail Addressâ
I have attached a screenshot of the dropdowns and field I am referring to
Hello,
I have done what you suggested, many, many times. Here is my issue:
I select the âemail addressesâ option from the drop down but there is no âemail addressâ option for the value.
Please see attached screen shot.
Thank you.