Search results for query: *

Good afternoon, Using Crystal 10 & Cache DB. I want to print a full page of mailing labels for each record that is pulled. The label sheet is 20 x 4, thus I want 80 copies of the same label. What is the simplest way to do this? TIA, Mark

Good afternoon, Crystal 10 Intersystems Cache Database I currently have a report that has a detail line that contains better than 40 fields. The detail line alone spans 3 pages. Roughly, it is every field in the table in this format: Address: 123 Any Street City: Any...

Good afternoon, Using: SQL Server 2k5, Cache v.5 I have tables in Cache that I want to import into SQL Server. My problem is that my SQL server is on a different server than Cache. I can see all of the Windows servers from within the Import Wizard in SQL, but I cannot see the Unix server...

Good afternoon, I am using SQL Server 2005 and Cache v5. I am trying to import tables from Cache into SQL Server. I have worked with this before, but the last version of SQL I used was more friendly. I cannot find a way for the import wizard to see the Intersystems Cache ODBC connection. Is...

Good morning, Software: Excel 2003 Database: Intersystems Cache Here is what I want to do: I have an application that is tied to a Cache database. I will launch an Excel spreadsheet from within the application. The user will modify some fields that need to be passed back to certain fields...

Good afternoon, Using Crystal 10, Cache database. I have a parameter field that is looking at a numeric ID field. I want to have default values, however, since there are new records created daily, I need the 'Default Values' to update automatically. Right now, the users would have to know...

Good afternoon, My report has 1 subreport in the Report Footer b. I need to be able to supress the page header for the pages that contain the subreport. Right now, at the end of the report, I get the page heading from the first few pages, but the data from the subreport. I know there has to...

Good afternoon, I am having a problem with a FOR loop returning a True/False value instead of the value that I need. the code: for counter := 1 to 70 do ( if field = array_variable[counter] then ( "success"; exit for; ) I would think that if the field finds a match...

Good afternoon, I currently have a formula with the following code: stringvar code1 := {history.code_authorized_1}; numbervar counter; numbervar subscript; stringvar array cpt_code := [filled with 70 data elements]; stringvar array code_value := [filled with 70 data elements]; for counter...

Good morning, I am trying to generate a ratio between the totals of a group. I am grouping on field AUTHORIZATION. I have a total that counts all of the AUTHORIZATIONS. (the data can be Approved, Pending, Denied) I want to generate a ratio of denied to approved. example: Totals are: Approved...

Ok, first I'll apologize if there's been anything like this on here before, but I did not have any idea where to start looking. I have a table that has 80 fields that correspond to each other (ex: Code_Authorized_1 - Authorized_units_1; Code_Authorized_2 - Authorized_units_2). I am creating...

I apologize if this has already been answered, but I did not see any questions regarding my issue. Being a newbie to MS SQL, I am in need of finding a way to encapsualte the filters in my WHERE clause. An Example: WHERE (Table1.field2 < Table2.field7 or Table3.field3 is null) and...

Good afternoon, I apologize for having to write this question...I'm sure it's been answered here before, but I didn't find it... I am in need of help writing a stored procedure. I need to collect data from 3 tables for a report. I always thought that I could run a stored procedure w/o having...

Good morning, I have SQL Server V.8 installed locally on my workstation. When I first installed it, I had no problems accessing the local server (my machine). This was about 4 months ago. Now, whenever I try to start up the SQL Server, I get the following: "An error 1069 - (The service did...

Good morning, I have an application that contains multiple Crystal Reports that are displayed via the Crystal Viewer. The majority of the reports run & print properly, however, in the past month, some of the reports don't want to print. Here are the steps: 1 - Open third-party software 2 -...

I have a customized template to which I have added more pages. It contains a macro that allows the user to enter a name and client number, and will then populate this field throughout the document. The problem is that when the template is opened (to create a new document), after the macro is...

Good morning, I am attempting to use my workstation as the server for a test DB in SQL 8, however, I am unsure of what I need to do to make it happen. I have done this once before at a previous job, but cannot figure out what I did. More info: I want to create a test DB on my workstation...

Good afternoon, First, I'll apologize if this question has been covered. I've looked, but haven't found an answer that I thought would suit the problem. I have an Access DB w/ 37000+ records. I need to perform the following on each of the records: If Field1 like "*&2&*" then Field2 = "New...

I am having a problem trying to figure out how the localtime function works. I have researched the forum, and some other resources, but I don't understand how to format the date when inserting it into a variable. Here's what I'm trying to do: When a record is created via the Perl program, I...

I am looking for a way to have the Group Tree displayed for the entire report. Thus far, when the report is run, it will only show the data from the regular report, the subreport data will not show up in the tree. Any ideas on how to make the subreport data show up in the tree? This normally...