Crystal Reports Forum : Job Postings

Find letter type location in string

Wed, 11 Dec 2019 05:16:28 GMT

I declared the I variable and it worked perfect. Thankyou so much for your help

Find letter type location in string

Wed, 11 Dec 2019 03:50:38 GMT

This might work. I makes an assumption that there is an non-numeric character.

numbervar i;

for i := 1 to len({somefield}) do (

if not(isnumeric(mid(somefield,i,1))) then exit for

);

left({somefield},i-1)

There maybe a better solution.

Edited by kevlray - 11 Dec 2019 at 3:54am

Find letter type location in string

Tue, 10 Dec 2019 12:46:13 GMT

I am stumped and hope you can help.

I have a table of alphanumeric strings. The max length of each strings are 6 characters. There is at most one letter in each string. Its location within the string is inconsistent from record to record. The letter is never the first character. I would like to create a function in Crystal reports which will return the position of the letter within the string relative to the left side. 1 being the first character, 2 being the second etc. and 0 if no letters are found. Note: I do not know the actual letter in this string all I know is it not a number.

typical field looks like 102b02, 12d09, 9k12 etc.
for reference we can refer to the field name as {Inv.Bin}

ultimately I want to return the numbers to the left of the letters, but I can do this if I can find the position of the letters in each field.

I appreciate any help you can provide. Thank you all.
regards

Edited by EVSchmidt - 10 Dec 2019 at 12:47pm

Combining Quantities...

Fri, 24 Apr 2015 04:53:16 GMT

I have a report that has group totals, sub group totals, sub group total percentages, and levels of sub group percentages... The levels consist of the combined percentages selected sub groups...
I do not know how to create the combined percentages of sub groups for the Level percentages...

Counting Lines

Tue, 08 Apr 2014 04:49:30 GMT

you're probably out of luck.

CR doesn't tell the report when a control that has been set to 'Can Grow' actually has.

The best you can do is count the records and adjust the count if the length of a field is suspected to have caused a control to grow. With proportional fonts, this can be difficult, hence the approximating.

Counting Lines

Mon, 31 Mar 2014 04:20:52 GMT

Explain what you want to accomplish. I do not understand the "How to control a page" part.

Counting Lines

Fri, 28 Mar 2014 18:24:13 GMT

How to control a page based on number of lines not record count. Because one record may go to two or more lines.

IT BUSINESS INTELLIGENCE ANALYST I

Thu, 27 Mar 2014 05:35:50 GMT

Just a test

Crystal Report Development project in Seattle

Fri, 21 Mar 2014 05:09:07 GMT

Looking for an experienced Crystal Report designer to build a series of 20 to 30 reports with charts and tables for our client in Seattle. These reports must be corporate quality presentable, and mimic an excel workbook currently in use. Some on-site work will be required.

Must be highly proficient with Crystal Reports and have the ability to work independently, quality check results and build requirement documents.

Project duration is 1 month.

To apply: hshain@aquent.com

Edited by howie.shain - 21 Mar 2014 at 5:09am

DFT is Hiring Consultants

Thu, 23 Jan 2014 04:45:02 GMT

DecisionFirst Technologies (www.decisionfirst.com) is hiring for the following positions:

BI Consultants
BI Architects
EIM Consultants
Architects

Most positions are based out of Atlanta, GA, but we'll look at other locations if you have SAP BusinessObjects experience. These positions do require travel, mostly in the US. See http://www.decisionfirst.com/company/careers/ for job descriptions.

We also hire folks with minimal experience and train them.

I have worked for these folks for @3 years and I've known them for 9 years. This is an AWESOME group of people to work for and with! DFT is an SAP Gold partner and one of the top SAP partners in the BusinessObjects space in the US. We're also on the leading edge of Hana implementations, so there's lots of opportunities to learn new technologies.

If you're interested, please PM me and I'll send you my email address so that you can forward your resume to me.

-Dell Stinnett-Christy
Sr. BI Consultant
DecisionFirst Technologies, Inc.