Search results for query: *

I have a field that is alphanumeric. The majority of the fields are numbers. When I sort they do not sort in numerical order. I would like to add a leading zero to any field that is 3 characters so they will sort correctly. See below example Current sort 100 101 102 20 201 202 203 Would...

Crystal Reports 2016. I have a main report, with a sub report. All pulling data correctly. However when I try to use a shared number variable the amount is not correct. Group header 1 has the initial sub report (Items with border) and group header 2 contains the "while Printing Records share...

I have an excel report I put in the report library. When the user clicks on this report it refreshes and opens up fine. There is now a tab available to the end user, called "OPEN". Does anyone know how I can get rid of this tab?

I have an Excel Web Part and I would like to put on it somewhere the "Last Refresh Date". Dows anyone know where I can find such a field? Any assistance would be greatly appreciated.

By the way. The connection refresh works fine outside of SharePoint.

I have an excel spreadsheet (2007) that I have published to a dashboard as a Web Part. When I click the report opens fine and looks fine. However, I can not REFRESH the report data. I get the following error: Unable to retrieve external data for the following connections: The database info...

Perfect. Thank you

Does anyone know of a formula that would break out a date range. For example: Current field is 04/01/10-04/15/10 I would like to see 04/01/10 04/02/10 04/03/10 04/04/10 04/05/10 Any help would be greatly appreciated.

That did it. Thank you so much

The parameters are for choosing the events you want to see. For example my event was here in 2007 and 2009. I would enter those event id's so I could compare their revenues. Someone else might want to compare a different events.

Seperate records for each year

Does anyone know if a "Column" report can be created in Crystal? I am using Crystal reports 2008 and would like to do something like the following: Compare three years worth of revenues using three seperate parameters if parameter 1 = 1 then put revenue in column 1 if parameter 2 = 2 then...

I have an excel document that connects to a SQL Server database. When I generate the excel document the connection automatically refreshes the information when the workbook opens. When I try to put this in an EXCEL WEB PART the connections fails with the following: The data sources may be...

That did it. Thank you so much

I have a sub report that pulls revenue by event id, works fine. I bring the sub report into the main report link it by event id and all works fine. I share the numbervar so I can use this total in another calculation and here is where my problem occurs. if the total on the subreport is 0.00...

I have an excel chart and have used an image as the Data Series, instead of just the bars etc. When I publish this spreadsheet into Sharepoint, as a web part, the images disappear and the series shows up as bars. When I go to "Open in Excel" the images are back and the bars are gone. Any...

When the report is run from the Browser. I have a few folders that have Multiple reports in them, but I want one specific to "Stand" out.

When publishing a report within Enterprise, is there a way to change the font color for the report name?

We are using Outlook

I should have given more detail. Sorry. I am using BO Enterprise XI