Body: <p>On Drupal 7 / CiviCRM 5.36.1 I have a smart group that I export with a special mapping mixing data coming from relationships for each contact.</p>
  <p>I can use the url : <a href="https://domain.net/civicrm/group/search?force=1&amp;context=smog&amp;gid=20&amp;component_mode=1" rel="nofollow noreferrer">https://domain.net/civicrm/group/search?force=1&amp;context=smog&amp;gid=20&amp;component_mode=1</a> to access the results and export them but there is no action to send a kind of report.</p>
  <p>I would like to get an email once per day with a .csv file.</p>
  <p>Is this possible? How would you do this?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-29T20:24:51.237Z
Comments.Text: Can you make a report based off a Contact Report and filter it to just your Smart Group?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-03T12:34:59.630Z
Comments.Text: thanks Peter for considering my question. I can sure identify the contacts with this method and the next question is how to send a report with a specific mapping? When exporting, I just receive a file with one column for the contact name.
Comments.UserDisplayName: Guillaume Sorel
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-03T19:06:48.663Z
Comments.Text: not sure i follow what you are doing. but you can easily add fields to a Report. https://docs.civicrm.org/user/en/latest/reporting/set-up/
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-05T09:59:21.593Z
Comments.Text: maybe I'm wrong but it seems that I can't use relationships like I can in the export mapping tool. this is what I intend to do.
Comments.UserDisplayName: Guillaume Sorel
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-05T19:43:08.027Z
Comments.Text: generally i avoid civireports and just use Drupal Views and csv if i am using Drupal for the cms
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-07T07:46:26.080Z
Comments.Text: ok Pete, probably I can't get what I want this way. At least I know it's not adapted this way.
Comments.UserDisplayName: Guillaume Sorel
Tags: <smartgroups>
Title: Can I send a report from a smart group?
ThreadText: # Can I send a report from a smart group?
  
  (Asked by: username_0 on 2021-04-29)
  
  On Drupal 7 / CiviCRM 5.36.1 I have a smart group that I export with a special mapping mixing data coming from relationships for each contact.
  
  I can use the url : <https://domain.net/civicrm/group/search?force=1&context=smog&gid=20&component_mode=1> to access the results and export them but there is no action to send a kind of report.
  
  I would like to get an email once per day with a .csv file.
  
  Is this possible? How would you do this?
  
  **Tags:** smartgroups
  
  > **Comments:**
  > **username_1**: Can you make a report based off a Contact Report and filter it to just your Smart Group?  
  > **username_0**: thanks Peter for considering my question. I can sure identify the contacts with this method and the next question is how to send a report with a specific mapping? When exporting, I just receive a file with one column for the contact name.  
  > **username_1**: not sure i follow what you are doing. but you can easily add fields to a Report. https://docs.civicrm.org/user/en/latest/reporting/set-up/  
  > **username_0**: maybe I'm wrong but it seems that I can't use relationships like I can in the export mapping tool. this is what I intend to do.  
  > **username_1**: generally i avoid civireports and just use Drupal Views and csv if i am using Drupal for the cms  
  > **username_0**: ok Pete, probably I can't get what I want this way. At least I know it's not adapted this way.  
  
  ---
  
  ## 0 answers
  
  