inserting-ascii-or-unicode-characters

default

markdown

#How do I insert non-alphanumeric characters in a standard character set into an Izenda Report?

[[_TOC_]]

#Question

I'd like to insert some character into my report, but I'm having a hard time using an expression or value range.

#Answer

The easiest way for a user to enter a character which is not a standard letter or number is by using a custom format. This method requires more setup on the backend but is accessible to users with only a few clicks.

In the example code below, we will convert a boolean True to a unicode tickmark and a boolean False to a blank space.

```csharp
AdHocSettings.Formats.Add("Check", new BoolToCheckFormat());

[Serializable]
public class BoolToCheckFormatter : IFormatter
{
    public Type GetOutputDataType(DataTable table, int columnNumber, ReportOutputOptions reportOutputOptions, Field field)
    {
        return typeof(string);
    }

public object Format(DataTable table, int rowNumber, int columnNumber, Field field, DataTable originalTable, Field nameField)
    {
        object value = table.Rows[rowNumber][columnNumber];
        if (value == null || Convert.IsDBNull(value))
            return null;

if (value as bool? == true)
            return "&#10004";
        return "&#10008;";
    }
}

public class BoolToCheckFormat : IFormat
{
    private SqlTypeGroupCollection allowedTypeGroups = new SqlTypeGroupCollection();
    public SqlTypeGroupCollection AllowedTypeGroups
    {
        get { return allowedTypeGroups; }
    }

public SqlTypeGroupCollection DisallowedTypeGroups
    {
        get { return null; }
    }

public string Name { get { return "Check"; } }

public SqlTypeGroup DefaultFor
    {
        get { return SqlTypeGroup.None; }
    }

public bool Visible
    {
        get { return true; }
    }

public IFormatter[] CreateFormatters()
    {
        return new IFormatter[] { new BoolToCheckFormatter() };
    }

public BoolToCheckFormat()
    {
        allowedTypeGroups.Add(SqlTypeGroup.Binary);
        allowedTypeGroups.Add(SqlTypeGroup.Numeric);
    }
}
```

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing inserting-ascii-or-unicode-characters

Header

Sidebar