Search results for query: *

Hi John, Thanks for the reply and feedback, really appreciate the advice you have given. Look at those areas now and hope to make this work properly. Thanks again Bill

Hello, Looking for advice on this issue as it is new for us/me and learning how to work on managing a project as this is a temporary task and my MD knows I have no formal experience, but need to step in until we can find the appropriate individual for the job. Currently working on a project...

Hi, Have sorted out my issue now, reinstall Crystal fix. Applied the Running Total and works the way I need. Thanks for the help on this LB. Cheers Bill

Hi LB, I understand exactly what your saying, still have an issue with the software, so will have to uninstall and reinstall to see if issue is fixed. I have tried on another computer and works fine. Thanks again for the help. Bill

Hi LB, Thanks for reply, working on this now, it makes sense to me now and not look at it that way. Do have other Running Total formulas in the report, did not think to use it that way. While this can be used, having an issue at this moment with Crystal crashing when trying to pull the Running...

Need help on how to remove a duplicated line that is adding up in my total figure. Example of the data: Date Part No Sales Order Work Order Pcs/Min Total Time 12/12/11 123456 789102 654321 25 480 12/12/11 123456 789102 123456 25 480 My total...

Hello, Have a problem to figure out on how to write the formula properly to change my font on a string indicator field. Not sure how the proper format is on this one as I can get other fields to change font color by using the following: if {Part.Stored_Qty} < {SO_Items.Qty} then CrRed Else...

Thanks to both for the input, will start looking for the best way, I do like learning new ways, hope I can accomplish it. Cheers Bill

So with the database that my data resides in, which is Magic e-developer and I could use ODBC connection instead. I only am using the CR because it was recommended to me when I started using our Magic program. So I know CR pretty well, just easier for me. I would like to learn Pivot tables...

Okay, maybe why I have not had any replies since I posted. Knowing the difference btwn the different types of coding would have helped, feel a bit ignorant, but just starting out. Not realized there were that many different code development using similar names, so have much to learn. This is...

Hi Skip, Really appreciate the response, originally was going to use VB Script, then tried in Excel VB. I have briefly thought about using pivot table, just was not sure if I could get the same results. I might need a little coaching, using Excel 2007 and have done a little bit of...

Hi, I have been trying to create a Excel VB report from a Crystal Reports X program but not having a lot of success. I am new to Visual Basic and trying to learn this new program, Here are the details of my data: I have data importing first into my Crystal Reports X to give me sales history...

Hi Dell, I have done the Grouping and understand I can't export differently than what I already have, done that and tried to look at a way to give Sales what they wanted. Where you able to look at the 2 reports, Excel export report and the crystal report? Do you understand what I am trying to...

Hi, I have been trying to create a report but not having a lot of success. Here are the details: Crystal Reports X for reporting. My VB experience is limited. I have created a report with 3 Group Headers: Customer (Group) Date (Group) Part No. (Group) The detail data is as follows from...

Hello Skip, Thanks for the reply, this is very informative and interesting and will try my hand at a few variations in my sheet. Thanks again for the help. Cheers Bill

Hi, Sorry found what it meant by looking a little harder and realize it is one of the worksheets in the dashboard file. It points to that worksheet location, appologies for asking an obvious question and overlook something so simple. Regards Bill

I am working on a template excel spreadsheet where the purpose is to build a dashboard for our KPI's. I am a little rusty on some formula meanings and don't understand one of the formulas in this dashboard. So the question is trying to understand the total meaning of this and hope someone can...

Thanks Turkbear, Have tried the services and did not help, so now speaking with Pervasive Support. Thanks again for the help. Bill

Can someone help me determine what to check when I have an error like this. we are using Pervasive PSQL v9 SP2 for a database in our eDeveloper Magic 9.4 software. I have had to reinstall Pervasive and Crystal 9 on my Dell laptop. When trying to set the database in my Crystal report I recieve...

Hello Ian, Thanks for the help on this, I will try this now and get back to you whether it works for me or not. Cheers Bill