Search results for query: *

I have a primary table, with everything, I have SQL commands I have created, and run fine, but because of the prompting and dates, do not contain everything. So the math is simple,, beginning balance(primary file) - Sales(sql command), +/- adjust, transfer, crushing(sql command). What I see is...

ok,, our older cllient access worked for the Vista PCs, but will not work for the windows 7 PCs, we are starting to get in. On the AS400 we are still at R5V2. We have migrated from the Edwards World to a SQL based software. But I still need to maintain connectivity to the Green Screen.. I can...

have a file on our vcadmin machine,, taking up lots of gigs.. how do I reduce size, of get rid of?? Looks like the version of the center is 2.5.0.. Ideas, Questions, Answers??? Looks like sone sort of MSSQL file, not sure though..

how is ESX 3.5 for supporting 64 bit 2008 server and 2008 sql,, one of the tech build a VM,, and now it wants to lock up all the time? Ideas????

throw this out,, for consideration,, one of the "techs", here at work, is building on the ESX VM's a 2008 server,, with a 2008 sql,, both 64 bits. Now that ths=e sql is installed on the server,, it "locks up",, all the time.. ideas??? Anyone run into this before??? I believe the ESX is 3.5..

Using a Group header line like a "level break", in RPG. Had to say that for all the AS400 people out there.. So how do I supress the printing of the line,, when a calculated value ,, using group summary values,, is 0.00.. or a given range of values. Say anything from -.09 to +.09. Ideas,, I...

OK I have a meter readings file, to keep it simple. Date and meter reading. So I got say 6 records,, How on the crystal report do I calculate the difference,,from one meter reading to the next.. file would look like this 2009/01/01 123456 2009/02/01 123987...

OK,, I have a one byte field in a file, Crystal XI R2, is treating it as a string. It is coming from a SQL 2005 database. I want a formula that say use this record if this field is "null". Nulls are set to default values for nulls in the formula editor. When I look in sql manager it says "null"...

My head is going round and round, and the room is getting dark,, I have been web searching for "how", to email scheduled reports out of Crystal and into Lotus Notes.. I have a bunch of clues,,, but I myself am "clueless".. has anyone ever doen this.. and how dod you do it?? Thanks in advance. Jim

ok first this is not my formula. stringvar x := {PM_EMPMASTER.BIRTH_DATE}; datevar birth := date(val(left(x,4)),val(mid(x,5,2)),val(right(x,2))); DateVar Ann := jdyear; // Replace this with CurrentDate to get their age as of the time of the report...

OK,, I have the "designer", on my machine. I map a drive to where the DBF files are located, and can write and run reports. How do I translate this connectivity to the Enterprise Web Server. No password is required, it is a "flat DBF file", I have an ODBC setup on the Enterprise machine. It is...

We have a birthday list for the H/R department. I have the date borken so that I can group based on month, and then day. stringvar x := {PM_EMPMASTER.BIRTH_DATE}; datevar birth := date(val(left(x,4)),val(mid(x,5,2)),val(right(x,2))); Month (birth) This is my formula to get the month. Is it...

OK I found the formula to calculate a person's age,, using a field that is defined as a date. But I have a field that is defined as a string,, how can I conver it to a date?? my sting has 20080101,, for it's value,, for example this is the formula I am trying to figure out,, DateValue...

I have an 8 byte string data field that is actually a date,, an example would be 20080101. How do I get that to display in a pretty way,, example would be 2008/01/01. Everything is a formula in Crystal,,so I assume this is also,, but I cannot find a clue anywhere, on how to do this.. everything...

Since this is the formula form,, I need a formula to do A/R - Accounts Receivable ageing.. I have looked at the 0to30 age function, but when I write my formula I get an error. It highlights the function and says it expects a sting value.. Does mean that my value I am trying to age is not a...

OK guys,, I am using Crystal XI, release 2. It has functions for the standard A/R ageing,, I need the syntax, on how to use them. I need to create several formulas and add the invoice amount into the correct field, based on the ageing,, pretty standard stuff,, but I do not know how to use the...

OK in sql 2000 I would know, how,, but not in 2005. I need to setup a login for SQL. I need to give it acess to one database, and one database only. This does not need to be a user from our AD. I will use this login to connect the crystal reports web server.

From the look of this error,, It says it cannot run this report, because the database will not let me logon. This is a brand new installation, NO,, I do not know if everything has been installed correctly. I know that I have setup the login thru the web, to use windows AD,, and that does work...

OK here is what I would like to do,, we will be using a sofware, where you can add custom buttons to a "toolbar".. One of the buttons I want to add, is a link to IE, and then open a specific web page (ie crystal reports via web). How do I pass the url to IE, so it opens at the correct Webpage...

My daughter is running XP Media center,,, all (yahoo, and icq) her IM work,, but she cannot get a web page. Started this morning, after some kind of automatic update came down,, had the windows needs to restart, message this morning. It is running on an HP laptop, wireless her ip addrsss is...