SUM Of Top Five As Tooltip
Mar 24, 2008
I have the following two expressions in side-by-side fields in a report. They compute the percentage of unit sales and retail sales that a particular row accounts for. ("SalesData" is a DataSet.)
=FORMATPERCENT(SUM(Fields!Units.Value)/SUM(Fields!Units.Value, "SalesData"), 2, -2, -2, -2)
=FORMATPERCENT(SUM(Fields!Retail.Value)/SUM(Fields!Retail.Value, "SalesData"), 2, -2, -2, -2)
What I need to do is provide a SUM of the top five percentages and display it as a tooltip for the respective column headings. So, basically, what percentage of the overall retail/unit sales was contributed by the top five? The table usually displays approximately 40 rows.
Thanks in advance for any help.
Jamie
View 7 Replies
Jun 28, 2007
What am I missing on the tooltip. I have entered a very simple if statement based on a parameter. Why will it not display with I run the report?
I have entered the simple formula in the tooltip under the fields textbox propeties. What am I missing.
=iif(Parameters!ExcelExport.Value = False, "No", "Yes")
View 6 Replies
View Related
Mar 26, 2008
Is there a way to increase the Toop Tip Length? Currently, it is limiting to 512 (approx) Characters. I need to show more number of characters for certain items.
If its not possible, is there an alternative of showing a window on mouse hover and show the data just like a tool tip.
Thanks,
Sampath.
View 3 Replies
View Related
Mar 7, 2008
Is it possilbe to have the tooltip (mouse-over text) display longer? Seems like it currently displays for only 5 seconds.
View 3 Replies
View Related
Aug 9, 2007
Hi
On a report I'm making for CRM Dynamics I have a filter that's a String and that the user types what ever he wants to filter on. It filters for example on "Bikes:" and the user can use even the %, for example "Mount%" to get only Mountains Bikes. As I have made a parameter for this and so on, I can€™t find anywhere where I can set up a Tooltip for it, so the user have some examples on how to use this particular filter. So, how/can I make this Tooltip?
Kind Regards
View 2 Replies
View Related
Mar 28, 2007
Hello,
I am displaying a complex formula in a column header tool tip. The formula is generated in a stored procedure. (I do not enter the tool tip text directly in the column header expression.)
Within the stored procedure, how do I generate a string that contains a carriage return/line feed?
Thanks,
BCB
View 6 Replies
View Related
Jan 15, 2007
My co-worker, no idiot, says that the tooltip in the system tray forthe SS2000 icon usually shows the computer and server, but once in awhile shows the password (two slashes and the password).Is this a known bug of some sort? It really shouldn't be showing hispassword. It's likely the developer edition, but still, that isn'tgood.
View 2 Replies
View Related
Feb 19, 2008
Hi,
I need to set up tooltip for some images in a reporting service
2005 report. I add some text in image's tooltip property.
However when I move the mouse over the image in the report preview,
it does not show any tooltip. What am I doing wrong?
There is also another property called tooltiplocid.
What is that? when and how should we use it?
Thanks in advance.
View 4 Replies
View Related
May 8, 2007
Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ....
i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??
is it possible if so ...any hints??? thanks a lot in advance
View 4 Replies
View Related
