Search results for query: *

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...

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

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...

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

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...