Search results for query: *

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

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