Search results for query: *

Ken hit the correct chord with what I am trying to accomplish here. Basically dropping a count of customers into one of the 15 buckets and then displaying their yearly purchases. Will be using Order Details for this mainly although will be joining a couple other tables.

Is there any way to do this in Crystal? I am picturing a cross tab report. * We have 4 columns for 4 years - current year and the last 3 years. * Want to summarize the columns with total sales in those years. * The rows will have a count of the customers that have purchased product in a...

We are in the process of building a data warehouse and I would like to know ahead of time if there are any gotcha's I need to be aware of. The source data is a SQL Server 2000 and the warehouse will likely be the same. Would I simply connect through ODBC and then design as usual? Thanks for...

I actually found a way to solve this by inserting 3 cross tab reports into the report. It works like a charm. I am using SCR 7.0 with Seagate Info.

I need to create a report that will display a count on each day, each week, and each month. I assume there must be a way to do this using sub reports but is there a way without subreports? These will all display at the same time.

On email notification of success, I would like the body of the email to include the prompts selected by the user. So the body would say the stuff it already has like start time, end time, APS, Infoserver but then add to it the Prompts. I tried adding '%prompts%' to the end of the code in the...

Can the following be done without a view(s) or do I need a view? We have a subscriptions table. We want to report on subscriptions that haven't expired yet but will expire in the date range the user specifies. Of those that will expire, we want to report on those subscriptions that have been...

Thanks for your input. As an FYI to olympian, we use Oracle 8i but are considering a move to SQL Server 7. In addition, we are using Seagate Info 7 rather than Crystal Developers kit which makes using a front end app impossible unless we went the Seagate Info Developers Kit which seems like it...

Is there a way to write a SQL expression based on the user parameters? Specifically to be able to allow the user to leave the prompt blank if they want to basically ignore that restriction. Almost all of the where clause is generated off user input rather than pre-determined exclusions or limits.

I am interested in dynamically changing the SQL statements as the report is refreshed each time. Many of our reports have 10+ parameters for the user to respond to. Sometimes they want to ignore a certain parameter like Order # and have the report return all Order #'s. To accomplish this, I...

Do you know much about the Developer's Kit for Seagate Info? We don't like the way the parameter prompts user interface looks for SI with the no lower bound check boxes and such. We also want to be able to have the user leave the prompt as blank and have it basically exclude that parameter...

IN CRYSTAL INFO AS WELL YOU HAVE THE PICK LIST OPTION AVAILABLE. YOU CREATE A NEW REPORT WITH THE INFORMATION YOU WANT IN THE LIST - NO HEADERS ETC., JUST THE WHAT YOU WANT TO SHOW UP. THEN YOU SCHEDULE THIS REPORT TO RUN EVERYNIGHT AT XX:XX SO THAT IT WILL GET REFRESHED DATA AND EXPORT IT TO...