Hello,
I am new to VBA and have searched for various websites about comparing cells in two worksheets and displaying the rows that are different in a 3rd sheet. I can easily do this in vlookup see but I would like to do it via a command button. Other websites used integers as examples however I...
I tried this .. but it prompts me that a boolean is required...
If isnull({HPD_Help_Desk.Generic Categorization Tier 1})
then
"No Data"
else
{HPD_Help_Desk.Generic Categorization Tier 1}
your help is greatly appreciated
tubb
Hello I am looking to create a cross tab based on the following
1. The count on items that do not have a particular item.
I was able to get the count on a field that did have information, BUT NOT ON THE COUNT THAT DID NOT HAVE INFORMATION.
so i want a cross tab that displays the number of...
I am using crystal v10. and i want to make my report run from every wednesday to wednesday.
it consists of this
{HPD_HelpDesk.Create Time} >= CurrentDate-7
and
time({HPD_HelpDesk.Create Time}) in time(16,0,0) to time(23,59,59)
But I want to set up such that it runs every wednesday to...
OMG I THINK THAT WAS THE PROBLEM... OMG!!! THANK U SO MUCHHH IN WORKED... U ARE THE BEST.
YOUR HELP IS MUCH APPRECIATED!!!
I HAD A PREVIOUS THREAD BUT IT WASN'T ANSWERED PROPERLY
!!
THANKS SO MUCH
-TUBBY
How do i create a time interval in crystal v10.
I have the following
{HPD_HelpDesk.Create Time} >= DateTime (CurrentDate-7, Time(16, 00, 00 ) )
This results in all the data seven days before today's date AFTER or equal to 4.
BUT
I WANT data from seven days ago from 4 to 12..
every day..
for...
i went ahead and changed the previous entry to the following
{HPD_HelpDesk.Create Time} >= currentdate-7
in [Time(4) to Time(12)]
... it says that a boolean array is needed now.
i also tried
{HPD_HelpDesk.Create Time} >= currentdate-7
and Time ({HPD_HelpDesk.Create Time}) in [Time(4) to...
I went ahead and changed [4 to 12] to [16 to 00] as i felt that perhaps that was the problem. but it still prompts "time range is needed"...
is there anything that can be done to fix this problem?
your help is much appreciated
-tubby
Madawc
I'm using Crystal v10.. So i went ahead and used the first formula you gave me.. But.. an error message pops up saying that a date time is required in [4 to 12]
{HPD_HelpDesk.Create Time} >= currentdate-7
and
Time({HPD_HelpDesk.Create Time}) in [4 to 12]
Hello I would like some help in creating a report that results the following requirements:
1. Displays results From Wednesday to Wednesday from 4PM -12 PM only.
I have created a prompt with I cannot use and I would like some help in how to go about this..
I had chosen in Select Expert...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.