Search results for query: *

I have a database created in Excel 2003 using tmplwiz to update the database from .xls files sent to me each month. Company is updating everyone to excel 2013. It is my understanding that it won't work anymore, MS support has no help. Am I stuck changing over to Access?

oh , i need to correct something. the sql that CR creates DOES change. It drops the WHERE "xca_mstr"."xca_nbr" LIKE 'ca%'

sorry for the delayed response, I was fishing the problem was that the Left Outer join stopped working when I added the selection criteria <{xca_mstr.xca_nbr} startswith "ca"> on the "Righthand" table "xca_mstr". I think I had wrestled with this before and I was having a "senior moment" last...

I have read many posts and faqs regarding the dilema of displaying continuous calendar dates even when there is no data returned. I'm trying to work it out in a test report. Using Cr10 My excel table has dates from 1/1/1999 to 12/31/2025 I linked, using LO join, the date to a "close date"...

Thanks lbass I'm using 10. Didn't realize 11 has added functions to Chart Expert. Just looked at it on another computer. Guess I have to start using 11 sooner rather than never. sdzlkds, In 10, I have seen the problem you describe when you have multiple Show values. You might try the new Chart...

what are @Chart, @Daily...., and @Yesterday? What groups do you have?

in Chart Expert, use Order by Specified Order instead of Ascending

Within and including 10th 11th 12th would equal 3 days" @Days {your endDate} - {your startdate}

Do you mean you need the number of days within the range for which you have data?

hmmmm....? never noticed that before... it appears that it truncates the decimal and does not round up. can't change the formatting for decimals on the %.

yes. Try adding a decimal place to the percentage...formatting...

create a formula for duration and status //@Duration {complete_date} - {open_date} //@status if isnull({complete_date}) then "Still Open" else "Complete" make a crosstab with @status columns and @duration in rows Summarized Fields: Count of {open_date} Percentage of total count of...

For a CrossTab with months across and grouped employee data labeled by year down the left.. assuming you have a group on date by year make a formula to put on left of crosstab //@Year_Employee_Group //this splits and labels the data by year and employeename //add as many years as necessary If...

I had a similar report request. I took an existing report and added a ?YTD_Month number parameter with default values 1 thru 12. Then add to record selection... {table.date} = {?Date_Range} and month(table.date}) <= {?YTD_Month} the user selects the month number they want the data thru...

sending a Star to fisheromacse. This is essentially a function for LastFull3Months. You got me looking at Crystal Help and I can see lots of ways to use the DateSerial function now. Thanks

You could make an "ALL" default for ?Customer and a "NONE" default for ?Exclude_Customer and then they could choose All, include some,or only exclude some. ({CUSTOMER_SITES.SITE_CUST_ID} = {?Customer} or {?Customer} = "ALL") and ({CUSTOMER_SITES.SITE_CUST_ID} <> {?Exclude_Customer} or...

thread767-474541 the Array pdf is now found at http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/50477290-db1d-2b10-ce9c-a1b38197b8cb?QuickLink=index&overridelayout=true

Actually, I make "excel dump" crystal reports specifically to get data for people who refuse to use formatted reports in crystal. They don't have to be readable in crystal, just details in one horizontal line and a page header.

It appears to read from top down, across from left to right so if you have a field that is lower than the others, it will be skipped and end up on the far right

Make sure they are Aligned horizontally too. select ALL section objects-> right click on the left most detail field>Align>tops