Propecia Cost, Every e-commerce business is unique and AspDotNetStorefront's built in reports often fall short of the reporting you need.

In this article we'll show you how to build your own custom reports in using SQL queries in AspDotNetStorefront.

To find the Custom Reports page in the AspDotNetStorefront backend, Propecia photos, go to "Orders" --> "Reports" --> "Custom Report." Don't worry, unless you've created a custom report the drop-down window will be empty.

Just because this feature is located in the "Orders" section of the admin you don't have to limit your reports specifically to orders. In fact, order Propecia online overnight delivery no prescription, you can display almost any data that lives in your database.

For example, if you wanted the email address, name & phone number of all customers that said "Yes" to the "Okay to Contact" question when they registered, you could create a custom report, Propecia Cost.

How to Create Your Custom Report

First thing you do is open up your database in SQL Server Management Studio. Propecia brand name, Run a query normally and display the result set:

SELECT CustomerID, Email, FirstName + ' ' + LastName AS Name, Phone FROM Customer WHERE OkToEmail = 1 AND Deleted = 0 AND IsRegistered = 1

Once you are happy with your result set, online Propecia without a prescription, you will build the following SQL query:

INSERT INTO CustomReport (Name, Description, Propecia class, SQLCommand)
VALUES ('Title of Report', 'Brief description of report.', 'Your SQL query goes here')

When we replace the values it should look something like this:

INSERT INTO CustomReport (Name, Description, order Propecia from United States pharmacy, SQLCommand) VALUES ('Customers to Contact', 'These are the customers that we can contact with promotions and specials.', Propecia samples, 'SELECT CustomerID, Email, FirstName + ' ' + LastName AS Name, Phone FROM Customer WHERE OkToEmail = 1 AND Deleted = 0 AND IsRegistered = 1')

If you copied and pasted this query and ran it, Propecia treatment, it would cause errors because we are placing a SQL statement in an SQL statement. First we must escape out the single quotes. Propecia blogs, In MS SQL, to escape a single quote add another single quote. So our query should look like this:

Propecia Cost, INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Customers to Contact', 'These are the customers that we can contact with promotions and specials.', 'Select CustomerID, Email, FirstName + '' '' + LastName as Name, Phone From Customer WHERE OkToEmail = 1 AND Deleted = 0 AND IsRegistered = 1')

Custom reports can also help you solve your content management problems.

For example, let’s say for the past year you have been marking products as "unpublished" when you do not plan to order a shipment of it for awhile, Propecia street price.

You have over 3,000 products in the system and things have gotten out of hand. Buy Propecia online no prescription, You want to go through and permanently delete the products you have unpublished and do not plan on carrying in stock again.

Wouldn’t it be nice to have a report with a list of all of the unpublished products in the system. Create a Custom Report, Propecia Cost.

Your SQL:

SELECT ProductID, SKU, Propecia trusted pharmacy reviews, Name FROM Product WHERE published = 0

Your Custom Report SQL:

INSERT INTO CustomReport (Name, Description, Propecia online cod, SQLCommand)
VALUES ('Unpublished Products', 'All unpublished products in the system', 'SELECT ProductID, SKU, Propecia pharmacy, Name FROM Product WHERE published = 0')

To create your report, there are two ways to do it:

• Open up SQL Server management studio, Japan, craiglist, ebay, overseas, paypal, then copy and paste your query into a "New Query."


• In the admin backend go "Configuration" > "Advanced" > "Run SQL." In older versions the Advanced menu will be under "Misc." Copy and paste your SQL, then click "Submit."


• Reset Cache.

Go back to Custom Reports in the admin backend. You will see your new report in the dropdown.

Have you built a custom report. How do you use custom reports in AspDotNetStorefront. .

Similar posts: Celebrex No Rx. Zithromax Over The Counter. Purchase Prednisolone. Where to buy Prozac. Japan, craiglist, ebay, overseas, paypal. Comprar en línea Lasix, comprar Lasix baratos.
Trackbacks from: Propecia Cost. Propecia Cost. Propecia Cost. Buy Propecia without prescription. Propecia images. Propecia no rx.

Tags: Coder's Corner, custom reports in aspdotnetstorefront

This entry was posted on Tuesday, August 4th, 2009 at 4:16 pm and is filed under AspDotNetStoreFront, Coder's Corner, Tips & Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.