How to format Strings in cells

Question

Post reply

How to format Strings in cells

IAK

SSC-Addicted

Points: 437
More actions
October 27, 2010 at 5:51 pm

#388109

I am going to develop a report that print labels tags.
i want to display display 3 things in one cells and each need to be format differently.
For example i want to display Name, Company name and Date .The name should be formated in bigger font then the company name and date need to be smaller than conpmay name
Name (large size font)
company names (less size font then name )
Date (less size font than company)
like this
Name
Company
Date
All the Data need to be display in one cell

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

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

Peter Rijs Hall of Fame Points: 3400 More actions · Answer 1

This can't be done in SSRS 2005, but should be possible in 2008 or R2 (i'm not quite sure which one)

As I have no 2008 or R2 available I can not give you an example on how to accomplish this.

However: why not split it in 3 cells? That is probably a lot easier to accomplish and maintain.

Peter Rijs
BI Consultant, The Netherlands

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

Not quite sure why it has to be in one cell.

Try this, drag a List from the toolbar onto the single cell (the cell should be empty) where you want your data to show up. Then drag textboxes from the toolbar onto the List. Give each textbox one of your different data values and format each of the textboxes as you wish.

IAK SSC-Addicted Points: 437 More actions · Answer 3

i cant split it into three cells becuase i am priting labels and they need to be in one cell. an example is on this page

http://p2p.wrox.com/content/articles/creating-mailing-labels-sql-server-reporting-services

but problem is formting each line differently.

thanks

Peter Rijs Hall of Fame Points: 3400 More actions · Answer 4

Using the techniques above you could have a fixed-format textbox ("cell") per label, and have other objects (using a list for instance) in that "cell" in which you place the data and do the formatting.

I didn't take the time to totally read the link you provided, as I suppose that will be a good walkthrough on printing labels.

However: I noticed that the example there is using Reportbuilder, where the previous answers presumed you were using BIDS.

Please be more specific on the tool and the version you are using (as I pointed out before, 2008 had more formatting options than 2005).

You might even consider posting an anonimized version of the report and data you are using, so we can help you better.

Peter Rijs
BI Consultant, The Netherlands

VinceV Right there with Babe Points: 791 More actions · Answer 5

I also assumed that he was using BIDS as well but turns out that might not be the case. What he needed to achieve can be done very easily in BIDS (SSRS 2008 - no need for R2). No need for list boxes. Not sure about 2005 but in 2008, you can create multiple placeholders in a cell or text box. Placeholders can be on separate lines and can be formatted separately from other placeholders.

Steven.Howes SSCertifiable Points: 6230 More actions · Answer 6

If you're using 2008 you can use placeholders in cells to apply different formatting. If you're using 2005 I'd go with multiple text boxes unless there's a real compelling arguement why you can only use one.

Peter Rijs Hall of Fame Points: 3400 More actions · Answer 7

Ah! Placeholders was the word I was looking for in my first reply.

Tnx for clarifying they are introduced in SSRS2008, not in R2.

Peter Rijs
BI Consultant, The Netherlands

IAK SSC-Addicted Points: 437 More actions · Answer 8

I tried to use placeholder ...but it just print the first record and did not go to secod record.

for example if I have 20 record ..then it just take the first record and print it 20 times ..it does not go the secod record.

thanks

IAK SSC-Addicted Points: 437 More actions · Answer 9

Ohh its working actually I did not remove the First keyword from the expression.

Thansk a lot