Search results for query: *

Shaminda. I have written a crystal reports viewer (compiled as an executable) but sorry I am not willing to give it out for free. I spent some considerable time creating it. If you are interested please let me know and I would be willing to send you it with source for a small fee. Jon

In my vb application I have created a crystal viewer... I allow the end user to select a customer from my own combo box in the application..and I do the following vb code 'Proposals report Case "rptProposalInfo" If frmReports.cboRptQuoteNumbers.Text = "" Then 'no quote...

thank you

You can write your own scheduler in vb as well. This is the route I have taken and then simply include it in your windows scheduler as a task (allowing for date and time to process this). If you need more help on this let me know. Jon

No I dont want = or >= or <=....I want "in" that is not the issue. I will try ken's recommendation. Thanks, Jon

In my select expert I need to include a lot of conditions... but its not working..or it works on some and not all... Here it is: {TBLLABOR.ACTDATESTART} in {?Start Date} and if {?FunctionalGroup} = "" then True else {TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and...

But I dont want to suppress the employee... I have a group ACTDATESTART that is done by week... so it may do the following: Engineering Jon Smith Week 7 Week 8 Week 9 Joe Blow Week 7...

I'm doing a report on labor hours by week. I select a date range and it does it by week...but for instance I select Feb 16 till March 8 and it shows week 7,8,9,10...I want to skip week 7 for EVERY employee...but I cant. I tried to suppress on that section using: OnFirstRecord but it only works...

Thanks, Jon

We had a contractor a long time ago come in and create this wonderful beautiful report which showed labor hours by date range. The problem is it totals all the hours for Monday, Tuesday, etc. For instance I choose Jan 1, 2004 till Feb 1, 2004 as a parameter entry. It gives me the total hours...

This is crystal 9. how do I ensure they support unicode. Jon

I've noticed anytime we print to a certain printer in Crystal it comes out very bad. It is not readable text. The numbers come out right, but the text itself is VERY bad...It looks like another language almost... The drivers are installed on the client. What could be causing this? Jon

nevermind i recreated it. jon

I decided to record the problem. Can anyone check out this link please I would be most greatful. http://www.jakrauseinc.com/jhermiz/problem.avi Thanks, Jon

Forgot to mention even after I save it and reopen the code CHANGES back to: if IsNull ({TBLEMPLOYEE.LABORCODE}) then 0 else if {dbo_TBLEMPLOYEE.LABORCODE} <> "CON" then -3 else if {dbo_TBLEMPLOYEE.LABORCODE} = "CON" then -2 else 0 ... I dont even have a GROUP called Order that is what is...

wow... so how do i fix this... i noticed something as well...everytime i try to open the report..i get that message above..then when i hit the lightning bolt the icon at the top I get: This field name is not known It takes me to the formula editor where the code is: if IsNull...

Everytime I open this one report I have I get "The Saved Data Will Be Discarded Since One or more formulas failed to compile." But I compiled all my formulas with NO errors... I need to get rid of this message. Jon

Wow... I changed it to this: (if {?EmpName} = "" then True else {dbo_TBLEMPLOYEE.LNAME} = {?EmpName}) and if {?FunctionalGroup} = "" then True //{dbo_TBLEMPLOYEE.DEPARTMENT} <> ".." //or something it will never equal else {dbo_TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and...

I changed it to this: if {?FunctionalGroup} = "" then True //{dbo_TBLEMPLOYEE.DEPARTMENT} <> ".." //or something it will never equal else {dbo_TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and (if {?EmpName} = "" then True else {dbo_TBLEMPLOYEE.LNAME} = {?EmpName}) and...

This doesnt work!! If {?EmpName} = "" then {dbo_TBLEMPLOYEE.LNAME} <> ".." else {dbo_TBLEMPLOYEE.LNAME} = {?EmpName} and if {?FunctionalGroup} = "" then {dbo_TBLEMPLOYEE.DEPARTMENT} <> ".." //or something it will never equal else {dbo_TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and...