Search results for query: *

Thanks for the help. Your suggestion makes perfect sense. Thanks again!

I am using SQL server 2000 and CR 9.0 I created a stored procedure for the datasource for CR to use that accepts 2 paramaters. I notice in crystal you can only make these two paramaters a discrete or range paramater. Can you not choose the 'Allow multiple values' checkbox to use the...

I use sqlserver 2000 for cr9.0 to connect. I mainly use views for the datasource. I have been in the process of converting many of these views to SP's. Lets say my view name is vTEST I use database-->set datasource location to change the datasource. This works fine and the report works. But...

I use CR 9.0 and SQL server 2000 for my reporting process. I usually write views in SQL 2000 for my data source (which I am in the process of switching them over to SP's) and am curious exactly how the data is pulled. I currently write my selection criteria in my sql views to narrow the...

Paul, I have not found a solution for writing my own bursting function but Visual Cut is an excellent piece of software at a great value. I worked with Ido on the issue in the thread you responded to and he updated his software to help me dynamically create the number of copies. I also...

If I have the week of a year- lets say week 15 of year 2004, can I get a date ranges like August 20 - August 26 from that? Thanks

Thanks for your reply. I have a couple questions about your suggestion since I am a rookie. What do these do or what is their purpose: @countgroup1 @displaygroupcount Also can this value 'mygroupcount' be use in a formula? Thanks!

I need help computing a formula total. I need to total a number for each record in a particular group. How can I get a total at the end of the report for where GroupHeader #2 = the value 1. So if the value of GroupHeader #2 = 2 or 3 or 4 I want to ignore the value. If this doesn't make...

I need help creating a Formula. I am also fairly new with Crystal. I have the IF Then condition but need help with the content with-in. At this point I have no errors. I need to multiply X * Y * Z and keep getting an error saying a number is required! Please Help! Also, an error says my...

Jim thanks for the response. It worked except that the page header on the very first page shows. Is there a way for me to eliminate that? Thanks

Is there a way to only print page headers if its greater than the first page of GroupHeader2? Thanks

I have a main report with a subreport. In Group Header1 of the main report can I place a value from the subreport? I am using Visual Cut and want to dynamcially put the Margin percent in the subject line. My subreport contains all the order detail information with the Margin percent. Thanks

Thanks but I figured it out. I used the >= and <= to filter the data. I also noticed your function was built in. Thanks again.

Thanks for the Reply. It worked wonderfully. I am fairly new to crystal so I have a modification question to your response. if {table.Order_Date} IN Aged0To30Days then &quot;30 Days&quot; If I change Aged0To30Days to Aged30To59Days then it errors. Is this a built in function? Thanks

I am pulling info from a sql2000 database and using CR9.0 I am using a order number and a date. I want to create a report showing how many days a product has been sitting in our plant after in was created. How can I use the date and get 30/60/90 days information? I can create a formula for...

I am printing labels and and need a different amount of labels based on the information in the order. I have a paramater field that is assigned to a large CASE statement. The case statement determines the number of labels to print out. The paramater in @Type. I tried using information from...

I am using crystal reports 9 developers and programming with Visual Studio 2002. I have been testing Ido's Visual Cut for bursting and exporting reports into a specified directory through the dynamic capabilites of Visual Cut. I would like to know if bursting reports in Crystal is code that...