Search results for query: *

this only support 20-40 entries, I have about 500=/

nope that doesn't work

I tried this out a few times but I keep getting stuck on step 8 with the correct syntax for excel. The syntax shown below given is for Microsoft SQL Server. ----------------------------- {?LinkReceiver} DELETE FROM "TableOfContents" WHERE "TableOfContents"."DateTime" <> {?DateTime}...

Thanks in Advance! I am using crystal XI. Is there anyway to display the page number of where the field is in a report on a different page? What I mean is if a field is being printed on page 14, on page 2 I want to print the field and the page its on. The pagenumber function prints that...

Thanks synapsevampire and lbass! You guys are great!

Thanks in advance! I am using crystal 11. I want to insert the page number for a table of contents, however when I insert page number in the special fields it gives me the page of that report page. I want it to give the page of where product is in the report. mine looks like this now...

Thanks for your reply. Replicate() is not a valid formula function though. len shows up blue but replicate does not. Any idea?

I am using crystal 11. is there anyway to overwrite part of a text box with part of another box. This is what I am looking for. product names page number ------------------------------------------------------ [Acrobat].....................................45...

I am using crystal 11. I have a report done and I need to create a table of contents that is user friendly.(clicking on the title brings them to correct page) I researched online and they first said to create a table. and then gave further instructions. This is my first question, how exactly...

sorry synapsevampire about not being clear thank u for your patience Each row of my excel sheet is assigned to a code (0400) or a subcode (0400a). This field is {Sheet1_.SW Dir Code} 0400 Main Product 0400a Additional 0400b Additional 0401...

I am using CR XI I am tryign to compair in excel row 1 with the rows below until it reaches no subcode (a,b,c,d) I have a SWCODE field that has 4 or 5 char in it. 0400 0400a 0400b 0401 0402 0402a if Length({Sheet1_.SW Dir Code}) = 4 and Next({@length}) then next({Sheet1_.SW Dir Code}) +"...

I didnt have any luck with synapsevampire method ethier. When I try the formula below I get the error "A field is required here" for previous(left({Sheet1_.SW Dir Code},4)) I guess it does not like the Left after previous or the left after next. If left({Sheet1_.SW Dir Code},4) <>...

I tried just creating a formula called {@left4} and put in left({table.field},4) if distinctcount({Sheet1_.SW Dir Code},{@left4}) > 1 then "Additional Products" when I try this I get "there must be a group that matches this field(({Sheet1_.SW Dir Code},{@left4})) I will try vampire's...

lbass I tried to make a group on {@left4} how do you do this? I went to insert group>customize group name by formula> left({table.field},4) Is there a way to change the name to {@left4} because its name is the same as my swcode field name shown below which gives the error msg that {Sheet1_.SW...

Thanks in advance! I am using CR XI I am having trouble with a formula to compair the first 4 char with the next row first 4 char. I have a SWCODE field that has 4 or 5 char in it. 0400 0400a 0400b 0401 0402 0402a My goal is to create a formula to compair the left 4 char to the row below it...

is there a way to put a formula for a separate subdetail. I want so only sub detail b shows up if there is a letter at the end of the code. so 0411k would show up but not 0411. I know there is a selection expert for group, but how do you have it filter with multiple groups. I dont know how to...

I am using crystal report XI (11). I have a excel database with certain fields listed below: Product Additional Product Software_Code Description Manufacturer I need to form a report that will place the product with its information on page 1 listing the additional products that relate...

ya I ended up putting a formula for new page after, to check for a char code that was placed in b and c. For some reason when you click new page after on a subsection it wants to make another new page for the following subsection. I just got it working the way I needed. Thanks again LB

When I do a keep together for overall detail it keeps everything together. However when I try to put new page befor detail a or after detail c it auto breaks up b and c to separate pages. I can't get A to be on 1 page 1 and B and C to be on page 2. I was thinking of trying a formula for New...

Sorry about not being clear. I have created addition details under the detail section. So subsection a,b,c,d,e section a has the main products in them, where as b,c,d,e are additional products. In b-e I have formulas to search for the char in excel to signals its additional. I can't get the...