Post reply

Highlight Text with color

  • June 2, 2015 at 9:57 am

    #301222

    Hi

    I have 1 parameter and few columns. column A will sore description about products.

    what ever text i enter in Text parameter it's going to search in column A and find all records with matching parameter value and display. i am fine until hear.

    Now i want to highlight found text with different color in all records

    Can any one suggest what to do on this.

    Thanks In advance,

    Ven

  • June 2, 2015 at 2:14 pm

    #1802453

    Ven,

    Take a look at this: http://www.bidn.com/blogs/Daniel/ssas/1574/ssrs-multiple-fonts-sizes-and-colors-in-a-single-text-box

    HTH,

    Rob

  • June 3, 2015 at 5:35 am

    #1802556

    Hi Ven,

    Were you able to solve your issue? I am not able to understand clearly what exactly your issue was?

    Is it that if you enter - 'Ind' in your parameter then values like - India, Indus should display and the Ind part of both these results should be shown in a different color, yellow perhaps to highlight what you have been searching?

  • June 3, 2015 at 5:54 am

    #1802565

    syedathariqbal (6/3/2015)

    Hi Ven,

    Were you able to solve your issue? I am not able to understand clearly what exactly your issue was?

    Is it that if you enter - 'Ind' in your parameter then values like - India, Indus should display and the Ind part of both these results should be shown in a different color, yellow perhaps to highlight what you have been searching?

    The issue is with date sort order. it sorts it in lower number first then higher date it is a weekly report but when the month change and if I run the report the date now then it would start from 01jun,02jun 27May,28,May,29May.

    Thanks,

  • June 3, 2015 at 6:42 am

    #1802595

    Hi

    I want to enter parameter value like India, then click on view report button.

    I have column which holds compliant letter ( which is a big mail describing about problem they face)

    Currently i am getting rows filtered if parameter value available in compliant letter column.

    But i want to highlight India word where ever it displayed in letter.

    Thanks

    Ven

  • June 3, 2015 at 11:51 pm

    #1802874

    Hi Ven,

    In that case you should simply not use your parameter to filter your Dataset Query(remove the WHERE @ParamName ), instead use your parameter value to change the font, style, font color etc That's the first part.

    The other part is to highlight only selected text in your rows, which would be textboxes. This would be tricky and I am hoping Placeholders would do some help to you.

    I would try that later in the Day If I can get that working for you.

  • June 11, 2015 at 4:06 am

    #1804634

    Is this Issue Solved ?

    I have tried to replicate what you need and attaching a screenshot. Let me know if this is what you need?

    There are two images with different selection in Parameters and accordingly the selected text is highlighted in the two report.

  • June 29, 2015 at 3:18 am

    #1808687

    Hey..how can we do that??can u explain me..

  • June 30, 2015 at 11:41 pm

    #1809368

    If you create a placeholder, you can format it any way you want.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply