Search results for query: *

I'll give that a try. I am not sure I can do it in all cases since 70% of these use commands. I would have to do the formula in the PL/SQL itself....not impossible, but something I was hoping to avoid. At this point though I am dead in the water....I'll try anything.

Here is the setup. I have a crystal XI report that is being used in the BO XI environment. only 2 parameters: Start Date and End Date. About a dozen sub reports take those inputs and produce varied rolling 12 month charts. The user is tired on having to change the parameter values and...

Ok, I am trying to parameterize the Start and End dates for a PL/SQL call. It Runs with the values hard coded like this: where ad_date between '3-NOV-2004' and '31-DEC-2005' It returnd nothing when parameterized and passing the same date through the Parameters....Like this: where...

But which date do you use as your axis? Is it possible to create a date axis in a formula? They have a status, but if its a short project I need to count it twice for the month. Once for Projects Started, once for Projects ended. Shane

OK, here is the situation. I have a table with project tracking info in it. each record contains info like the name of the Project, the start date, and the end date. I need to chart the monthly status for all projects in a date range. for each month I need to plot the following data: Number...

I am trying to create a report that will display only the records from the last 90 days. I am using CR 7.0 because these reports will be presented through Crystal Info. I have seen functionality for this in CR 8.0 but it must be new because there is no equivalent in the 7.0 product. Any advice...