# SSRS Template

This section will guide you through the process of creating **CRM Report Template** for **SSRS Reports**.

* Open **Click2Export App** and then select **Reports.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MAh2UYQjAM3BAlRA36f%2F-MAh3sk1anNS17ER2Lod%2FSSRS_1.png?alt=media\&token=cec06ff9-9377-4810-98de-6086910354a5)

* Select the reports that need to be used for quick export using **Click2Export** then click on **Create Template Record** button from the ribbon.

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MAh2UYQjAM3BAlRA36f%2F-MAh49ngYeP6-1ZQsBC9%2FSSRS_2.png?alt=media\&token=f270129c-f187-4fc2-a54e-f1b438e00632)

* A confirmation dialog box will appear --> Click on **OK.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MAh2UYQjAM3BAlRA36f%2F-MAh4_jqX_rGGqgi3W4A%2FSSRS_3.png?alt=media\&token=a3912600-2524-43b8-8dfe-b72078cf1357)

* The **'Create Template Records'** submits a background job to create records. This allows you to continue with your work till all the templates have been created. Once it is done the following message would be displayed the following message. Click on **OK.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MAh2UYQjAM3BAlRA36f%2F-MAh55SKC2lZ8pO7rAFq%2FSSRS_4.png?alt=media\&token=6e88189c-9197-4547-ba31-b4833ecd7fe3)

* You can check the report templates created in the **CRM Report Templates Area** added in **Click2Export App --> CRM Report Templates.**

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MAh2UYQjAM3BAlRA36f%2F-MAh5PUBvS7jAo0GIAyB%2FSSRS_5.png?alt=media\&token=087ae687-a31b-457d-8a32-60fd3022c461)

* All the details in the template would be pre-populated based off the template selected at the time of CRM Report Template creation.

### General:

<figure><img src="https://272130504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M0QoyqUVI8_HaZ9FOSL%2Fuploads%2FtNP9Hma6xjof798dmdz2%2F29.1.png?alt=media&#x26;token=63a5d1fe-763c-46ec-9ae0-330b31067723" alt=""><figcaption></figcaption></figure>

**Template Type:** Report Template. This cannot be changed for SSRS Report Template.

**Template Name:** By default, this is set to the corresponding report name but is customizable and can be changed. This name is displayed for Report selection in the Click2Export Window. Hence, it should be unique and easy to identify with, especially when you have multiple templates for the same report.

**Default File Format:** **PDF, Excel, Word, CSV and TIFF** are the options. By default, with the solution it is set as **PDF**. With this option you can decide the default format in which the report would be exported.

**Export File Name:** This is the name that would be provided to the file generated upon export. You could provide a static name or dynamic name (based on a field of the record).

**For e.g. Template Name – {customerid} – {today}**

It will create a file name as: **Sample Click2Export Quote Report - Wayne Industries - Friday, 26 March 2021**

You can use any field name including custom field from the record type provided & today, to get today’s date.

**DateTime Field Format:** This field decides in what format Date & Time should be represented while exporting the report if Export File Name contains a DateTime field. It should have a valid DateTime format for e.g. - **mm/dd/yyyy for 03/23/2021**, **mm/dd/yyyy h:mm tt for 03/23/2021 5:50 AM**. It will reflect the Date & Time field format as Logged-In user’s settings if this field is left blank.

**Auto Send Email:** If enabled, it sends email automatically with the attached exported file, while performing the action from **Click2Export UI** or else it’ll open up the **Email Window** with all the necessary details populated and then you can hit send manually.

**Default Email Template:** The email would be created based on the default email template specified in that section. If left blank, the Email body would be empty.

**Default Filter:** It contains the default fetch XML of template.

### Email Configuration:

The next section is **'Email Configuration'.** To know more about this section, please click [here](https://docs.inogic.com/click2export/configuration/email-configuration).&#x20;

![](https://272130504-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M0QoyqUVI8_HaZ9FOSL%2Fuploads%2FSq1384iCEQe4q6a83CM8%2FAdvance%20Email%20Config_Report.png?alt=media\&token=6b37c011-0436-418c-92aa-1dc4f9c64939)

### CRM Report Parameters:

This will list down all the parameters that needs to be supplied for the report to render.

{% hint style="success" %}
For further queries, reach out to us at <crm@inogic.com>
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inogic.com/click2export/configuration/templates/ssrs-template.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
