Search results for query: *

I have a script, see code below, that gets the variables from a program that the script is run from. The variable MARKET contains an array of market names (5 to be exact). The first two steps in the script work perfect but when I get to the for loop it starts working great on the first pass...

Running XP Pro with Access 2003 Where can I get the Access 2003 Developer Extensions? I have searched all over Microsoft's website for answers to creating a runtime version of my db but I can't find anything with instructions. Does anyone have anything that's straightforward in creating a...

Hi all! I'm using CR10 with an Oracle db. I'm havning a problem figuring out how to get this done. I am trying to pull a small amount of data that looks in the previous 4 rolling quarters, excluding the current quarter. I only need the previous 4 full quarters data, no partial quarters. The...

Hi all! I am running Crystal 8.5 with ODBC to an Oracle DB through a Citrix connection. Will be getting version 10 soon. I have a formula that is trying to get the correct units. Sometimes there will be multiple entries and the same units will be in the databases units field. The software...

Running v8.5 on XP connecting to an Oracle database. I have a formula that is totaling most of the data correctly. I am trying to take the total from the previous quarter, 20062, and multiply that result to get the estimated total for the current quarter, 20063. The quarters are string...

Running v8.5 on XP connecting to an Oracle database. I have a formula that is totaling most of the data correctly. I am trying to take the total from the previous quarter, 20062, and multiply that result to get the estimated total for the current quarter, 20063. The quarters are string...

Happy Pre New Year Everyone!! I am running Crystal 8.5 (not my choice) pulling from an Oracle database. I have a crosstab that has @Family as the Row and Quarter as the Column. The Summary is a formula that adds different formulas, dollar amounts, together based on criteria in each @Family...

I am running CR10 pulling from a SQL Svr. I have a cross tab that I have set up and I want to surppress specific data from coming over into the cross tab. Example: I am pulling State, Program and Label for the Rows and the Quarters for the Columns. Then I have the Total payments for the...

Running an Access 2000 database on Windows XP. I am trying to export a table in text format and I want to keep the same number formats as are in the table. But when I do the export it drops any ending zeros off of the numbers. Two of the fields have numbers that I need to go out to 7 and 6...

How can I disable Excel's Autosave programaticaly? With code that I can put in the spreadsheet whenever it is opened? I don't want to have to turn it off via Excel as this is too much of a problem for the 10 users that touch the spreadsheet. We are running Excel on several citrix servers and...

How can I disable Excel's Autosave programaticaly? With code that I can put in the spreadsheet whenever it is opened? I don't want to have to turn it off via Excel as this is too much of a problem for the 10 users that touch the spreadsheet. We are running Excel on several citrix servers and...

Running Crystal Reports 10. I have a program that stores data on a SQL server. The program also generates an access database when a user requests it, with aging data for a finance dept. I am having a problem getting the same data from the SQL server and would like to use the data put into the...

Am I missing something in Crystal 10? I am trying to print the database name and location on a report but cannot figure this out. Example: "c:/temp/database.mdb" Any ideas? Running Crystal Reports 10 on WinXP Pro, acccessing databases over a network. Thanks, John

Hi all, I am running Win98 w/ Crystal 8.5. Question: Is there a way to create a formula for sorting? I have a report that has 2 parameters that you have to choose in order to get data. Param1 is the table.PaymentDate range. Param2 is the table.FinancialClass. The data is pulled by these two...

Hi Everyone! I am running Crystal 8.5 and pulling data from a MS Access 2000 database. I am having a problem pulling all of the data that I need. I have a report that is pulling patient data and I went and added a 3 more fields of data to pull if the data is there. Before I added these 3...

Hi! Running CRW 8.0 Developer and pulling from MS Access 2000. I have a report that I am trying to selectively exclude specific data from two particular groups (billing errors and coding issues) within the report. There is a total of 6 different groups (I mean in preview, not design). I am...

I have a problem with my grouping and needing to suppress certain data. There are too many codes to enter into Select Expert but can be done. Using CR 8.0 on Win98<-(don't ask) I am trying to suppress certain data from my groupings. I have two groups that I need specific data suppressed from...

Hi All, I got this formula from Synapsevampire and wanted to know how I would be able to show the actual start and end date of the particular week? For example: Jan. 12, 2004 to Jan. 18, 2004. BTW: Thanks Synapse for the formula! synapsevampire (Programmer) Jun 18, 2002 Here's one way...

Hi all! Running CR8.0 and accessing MS Access DB through ODBC. I have a duplicate problem here is the data and then I will explain the issue. Grouped by: Denial Code denial_code T3000 Detail Section: Acct_Num Total_Charges Acct_Bal D1234567890 $5,000.00 $500.00 D0789456123...