Recent content by alank01

windows 2000 CR 8.5 I have certain non true type fonts installed on my machine that show under the control panel fonts however under CR fonts it would appear only true type fonts are listed e.g. Advocra (True Type) shows AdvOCR-A 9,12 does not show in CR AdvOCR-B 12 does not show in CR...

crystal 8.5 sql 2000 stored procedures with input para. main report proc1 with p1,p2,p3 sub report 1 proc2 with p1,p2,p3 sub report 2 proc3 with p1,p2,p3 question: while report is printing can a requery of a stored procedure in a sub report be issued with changed values of...

crystal 8.5 sql 2000 stored procedure with para. main report proc1 with p1,p2,p3 sub report 1 proc2 with p1,p2,p3 sub report 2 proc3 with p1,p2,p3 the question is how do you ensure that para sent to the main report are also received by sub reports? currently the report will...

thks JHall. i was not too clear on the repeating values. i need repeating values but not the multiplier effect. in my example i have the key value 12 in both tables i would like to see 12 12 null 12 not the multiplier effect of many selects 12 12 12 12 [pc3]

thks for effort JHall unfortunately using this select per you suggestion : Select tablea.fkey,Max(tableb.fkey)from tablea left join tableb ON tablea.fkey == tableb.fkey group by tablea.fkey order by tablea.fkey result 11 null 12 12 13 null 14 14 i should clarify that although i used numbers...

basic problem is as follows i have three tables, table C has the primary key and unique entries, A and B hold foriegn keys that are many to one into table C table A table B table C f_key f_key p_key sample data data A data B data C 11 12 11 11 12...

got everything i needed from 1-800-MSPRESS. they were very help full.

thanks ian that browse ...for did the trick. i guess i was too focused on the set relation to command.

i have a question on set relation. i have as an example a client table and a contacts table (ccontacts). the client field exits in both tables so a simple browse might be. use ccontacts order client use clients in 0 set relation to client into ccontacts set skip to ccontacts && one to many...

this download is approx 173 meg. (out of my league with 56k). i am interested in ordering a cd from ms but i can't seem to find a number or link at microsoft.com to order this cd. anyone have a link or comment. thks. :-)

is there a trick or tip for tidying up the display of tables in the dataenvironment of a form / database container. something similar to arrange icons in windows. the only way i know how to do it is to manually move them around so they are nicely arranged. not a major issue but still gets a...

thanks ramani for your response. these are two good tips that i was not really aware of that would be useful for views - NODATAONLOAD=.t. and REQUERY() on the view. basically thats the procedure i would use running a report via sql cursor i.e run query and check for result if _tally greater than...

i am a newbie with views and am probably going to ask some very basic questions here. i am more familiar with creating a sql select cursor before running a required report but i have a case were a view seems more appropriate because all the data setup is done in the dataenvironement of the...

my understanding of the report header is that it behaves like any other group band that has reprint header on each page checked. with such a large page header you are asking the report writer to reprint the page header before a new page has triggered (i guess a sort of loop). i suggest you...

i believe it may be as simple as issuing the QUIT command. you may want to try the following after THISFORM.RELEASE in your calling program. clear dlls release all extended clear all quit