Search results for query: *

HI there. Haven't been on for a while. I'm using Crystal 10. Why is it when I create a group on specified order (inv.type = C) it acts as a record select? Is it a setting or something else I need to do? I don't want to discard all others from the entire report and my higher level groups...

can anyone tell me why? I thought maybe it was security but I went back and set my security. I'm using GP2010

Hi there. It's been a while since I did much in Report Writer so I'm coming up to speed again. I have a client that wants slightly different info on each stub. She wants all the invoices listed and amounts on each stub - no problem. But only on the one stub does she want the vendor name. I...

Hi all. I'm using Crystal 7 - yes go ahead make fun of me. I know.... we're upgrading soon. In my crosstab I have a column on date to group monthly. I only want to show the number of donations and the number of donors per month. I don't really want any row grouping. But on the number of...

Hi there. At one time I was given this formula to mimic the ceiling function: Round(({database.field+2.4999}/5,0)*5 at that time I wanted to round to the nearest $5. Now I need to round to the nearest $25. What should my new numbers be to achieve this?

I know how to do a manual running total when I consistently want say the most recent 3 amounts. But how do I do one when I don't know how many amounts/rows will be there for each id? I'm using Crystal 7 - desparately need some assistance

Hi there. How do I do this? first of all I'm using Crystal 7 - limited I know. No way around it. In my record selection I need 4 years of giving dates. No problem. I need one running total that sums the last year of giving one year back from today's date. No problem. But then if that...

Hi there. I'm using Crystal 7 - limited I know. I need the amounts from last 12 months from the current date. No problem. Then previous to that I need the PREVIOUS 12 months. And previous to that I need the previous 12 months. any ideas?

Hi all, I am hoping someone can help me. I have exported query results from RE into a Microsoft Access 2000 table and then opened it in Crystal 8.5 and I am trying to customize the sql to tell me who has both Manager codes. I have been able to do this in the past (with Crystal 7/sql tables)...

Hi all, I am hoping someone can help me. I have exported query results from RE into a Microsoft Access 2000 table and then opened it in Crystal 8.5 and I am trying to customize the sql to tell me who has both Manager codes. I have been able to do this in the past (with Crystal 7/sql tables)...

Hi, I am trying to do a sql subselect using "not exists" within Crystal 8.5. I'm exporting the data out of our database using Access 2003 and then opening it up within Crystal 8.5 and would like to do a "not exists" subselect utilizing the following code: Is this possible? SELECT...

How do I group by every 5 years in Crystal 7?

hi there. I'm using version 7 by the way on an Oracle ODBC. I have a client id as my key. Each client can have 2 or more different name types, however the last name in each row should consistently be the same. However it's not due to data entry errors. I have been playing with the previous...

does anyone remember?

hi there. I want to mimic the Excel ceiling function by always rounding UP the results of my formula to the nearest $5. I'm not able to use ceiling or int within the SQL expression. Also to let you know I am using Crystal 7.

Hi there. I'm using Crystal 7 on an Oracle database. What I want is comparable to the ceiling function in Excel, rounding the amount up to the nearest $5. I see there is a ceiling function available as a SQL expression however that won't work for me as I'm wanting to round the results of a...

Hi, I am currently using Crystal Reports 7 with a SQL ODBC connection. I have a field titled CITY within our ADDRESS tbl and I am trying to locate any cities that start with a lowercase letter for example "calgary" as opposed to "Calgary" within the CITY field. Thanks in advance for any help.

Hi there. I'm sorry for the post - likely the answer is available from a search but the search feature on this site is not working. I have a running total and text flag in my subreport. Depending on the running total I have different text flag messages. When the flag is 0 I want "Team...

Hi there. I'm using Crystal 7. I know how to get max date which gets me the most recent date - how do I get the amount for the most recent date? If I use max(amount) then I'll get the largest amount which is what I don't want. I'm grouping on customer id. Thanks.

Please forgive my ignorance, I beg you! I know nothing about AccPac. However I do know Crystal Reports. I had someone contact me regarding modifying Crystal Reports off their AccPac financial software. The client has 3 companies and then a parent company. They want the report modified to...