3

Publication - How to bold author name from within a string? It would be something like this if 1 value was returned but it is a string (=iif(Fields!Author.Value = Parameters!5aAuthor.Value, "Bold", "Normal"). Example: Authors + Year + Title + Journal + PMCID . Authors = Miter, MH, Owens, R, Thompson etc… I only want to bold the Author that matches the parameter value. I need to break apart the string – find the author – bold it – and leave the others as default. Like an array….

Problems:

Author has to be displayed in a certain order. Meaning the author might be displayed 1st or 3rd or 5th or whatever. Below is what is required.

I can create this as a view but I still have the same issue of bolding author.

Example - Miter, M.H., Owens, R., Thompson, P., and Berg, L., 2004, "Insulin Treatment of Diabetic Rats," J. Comp. Neurol., 373:350-378.

Brown, B. and Jones J., 2005, "Repeated Sequences in Drosophila," J. Mol. Biol., 242:503-510. Corman, T., Walker, J.D., and Brown, B., 2006, "Ontogeny of Tolerance to Alloantigens," Am. J. Anat., 146:156.

Samuels, J. and Peters M., 2009, "Molecular Analysis of RNA Viruses," Molecular Biology of the Cell, Vol. 11, 12-18. PMCID: PMC2583929

Each 2 Lines (example) would go in 1 text box...

Pedram
  • 6,256
  • 10
  • 65
  • 87
sjackson5280
  • 43
  • 4

1 Answers1

2

You are exactly right with your general approach:

I need to break apart the string – find the author – bold it – and leave the others as default. Like an array….

Sounds like you want to do this at the report level instead of in SQL.

If you are using SSRS 2008 or later, where you can use placeholders, then this is how I would accomplish this:

  1. Create three calculated fields in your dataset, within the report.

    1. LeftOfAuthor:

      =LEFT( Fields!BigString.Value , Instr( Fields!BigString.Value , Parameters!5aAuthor.Value) - 1 )

    2. Author:

      =Parameters!5aAuthor.Value

    3. RightOfAuthor:

      =RIGHT( Fields!BigString.Value , LEN(Fields!BigString.Value) - Instr( Fields!BigString.Value , Parameters!5aAuthor.Value) + LEN(Parameters!5aAuthor.Value) )

  2. Now put three placeholders into the text cell you need this displayed within. Set each to refer to one of these calculated fields, in order.

  3. Select the middle placeholder (for Author) and bold it.

The formulas above presume that the author name has an exact match somewhere in the field. You'll need to add error handling if it might not be. They were not tested in any way, so may need some tweaking.

Some alternate approaches include breaking the string up in SQL and/or enconding the string with HTML <b></b> tags for display, then setting SSRS to display it as HTML.

Jamie F
  • 23,189
  • 5
  • 61
  • 77
  • Thanks, I will give it try this afternoon... The problem I ran into using the 'alternate approaches (SQL)' is: My skillset and creating the Cross Apply with a parameter in SQL and more confusing is this is a Sub Report and I'm not very familiar with SSRS. Thanks again.. – sjackson5280 Jan 04 '13 at 20:57
  • The sub report will look like Table 6 Publications column. http://grants.nih.gov/grants/funding/424/datatables_sampleall.pdf Thanks again.. – sjackson5280 Jan 04 '13 at 21:06