Search results for query: *

Hello all, I am using Crystal XI on a windows XP pro machine against a SQL database. We have a business that needs labels pinted based on the number of products a customer purchases. We have a crystal report that creates the labels and would love to be able to control the number of labels...

I'm really a Crystal Reports programmer and am trying to start using T SQL more to write reports using stored procedures. I have the stored procedure for my report but I need to use another stored procedure to get the product name. I have tried using CALL and EXEC. Can anyone tell me what I...

I hope I'm posting in the right area. I have been writing Cystal Reports for many years but am NEW TO SQL AND STORED PROCEDURES. I have written the attached SQL statement and need to get a sum of the AXS_ACCOUNT.ACCOUNT_BALANCE for each customer (AXS_VIEW_PAYMENT.CUSTOMER_NO) in my stored...

Crystal Developer XI Sql database Windowns Pro I have written a report where we group by "Arrival Week". In the past we hard coded the weeks by the date of the Sunday starting each week. If someone has a ticket that is valid starting Thursday we want it to be part of the the group starting on...

I received my ACE (Authorized Crystal Engineer) certificaton in version 9. Besides having another certification is there any real benefit to getting my CRCP certification? In order to get the ACE cert. I had to take Crystal designer 1, 2 and 3 then take the ACE course. Does anyone know if I...

I was reading through lbass's post on Report Speed tips and someone brought up Arrays and the possibility of using them instead of Sub-Reports. I've never been a big user of arrays because they never seemed like a real world solution to any of the problems I am typically dealing with. So, in...

Crystal XI Developer SQL Server 2000 Enterprise Ed. Here's my problem, I work for a ski area and I needed to write a report that would show all customers who purchased pass insurance with their season pass. These are sold as two seperate products and customers do not need to buy pass...

Does anyone have a better formula than this one to calculate someone's current age? date ({AXS_CUSTOMER.DOB}) & " - " & DateDiff ("y",{AXS_CUSTOMER.DOB} ,CurrentDate)/365.25

Hi,I am using Crystal XI with windows XP Professional. I have written a report that groups by Department then PO# (Purchase Order #). A manager can have items from multiple Departments on one PO. Freight is a summary field for the entire PO. So, if I try calculating freight and a PO# shows...

Someone posted a similar issue but they were looking to extract a string from the end of a line of text and I need to putll it from the middle and haven't been able to come up with a solution. I am using Crystal XI on Widnows XP Pro. I am trying to pull the name from a URL. The data looks...

Another developer asked if I knew how to suppress a row in a cross tab. Apparently I don't. We are using Crystal XI and he needs the "item_no" (our version of a product number) to get an accurate total but, because it adds a row for the sale of every item the report ends up 900 pages long...

Hi, I'm running Crystal Server XI on an IBM Server running Server 2003 and when a user tries to run a rather large report through InfoView they get this error " An error has occurred: Request timed out. ". the time out is not from the database side because it is using a report server which does...

Are Dynamic Arrays supported in Version 9.0? Or any version for that matter? I am on Windows XP running version 9.0 against a SQL database and have a sub report where I am trying to say " if a person has purchased more than one item and one of the items is "X" and one of the other items is "Y"...

Hey everyone, I am using crystal server XI on Windows Server 2003. I configured it so we can schedule reports and have them e-mailed to our users Outlook inbox using SMTP. However, the attachement which is supposed to be the report is always blank no matter what format I send it in. I have...

I have recently installed Crystal Server XI and have been migrating user groups from Active Directory. This is great for cutting down on time creating users but they can not log on using their AD username/password. I have to go into the Central Management Console and create an alias with a...

Hello, I installed Crystal Server XI and it is working fine. However, when users log onto infoview (RAS) then they just shut the browser window it keeps them logged on. Needles to say it doesn't take long to use up our concurrent licenses. In the central management console under RAS server I...

I have created two running totals #RTotal0 finding the minimum date in a group and #RTotal1 finding the maximum date in the group. Then I created a formula called "days" which looks like this - DateDiff ("D",{#RTotal0} , {#RTotal1}) + 1. This is to calculate how many days it took a customer to...

We have set up e-portfolio lite with a default username and password so the user doesn't need to enter one. We have been using it on our intranet this way for a couple of years. However, we are now looking for a way to add "security" to e-portfolio lite. Does anyone have any input or ideas how...

Hello everyone, I am using Crystal 9. and am producing a report for our advance sales department which will simply print a shipping label for customers with items being sent to them. The want it to print ontoAVERY label 5160 which is 3 labels across and 11 down. I selected "Format with...

I have nearly 700 reports I need to update from Crystal Version 8.5 to Crystal Version 9.0. Is there a way to do this without opening every report and saving as "new version"?