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?

Thank you very much for your reply. In this case I have not control over the data in this table. I am just dealing with junk.

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

Awesome! They both work. Thank you so very MUCH!!!!

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 get an error that the global temp table is not a valid table. yes, i am using sql sever. I will check out the link dave posted. thanks very much!

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

awesome! thank you very much.

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

Awesome that works! Thanks a very much.

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.

Thanks you it is perfect.

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.

Thank you so much for the help I actually ended doing a running total. It worked once I got my formula in the correct spot. I could not use the first suggestion because I could not get a count on the field.

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

Thanks so much!!!! Christina

Great thanks! Is there a way to display what date is the begin date +90?

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