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...

I have created a System DSN and it is resident on the physical box... Thanks, Mark

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...

Please allow me to follow up on this.... The external application that we use changes the parameter and allows the dropdown, it does not do this within Crystal. I'm not sure exactly whay the application does this, but it did solve my situation... Mark

Thanks for the replies. I have actually found another option. In the 'Edit Parameter Field' screen, under the prompting text, I used an sql query and it updates the dropdown automatically. The statement looks like this: Select ID To Display [SELECT DISTINCT ClientID FROM client_table] There...

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...

When you say add code to report footer a, are you talking about in the Section Expert?

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...

Tell me if this part of the code should have caused the problem: (just ammend this to what I've already submitted) local stringvar code1 := tablename.field1; local stringvar code2 := tablename.field2; When I commented out the second declared variable, it works fine, if I left the variable...

Actually, I just found the problem. With the nature of our databases, this, to me, is a strange occurence, but tends to be a normal situation for us. I was hard-coding the code assignment: local stringvar code := tablename.value; It did not like this because there was at least 1 record that...

Here is the code as modified: local stringvar code1 := trim({history_member_auths.code_authorized_1}); local numbervar counter := 1; local stringvar code := "fail"; local stringvar array cpt_code := [array populated]; local stringvar array code_value := [array populated]; for counter := 1 to...

synapsevampire, Everything in our system is entered in uppercase, but I added it and it made no change. Also, after the loop, I added the if to display when the variable assignment failed. It never displayed 'not found' I appreciate everyone's help on this. Thanks, Mark

lbass, Yes, however, there are some values that do have a colon within the actual codes ("8765:HL"), but other than that, the arrays look like what you've described. Mark

Turkbear, Funny you would say that. There is actually a lookup table that we can use. However, the main table is a history table with many iterations and if we link to the lookup table, the report will crash every time. Our database is on a Sun server and if I run the report with that table...

Turkbear, The arrays are comma quote delimited in the assignment. However, some of the codes do have colons in the actual value. ["1234","1237","1236:HL"...] If I reference a specific subscript for the array, I do get the correct value. Mark

The fields are string 50 in the database and can contain alpha & alphanumeric (either or both), so I can't really compare the values. The example I gave was just a quick description. Mark

Ok, here's the code. I had to removed the values from the arrays due to company policies. local stringvar code1 := trim({history_member_auths.code_authorized_1}); local numbervar counter := 1; local stringvar code; local stringvar array cpt_code := [populate array w/ exatly 70 codes]; local...