Hi!
I think I'm close, but can't seem to make the final piece fit. I have a column with months and days (birthday) I want to run a report where the user can put in the month and a date range and pull the month and date range for the birthdays.

This is what I have so far for my article:
<form action="#" method="post">
Month:<input name="start" type="cb_birthmonth" /><br />
Day Start:<input name="start2" type="cb_birthd" /><br />
Day End:<input name="End2" type="cb_birthd" /><br />
<input type="submit" />&nbsp;</form>

This is what I have for my query:
SELECT firstname AS FirstName, lastname AS LastName,
cb_birthmonth AS BirthMonth, cb_birthd AS BirthDay
FROM
joom_comprofiler
WHERE
({$REQUEST:start|empty:''} = '' OR cb_birthmonth >= {$REQUEST:start|empty:''}) AND
({$REQUEST:start2|empty:''} = '' OR cb_birthd < {$REQUEST:End2|empty:''})
ORDER by cb_birthd ASC


You helped me before figure out the start|end, but I think I have messed it up. Any help is greatly appreciated.
Thanks!

Hello,

Try the following query:



Regards,
ARI Soft

Thank you! Thank you ! Thank you!

One last questions
Is there a way to remove the search box in the top of the table and the "Showing entries" at the bottom of the table and still have a nice looking table?
Thanks!

Add the following code to "CSS Styles" parameter in module settings:

{$id}_filter {display:none}

and set "Choose table type -> ARI Data Table -> Table information" parameter to "No".

Regards,
ARI Soft

Thank you!
Always one last thing with me
Sorry.

I have my report and it runs great as an article in the front end of the website for registered users. Is there a way to put the article in the administrator - or back end of the website in the Cpanel or on a dropdown menu?

I've tried in the admin adding a custom HTML module to the Cpanl and the I can see the text, but it doesn't pull any data. I've tried with only pulling the data and not any request fields, and that didn't work either.

Any thoughts or ideas?
Thank you so much!

"ARI Data Tables" is a frontend extension.

Regards,
ARI Soft