Search the help documentation

Search:

Can't find what you are looking for? Use the Feedback tab in your app to submit an issue, or email support@ qrimp.com.


idnamedescriptionParentTopic
deleteedit213Reordering columnsTo reorder the columns in a table, go to the [grid edit] view of the table. Click and hold the column header of the column you wish to rearrange. A multi-directional arrow icon will appear and a red line will show to the left side of the column you are moving. Hold and drag the column to its new position. All views will be updated to reflect your new column order.

<img class="border" src="attachments/developer.qrimp.com-1cd04005-3933-4475-8b37-998704321f50/grideditreorder.png" />		Grid View
deleteedit212Importing Large Datasets<!--<nobreak>-->
The following tips and tricks will help you import large datasets. If you are working with a small dataset, you can use the menu item Develop > Import data. See [Import Data].

<h3>Copy Paste from Excel to Form</h3>
Keep the number of rows under 10,000 and the width less than 8,000 characters. We've noticed IE pastes large data sets better than Firefox. Sometimes the browser will crash if you try to paste a very large data set into a text field. So if this happens, try using one of the methods below. You can also paste this data into a .txt file and upload it using the Tab delimited file method described below.

<h3>Tab Delimited File Upload</h3>
One flat file import can be many megabytes, but upload time will depend on your connection speed. Since this is just one flat file, only a single table will be built. All the data should be consistent, meaning all date fields should be valid dates, numbers should all be numbers, no letters in the number fields. These rules apply to all import methods.

<h3>Excel 97/2000 .xls Import</h3>
File size < 20 MB, < 100,000 records per sheet, fewer than 20 sheets. Match sheet names to table names in Qrimp. Use this if you want to build the relational model to support multiple data sets automatically. Each sheet will be a table.

<h3>Importing Large Datasets</h3>
If you are converting an existing application or have extremely large sets of data you need to import, then the web is not a viable option. Because network latency, script timeouts, and other factors designed for a high scale environment like a web application are not designed to accommodate very long running batch processes, we need to import large sets without using the web.

<h3>Qrimp Hosted</h3>
If you are using Qrimp's Hosted solution, you can import data using the Rest-like API. This could take a while with millions of records to import, so in a scenario like this, it may always be best to contact support first. You can also download the [Qrimp Server Installation] and use the method described below.

<h3>Qrimp Enterprise Solution</h3>
If you are using the Enterprise solution installed on your local network, there are many options available for importing data. You will probably want to get help from someone experienced with Microsoft SQL Server to perform one of these import options.

The first step to importing a large data set with Qrimp installed is to define the application. This is usually easiest using Qrimp's web interface to define tables manually. This process will create the underlying primary keys, foreign keys, and support tables needed to run your Qrimp application.

A more difficult, but more flexible way is to define the data model directly using SQL Management Studio, export from UML, Earl, or some other relational modeling tool. For this to work, each table must have an INT IDENTITY field named id.

The next step is to get the data into your data model.

<h3>Data Transformation Services (DTS)</h3>

Qrimp is built on top of the Microsoft SQL Server product, so getting data into Qrimp is similar to migrating data between any existing databases. The best way we have found is to use Microsoft's DTS to import the data. Here are a few resources on the Web to help you understand how to use DTS to import your data.
<a href="http://technet.microsoft.com/en-us/library/ms365330(SQL.90).aspx">
Creating a DTS Package with SQL Server 2005</a>

<a href="http://technet.microsoft.com/en-us/library/ms365330.aspx">Creating a DTS Package with SQL Server 2008</a>

<a title="Permanent Link: Data import / export with SQL Server Express using DTS Wizard" rel="bookmark" href="http://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/">Data import / export with SQL Server Express using DTS Wizard</a>

You can download DTS for SQL Server 2005 Express here:
<a href="http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi">http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi</a>

<a href="http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en">Download More Microsoft SQL Server 2005 Express Tools Here</a>
<!--</nobreak>-->		Import Data
deleteedit210Javascript and JQuery in QrimpMake your Qrimp App more dynamic with JavaScript and JQuery.Advanced Development
deleteedit209Advanced DevelopmentThe features in this section will be useful to those with a web development background. Be cautious when implementing these features.
deleteedit208WidgetsYou can also add widgets to your form to create borders around groups of text entry fields or to otherwise spruce it up. Watch the video below for more a demonstration of widgets.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="876" height="728" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-12-05_0209.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-12-05_0209.swf" width="876" height="728" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>		Form Designer
deleteedit207Convert a Field to a Drop-DownTo convert a field to a drop-down (also known as pick-from or look-up table), first go to the table with the field you want to convert and go to Table Management.

<img class="border" src="/attachments/3f1407ef-0b8c-4d3a-bace-966c351ad865/Lookup1.jpg">

Beside the column you wish to convert, click the "Convert to Pick From List" link.

<img class="border" src="/attachments/622bbe93-f4ad-4e7d-b1ab-69b239a2fb7b/Lookup2.png">

You will get a warning pop-up asking you to confirm the change. Click okay. Once you have converted the field, you will notice a magnifying glass in your table management list and a link to the look-up table.

<img class="border" src="/attachments/f60ca418-8cdd-4f9b-8db2-4f5e4ea68c74/Lookup3.png">

As always when adding a new column, use the [form designer] to position the new field in your [Detail View]/[Edit View]/Add New View.		Creating a Look-up Table
deleteedit203HTML<h2>What is HTML?</h2>
HTML stands for Hyper Text Markup Language, it is how web pages are made. Knowledge of HTML will help you modify the way your Qrimp application is displayed, but is not required to use a Qrimp app.

<h2>Working with HTML</h2>
You can see the HTML for any web page by using the Developer Tools in your web browser. You can also right-click and select View Source or View Page Source.

You can use HTML in a Qrimp app when editing records, in the Header/Footer for records, in Views, and in Field Templates. You will need to make sure that your user group has permission to edit HTML (See [User Groups].

Here are some resources to help you learn HTML.
<a href="http://www.w3schools.com/html/">W3C Schools HTML Tutorial</a>
<a href="http://www.w3.org/MarkUp/Guide/">Dave Raggett's Getting Started with HTML</a>
<a href="http://www.echoecho.com/html.htm">EchoEcho.com's HTML Tutorial</a>
<a href="http://www.davesite.com/webstation/html/">Interactive Tutorial for Beginners</a>		Definitions
deleteedit201My AccountEverything you need to know to keep your account running.
deleteedit200Communicate and ShareLearn to use Qrimp for messaging and share data that is in your Qrimp app.
deleteedit199Display and DesignLearn about how to display data in Qrimp and change the look and feel of your application with skins (CSS stylesheets). Change where form fields appear on a page.
deleteedit198Data AnalysisGet deeper insight into your data with queries, reports and charts.
deleteedit197Working with DataThis section explains how to get data into and out of your Qrimp app. You will learn how to add data, delete it, edit it, import it, export it and more.
deleteedit196NavigationThe topics in this section cover how users navigate your Qrimp app. How do users get to your data? Which actions are allowed from which places? Which messages are shown on forms?
deleteedit195Site HeaderThe site header is an area of your Qrimp app that appears near the top of every page and every view. This is where you can find the logo, the login div, and the search bar. If you want to change just the logo, visit the help topic on [Changing the Logo] first.

<h3>Editing the Site Header</h3>
Go to Design > Skins. In the area under "Change Site Header and Footer" marked "Header" enter your HTML content and click save. Be cautious, as any changes you may have entered in the skin above will be lost when you save the site header/footer.

<h3>Replicating Look and Feel with Site Header</h3>
One of the fastest ways give a Qrimp app the same 'look and feel' as an existing site that you wish to migrate to Qrimp, is to copy the content from the page head or banner area near the top of the originating page.

To do this, copy the HTML and CSS from the originating page. If you have footer content, do the same, but copy and paste it into the Footer text box. You will surely have to make a few tweaks to width etc, and pull in any images, but this is a great 'head start'.

<h2>Warning</h2>
Since the site header can include any HTML, there is a chance that you can really disrupt the normal operation of your Qrimp app. For this reason, we strongly recommend you copy the Default Skin into another skin before you make changes. This way, you can make changes outside the normal site that your other users are using. Then, when the Header is working correctly, you can copy it into the Default Skin's Header for everyone else to enjoy too.

If you really break the site header, you can switch back to the Default Skin that works and then delete the new skin you were working on and start over or correct any issues.

If you are copy/pasting HTML from another website, be sure it doesn't include any FORM tags for search forms or other HTML. We recommend you start slowly with only minor changes.
Changing the Look and Feel of Your App
deleteedit194Enabling Google FontsIf you'd like to take your Qrimp app to the next level of design, you'll probably want to add some new fonts. The Google Fonts API
<a href="http://code.google.com/apis/webfonts/">http://code.google.com/apis/webfonts/</a> is the best way to make using more fonts easy!

For Google Fonts to work with IE, you must include a STYLE tag as the first line in the HEAD tag. To do this, we have a custom feature to modify the first line of your Qrimp app's HEAD tag.

This help file will walk you through the steps required to add the ability to modify your head tag.

First, you must add the HeadOptions column to the t_stylesheets table.

Choose Develop > Manage Tables
View System Tables
Find t_stylesheets (id: 16)
Click Edit for that table.
In the Add New Column section, enter headoptions for the column name and choose Single Line Text up to 255 characters as the data type
Click the Add Column button
Stay on this page to continue to the next part of this task.

Second, you need to update the headoptions field for the style sheet for which you want to include extra fonts.

To do that, at the top of the Edit t_stylesheets page, you'll see a link to t_stylesheets with a magnifying glass to the left of it.

Click that link. It will take you to /db.aspx?t=16 and show you a list of your stylesheets.

Click the edit icon (<img src="/images/edit.gif" />) in the row of the stylesheet you want to enable fonts.

Paste the text box below into the headoptions field:
<input type=text value="<style>@import url(http://fonts.googleapis.com/css?family=Smokum);</style>" size=100 />

The code above includes ONLY the Smokum font, you'll need to update the list of fonts to include the fonts you want to add to your site. For example, to include Smokum and Bevan, you'll use the text in the following input:
<input type=text value="<style>@import url(http://fonts.googleapis.com/css?family=Smokum|Bevan);</style>" size=100 />

For more information about creating the proper Google Fonts import link, please visit Google Font's getting started page:
<a href="http://code.google.com/apis/webfonts/docs/getting_started.html">http://code.google.com/apis/webfonts/docs/getting_started.html</a>

Changing the Look and Feel of Your App
deleteedit193Default TemplateWhen you build a database, data can be displayed in different ways. For example, sometimes the data appears in a select box, a table or grid view, and if it is a record related to another one, sometimes it appears on the right hand side when viewing a main record.

Let's say we have a table called Transactions that has many Payments associated with it. When creating a Payment, a select box will appear prompting the user to select a Transaction to associate with the new payment. If, after creating the payment, the transaction selected in the drop down box is viewed, the right hand rail will show a list of Payments associated with the Transaction record.

In this case, Qrimp will try to be smart about how it shows those records in the right hand rail so you can understand exactly which payments those are. Because screen space in the browser is limited, Qrimp chooses just a single piece of information to display. It does this in a particular order:

<ol>
<li>If a field exists in the table called "Name" that data is shown.
<li>If no Name field exists, Qrimp finds the first text field with 100 or fewer characters to represent the record.
<li>If no no text fields with less than 100 characters is found, Qrimp shows the ID for the record.
</ol>

Sometimes this strategy is suboptimal, meaning, you want to "help" Qrimp understand how to present the data to your application's users. To help Qrimp, each table in your database has [Table Settings] which you can use to describe how Qrimp should display the data in it.

There are two fields on the Table Settings page that you can use to tell Qrimp how to display the data, the first is the [default field] which appears near the top of Table Settings Edit screen. If you want Qrimp to display data from only one field in your table in the right hand rail or in select boxes, choose a column in the Default Field drop down.

The Second field is the Default Template, which can be seen near the bottom of the page. If you want to create a template for records in the table that contains information for several columns, use the Default Template.

Continuing from the example above, let's have a Payments table with just the ID, Amount, PaymentDate, and PaymentMethod. The PaymentMethod is a pickfrom the PaymentMethods table. In this table, there is no text field to represent the payments, so we want to create a Default Template using the Payment Amount and the Payment Method. Since the Payment Method is a pick from, we need to use Square Brackets to represent this.

To accomplish our goals, we will create a Default Template as follows:
<noeval><pre>
$[Amount] - [PaymentMethods:[PaymentMethod]]
</pre></noeval>

This use of Square Brackets tells Qrimp, that when displaying a Payment, format the data using a dollar sign, then the Amount of the payment, followed by the name of the payment method used, which is retrieved from the PaymentMethods table using the value in the PaymentMethod field of the particular Payment record.

Table Settings
deleteedit190Embedding Data in your websiteIf you have a hosted website you can use Qrimp as the database to show data on that website using either EMBED code or IFRAMES.

<strong>Using Embeds</strong>
Most savvy web users have seen the embed feature on news, music or video sharing sites. Embed codes contain HTML that links back to a database and pulls in and displays information in other websites. To learn more, visit the [Share Data] help topic.

<strong>Using IFRAMES</strong>

Before you create your IFRAME, write a query string (see [Query String Parameters]) that displays data the way you want it. Then write an IFRAME where the SRC of the IFRAME is the url to your Qrimp database query string. Then copy/paste the IFRAME into your website to display the results.

<strong>Re-sorting the Data in an IFRAME</strong>
When you want to re-sort the data or query it, you can use JavaScript to update the SRC tag of the IFRAME and the results will be redisplayed automatically. For example:

document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&orderby=productcode';

or

document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&orderby=color';

<strong>Searching IFRAMES</strong>
You can search your IFRAMES BY using a query string with search parameters. For example, to search for products where the product name contained the word "vinyl", you'd do something like this:
document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&productnameop=CONTAINS&productnamequery=vinyl';

Communicate and Share
deleteedit189Number FormatsYou can format numbers using square brackets like this:

<textarea>
</noeval>

If you'd like to format 123456 like 123,456 you would use the following code:

<noeval>[formatnumber:<number>[DATA]</number><format>{0:#,###.##}</format>]

</textarea>

Some formats you can use include those listed at the Microsoft Developer Network: <a href="http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx">http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx</a>		Square Brackets
deleteedit188Dependent Select BoxesSometimes it is convenient to allow users of your Qrimp application to filter the items in one select box by choosing an item in another select box. For example, when choosing to examine fuel economy by vehicle, because there are hundreds of different types of cars, you could let your users filter by Make, and then show only the particular models for that make in another box.

In this Help Topic, we will use another example that fits with our Campaign Contributions system, where when choosing a candidate to add a contribution for, you can filter the list by the candidates party. We'll end up with a dependent select box like the image below:
<img src="http://www.qrimp.com/blog/dependent_select_box.png" style='border:solid 1px navy' />

Here is a video that shows the dependent select boxes in action:
<div style='border:solid 1px navy'><object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="322" height="184" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/dependent_select_box_animated.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/dependent_select_box_animated.swf" width="322" height="184" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object></div>

To get started, we will first go to the Add New screen for the Contributions. Notice the default select box has only a list of candidates:
<img src="http://www.qrimp.com/blog/contributions_addnew.png" style='border:solid 1px navy' />

From the add new screen for contributions, select Design > Field Templates:
<img src='http://www.qrimp.com/blog/contributions_field_templates.png' style='border:solid 1px navy' />



Next, we will click the edit icon for the Candidate column. Since we have not modified the template for this field yet, Qrimp has created one for us automatically that looks like this:
<img src="http://www.qrimp.com/blog/default_candidate_field.png" style='border:solid 1px navy' />

To add a select box for Parties that will filter the candidates list, we will edit the field template to look like this:
<img src='http://www.qrimp.com/blog/candidate_field_template_with_filter_by_party.png' style='border:solid 1px navy' />

Notice we have inserted this block of text before the Candidate select box:
<noeval><blockquote style='border:solid 1px navy;background-color:lightgray'></blockquote></noeval>

This tells Qrimp to create a select box that will filter the Candidate select box and show only those candidates where the party is equal to the party we select in the Parties select box.

If we want to hide the Candidates select box until a selection in the Parties select box has been made, we can use code like this:
<noeval><blockquote style='border:solid 1px navy;background-color:lightgray;'> then <span id=Candidate_selectbox>Candidate</span></blockquote></noeval>

The span indicated with the id <strong>Candidate_selectbox</strong> is the location where Qrimp will display the list of candidates in the party that we choose in the Parties box. This example behaves like the video below:

<div style='border:solid 1px navy'><object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="387" height="342" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/dependent_select_box_hide_original_select.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/dependent_select_box_hide_original_select.swf" width="387" height="342" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object></div>

Your final output should be in this format:
<pre>
then <span id='TABLE_WITH_DATA_TO_FILTER_selectbox'>COLUMN_NAME</span>
</pre>
The code above is telling Qrimp to display a SELECT box with data that is used to filter another select box that ultimately has the list of items of which one is the desired selection for the field in this table.

So for example, if you are creating a trouble ticket system for equipment and have 100 pieces of equipment, each with an EquipmentType and you want to make it easy for your users to select just one piece of that equipment, you'd use a command like the following:
<pre>
then <span id='Equipment_selectbox'>Piece of Equipment</span>
</pre>



Field Templates
deleteedit187Creating a Portal with a Chart<a href="db.aspx?t=HelpTopics&vid=11&id=183">Charts</a> and <a href="db.aspx?t=HelpTopics&vid=11&id=57">Reports</a> make good additions to [portals] as they provide a quick overview of your data.

To add a chart to a portal page, first find the chart of your liking. For the example I'm going to use the most expensive zip codes by county year over year. Before you click the Share button don't forget to copy the script inside the text box. (Shown in figure 2)

<img src="https://developer.qrimp.com/attachments/0ab33145-8a74-4cd7-afa6-4ae6242c25fe/Chart8.png">

After you click the Share button it will take you to a Create portal page.

<img src="https://developer.qrimp.com/attachments/4e51b730-94a0-4e0a-abfe-449d93d4af08/Chart9.png">

After you click the create button you need to add it to your portal page which will be located in the [Header/<strong>Footer</strong>].

<img src="https://developer.qrimp.com/attachments/c1a68be3-2753-462f-a0b7-033e49aadf6b/Portal1.png">

After you add the portal subscription it should look like this:

<img src="https://developer.qrimp.com/attachments/d9b65d72-7919-43a1-b619-ceebe16b7dae/Chart10.png">






Dashboard
deleteedit186Retrieving id for new elementsIf you use JavaScript to create a new item, you may want to retrieve the ID of the element just created. To do this, use the _returnresult=true option in the querystring.

For example, submitting a querystring like the following will create a new item in the Person table with a name of Linda.

var id = getUrlString('db.aspx?t=person&name=linda&o=5&_returnresult=true');

You can now use the value in ID to add information to other tables that is related to the person Linda. Like this:

var taskid = getUrlString('db.aspx?t=tasks&name=Register+for+intranet&person=' + id + '&o=5&_returnresult=true');

Javascript and JQuery in Qrimp
deleteedit185Input Security RestrictionsTo add additional security around data Qrimp allows you to add white and black lists.

A Whitelist will only allow the characters specified in the list.

A Blacklist will strip out the characters specified in the list.

To add either functionality to a system the first step is Develop > System Tables.

<img src="/attachments/f4f304ca-0b5b-4e8c-89b1-85ee86b74279/Security5.jpg">

Then click on the t_groups WITHOUT the magnifying glass.

<img src="/attachments/abb21f03-1668-48e8-a0a7-82df4892155f/Security6.png">

To add the additional field to the table click on the Table Management Icon in the [Content Header]

<img src="/attachments/0ea6eb9a-40f6-4f4a-89d3-34398246ec58/S.png">

Scroll down to "Add a Column" and input either inputwhitelist or inputblacklist all one word

<img src="/attachments/d628e2dc-67b7-4906-a578-b097597ea4ba/Security8.png">

Once the column is added there are two steps. First you must log out and log in to make the change take effect. Then go back to the table and click Design > Field Layout to move the field to a usable spot.

It should look like this when complete. Now click the Edit Icon in the [Content Header] enter in the characters that can ONLY be entered. For this example lets say I don't want numbers. I will only include the 26 letters of the alphabet and click save.

<img src="/attachments/651ac779-8356-460b-8f2f-a3b3f84ea600/Security9.png">









The System Tables
deleteedit183ChartsA Help Topic to step through the value of Qrimp's Charts.


In every grid view in your Qrimp Application at the bottom of the data there are a few default buttons.<br><br> <img src="https://developer.qrimp.com/attachments/cd72c5a9-c5c3-4a42-a07f-b473b909f2f6/Charts1.png">

Qrimp does offer a few canned [Reports] but to get your hands dirty with your data Qrimp has Custom and Cross Tab Reports.

When you are in the Grid View, one of the default buttons in the [Content Header] is Reports. If you click on that you will get a screen similar to this <br><br> <img src="https://developer.qrimp.com/attachments/7f9261ba-9fa6-44e0-82ad-30b285b09be9/Charts2.png">

Once you are at this screen you can now see the buttons in the [Content Header] that say Custom and Cross Tab Reports.

Here is an example of a Cross Tab Report. The data is from 2006 and 2007 Most Expensive Zip Codes in the US ranked by Average Median Sale Price. The Report compares the Counties year over year.

<img src="https://developer.qrimp.com/attachments/3333ff85-1242-45a7-b436-92f2a9858993/Chart3.png">

To CHART this Cross Tab report we can go to the bottom of the data and click 'Chart' it will take you to a screen like this.

<img src="https://developer.qrimp.com/attachments/b5afa6f3-8ffc-44cf-9cb3-21646fd50143/Charts4.png">

There are several ways to change the look and feel of your chart.

Lets begin with the Chart Title. The Chart title will appear above the Chart.

<img src="https://developer.qrimp.com/attachments/1df430b9-0290-4316-b0c6-b6e68fce36df/NewChart1.png">

The View Next button allow you to scroll through various charts to represent the data in a different way. Here is the same chart as above after Clicking "View Next". You can also use the Drop Down Menu located to the left of the "View Next" button.

<img src="https://developer.qrimp.com/attachments/38c41591-9509-4a97-acd5-5d01c01a9159/NewChart2.png"

The Show Top field allows for adjust of records you want to see. In the two images below is of the same Chart but different amount of records displayed just by changing the "Show Top" field.

<img src="https://developer.qrimp.com/attachments/0d0cc91d-9f06-464b-adee-28f596656497/NewChart3.png">

<img src="https://developer.qrimp.com/attachments/be27b6fc-3b8d-40c8-b815-276438727ef8/NewChart4.png">

The Order By Column allows you to switch the order by which the graph is displayed. By default it is ascending but the radio button next to the field allows you to order by descending as well. This can be seen in action in the two images below.

<img src="https://developer.qrimp.com/attachments/bb041126-8a51-4ec2-b055-059f51b42e97/NewChart6.png">

<img src="https://developer.qrimp.com/attachments/02b7de26-aaf1-469c-842a-e47299079acb/NewChart5.png">

The Dimensions of the Chart can be changed to make the graph more readable. This might be used if the data set is large and the default width and height need to be expanded. The first image is the default size and the second image changes the width and height to make the graph a little more readable.

<img src="https://developer.qrimp.com/attachments/d76c8817-2e05-480c-ba06-e5090ae0aaa5/NewChart7.png">

<img src="https://developer.qrimp.com/attachments/582b3606-fd4e-47bf-af28-ae24af826bac/NewChart8.png">

Sometimes on the x-axis the labels get jumbled together, like the first image below. To make the graph a little more readable there is a Rotate Names radio button that will rotate the names vertically, like in image two.

<img src="https://developer.qrimp.com/attachments/98044458-6b7b-4ab5-bb41-28cfbfeb1e32/NewChart9.png">

<img src="https://developer.qrimp.com/attachments/a44a29d1-f8d8-4ce2-97ec-6e4063f83ead/NewChart10.png">

The "Animate" radio button adds a little functionality to your Chart. If you check the button and click "Show Chart" it will build the Chart right before your eyes. Watch the video below to see it in action.

<embed src="https://developer.qrimp.com/attachments/f5877535-d760-42e0-9d37-a6853c5f72fa/NewChart11.swf" autostart=false height=500 width=1100 />

Sometimes the graphs don't tell the whole picture. By adding values to a chart the User will know the exact amount. So, by clicking the radio button next to "Show Values" the Values will appear on top of the bars, like in image two.

<img src="https://developer.qrimp.com/attachments/bfcb17e4-5e4c-4342-bf59-5772916a18a6/NewChart11.png">

<img src="https://developer.qrimp.com/attachments/05a2d9bf-e70d-48a7-a139-6d0c06de83ed/NewChart12.png">

To make graphs more readable you can add colors to distinguish between each type of bar. By clicking on the palette a color picker box will appear (image 2) and because I have three different labels I will click three different colors. There is no need to close the box each time.

<img src="https://developer.qrimp.com/attachments/3bcf4f9d-5875-43d0-a24d-430126e28c96/NewChart13.png">

<img src="https://developer.qrimp.com/attachments/b7bd7129-f898-4057-b28d-ce7e99938fe1/NewChart14.png">



<strong>The Share button can be used to add Charts to your Portal page. Here is a help topic that will walk you through the process. [Creating A Portal with a Chart]</strong>		Data Analysis
deleteedit182Adding a User GroupUnder Admin > [User Groups] you will find the default Groups: Administrators, Developers, Testers, Users and Anonymous. To add a new group, click the "Add New" Icon in the [Content Header]. Select the group security permissions you would like the user group to have and click Save.Managing Users
deleteedit181PortalsPortals are windows to your data that appear in boxes on your [dashboard]. Your Dashboard is a collection of portal boxes. Each user must add or subscribe to their own set of portals. A user can either add a portal from the [grid view] or subscribe to a portal.

<img class="border" width="500" src="attachments/developer.qrimp.com-1065e4df-66f4-4bb4-b06a-592170c5c577/severalportals.png" />

<h2>Adding a Portal from Grid View</h2>
To add a portal from the [grid view]:

Go to the table you want to get data from > go to the bottom of the grid view > click the link that says "Share".
<img class="border" width="500" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/2e747ef8-e2cd-4287-a53c-a0bff069e41a-add%20portal%20screen%201.png">
A box will appear with a button that says "Add to Dashboard". Click the Add to Dashboard button.
<img class="border" width="500" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d8b3d7b5-ea0e-41ae-8e7b-f69ff520ecda-add%20portal%20screen%202.png">
Enter a name for your dashboard.
<img class="border" width="500" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/bdc8b545-026b-4fd1-901e-47b4a6c01fa5-add%20portal%20screen%203.png">
Another link will appear that lets you view your dashboard
<img class="border" width="500" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/16d83cf4-6cf0-4ff1-9a22-0658792a4c39-add%20portal%20screen%204.png">
Your portal window has been added.
<img class="border" width="500" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/16ed92a2-04f0-46c2-8de5-037cdb1bd4e4-add%20portal%20screen%205.png">

<h2>Moving Portals</h2>
To move a portal, go to the top right corner of the square. Hover over the icon that looks like two windows <img class="move" src="/c6401/559.png" align="absmiddle" height="16" width="16">". It will turn to a multi-directional arrow <img class="move" src="attachments/developer.qrimp.com-d9b3232d-9b06-4b91-97b4-27c53bbb9207/multi-directionalarrows.png" align="absmiddle" height="16" width="16">. Click and drag the arrow to move the portal to a spot before another portal square. The square you are moving it in front of will turn green.

<h2>Resizing Portals</h2>
To resize a portal, click the magnifying glass icon in the top right <img src="/icons/crystal_project/32x32/actions/viewmag.png" />. You can change it to be large, small or medium.

<h2>Customize Portal Background Colors</h2>
To choose a new background color for a portal, click the palette icon in the top right <img src="/icons/crystal_project/32x32/apps/colors.png" />. Different colors can help you quickly find data that looks the same.

<h2>Advanced: Manually Editing Portals</h2>
To edit a portal, click on the edit icon in the top right corner of the square <img src="/icons/crystal_project/32x32/apps/kate.png" />. This will take you to the edit view of that portal in the Portals table. Note: You can see all of the records in the portals table by going to Design > Portals.

Name: The Name of your portal window. Use a name that describes which data will appear in the portal and how it will appear. For example "Logins by Date", "Unpaid Bills" or "Red Shoes - Thumbnail images". The name you choose will appear in the header of the portal.

Description: Describe your portal to help you remember what it's about.

Template: Copy and paste a [ShareData] script. The ShareData script is much like an embed tag. It links to your data, storing the table id, the sort on your data, search information, hiddencolumns and whatever else you tell it to. Advanced: add styles to your portals by using inline styles in the template field.

Link: The Portal Link specifies where the user will go if they click on the portal header.

<h2>Deleting Portals</h2>
To delete a portal from your home page, click the red X in the top left hand corner. You will be unsubscribed. To resubscribe, simply go to Home and find the link in the top left of the page that says "Add Portal".		Dashboard
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing