You have helped me create the reports I wanted and I thought I was done, but when I went to enter the email column to my reports the report hangs and shows a blank screen.

I thought it was the email field - so I deleted: C.cb_repemail As Email and the search worked. I tried another column with email addresses and that didn't work either.
Any ideas why I can't produce an email column for my reports?
Thank you so much for your help,
Tasha


Here is my report:
SELECT
C.cb_businessname AS Business,
C.firstname AS FirstName,
C.lastname AS LastName,
C.cb_reptype As Rep,
C.cb_subs_inv_address_street AS Address,
C.cb_subs_inv_address_city AS City,
C.cb_subs_inv_address_state AS State,
C.cb_subs_inv_address_zip AS Zip,
C.cb_phone As Phone,
C.cb_repemail As Email,
C.user_id As ID,
S.expiry_date As Date,
S.plan_id AS Plan,
S.user_id AS ID,
P.name AS PlanName,P.rate AS Rate
FROM
jml_comprofiler C INNER JOIN jml_cbsubs_subscriptions S
ON C.user_id = S.user_id
INNER JOIN jml_cbsubs_plans P
ON P.id = S.plan_id
WHERE
({$REQUEST:start|empty:''} = '' OR S.expiry_date >= {$REQUEST:start|empty:''})
AND
({$REQUEST:End|empty:''} = '' OR S.expiry_date < {$REQUEST:End|empty:''})

Try to disable "Content - Email Cloak" plugin.

Regards,
ARI Soft

Thank you! Of course that worked perfectly!
I then found that I could leave the cloaking plugin on and put:
{emailcloak=off}
in the article.
This allowed the table to display the emails and left the rest of my site with email cloaking on.
Thank you so much for your help,
Tasha