Search results for query: *

I am using XI and trying to create a dynamic list of values. I have created a business view then a list of values, then when I try to create the parameter in the report and the setting for the paramenter are dynamic, then existing. when i go to run the report, i get the following error...

I have created a DTS package which imports a small amount of data from an excel workbook into a sql table. I then have an sp that joins a couple tables that produces a result set. Can I have a the beginning of the sp something that triggers or executes the DTS package?

I am in need of assistance to create an efficient way of grouping states. I have a table with over 2 million records and need to show a count by state. However the state field is not always consistent. The data type is varchar 15 and I have data ranging for the standard two char abbreviations...

I am using crystal xi and have a field and I need everything to the right of the last semicolon. But the last semicolon is not always the same characters from the right. Examples Store1:Westpark Towne Plaza:t (I would need to show the t) Store4:Eastgate:n01 (I would need to show the n01)...

I have just started using BO xi. I have created two stored procedures in sql that put data in global temp tables and there are a few other procedures that reference the global temp tables. However, I can't get my procedures to run in XI that reference the global temp tables. Any ideas on how to...

I am using xi and have a report that requires to columns of data first column they want to see a count by the last week so I am using the lastfullweek function. next they want to see a count of everything from the first day of the month to the last day of the lastfullweek. Any suggestions on how...

I am using crystal 8.5 and have a report that uses an informix odbc connection. I want the user to pass a number to the report, but the thing is the number the user enters does not determine the records being returned, the number is used for calculations. I don't no if this is possible I have...

I have created a report using crystal 8.5 and it is set to look at a stored procedure. I need to show on the report a simple message like "No Data Found" when there is no data. I have tried using recordnumber but have not seem to get this to work. Any help and suggestions would be great.

I am using crystal 8.5 and have a date parameter on a field. Is there anyway to set the parameter to default to the current day? Thanks so much for any help.

I am using crystal 8.5 and in my detail section i am supressing it when it meets a criteria. Now I would like to count the field when it is being supressed. I have tried using a variable but have not been sucessful. Thanks, so much --Christina

I am using crystal 8.5 and for some reason I have have not figured out how to add 90 days to a begin_date parameter in the selection expert. Any help would be great! Thanks, Christina

I am using crystal 8.5 and trying to write a formula in the select expert that will use my parameter field. What I have are two choices in my parameter field and when the run the report they can select one choice from the parameter, but I need them to beable to select a choice like "All Cards"...

Is there any way to show a group going across the page? I don't want to use a cross tab. I am using crystal 8.5

I am using crystal 8.5 and I have used a crosstab to display my information, however I need to add a percentage column. Is there a way to do that in a crosstab? Example: Date1 % Date2 % Date3 % Subject1 # % # % # % Subject2 # % # %...

I have created a cross tab and for my column I have a date field and have selected for group options column to be printed for each week. I would like to add a parameter to my report that changes my grouping option, I would like the user to have the ability to select, "printed for each week"...