• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1070
  • Last Modified:

Text alignment Justify (Ctrl+J)

Hi,
I have generated a SSRS Report from SQL Server.
I want few  Paragraphs of the report/document  to be aligned as... Justify (Ctrl+J) option which is there in MS Word.

Is this possible in SSRS , or What Else Approach (Word Macros).
Pls Suggest.
0
sharepointDepot
Asked:
sharepointDepot
  • 3
  • 2
1 Solution
 
virtuadeptCommented:
SSRS does not support Justify text alignmnent in the standard product. There are third party add-ons for SSRS that can add this feature.

Here is a link to one:

http://www.aspose.com/docs/display/pdfreportingservices/Justify+FullJustify+Text+Alignment
0
 
sharepointDepotAuthor Commented:
Hi,
its good, but its budget limitation,is there anything we can do other way-
like VBA(visual basic for Applications) , or some sort of development in .net.

Rgds/-
0
 
virtuadeptCommented:
You can use something other than SSRS to do the report, sure, such as Crystal Reports, or some other kind of .NET report. Just about anything these days can talk to SQL Server and get data to populate a report. If you are going to need help rewriting the report, then I would suggest asking that question in the area for whichever technology you plan to use, along with a sample of what the report looks like and the queries behind if if possible.

Even Word or Excel can use a SQL Server as a data source. I would probably pick Excel mostly because I am more familiar with it but also because it will let you calculate derived results from the core data. Check the Data tab in Excel (2010 is the one I have) and From Other Sources, then choose SQL Server, and point to the server, and choose database and table. You can change the source to be a SQL query also instead of a table. What it does then is dump the query into a range of cells, and then I guess you could have another tab in the worksheet that uses that raw data source for a source of data and formats it however you want for printing.
0
 
sharepointDepotAuthor Commented:
Hi,
I checked Excel's DataSource with some limited capability.
In Word ,where can we see  any Datasource option ?
rest, for  alignment in  ssrs, looking some round ways.
Rgds/-
0
 
virtuadeptCommented:
For Word, do Customize Ribbon, make a new menu for your ribbon somewhere, and add the Insert Database command from the command list (show all commands instead of just "popular" ones that come up by default). Insert Database will add a wizard that lets you make a connection object to your SQL Server database. Then it will let you choose a table (that you can override after you build it to be a select). And you can populate it and it will generate a Word table (like HTML one sort of, visual) by default, that's what it will look like.

Here is a short tutorial on how to make one that connects to Access, the SQL Server would not be a lot different.

http://blogs.msdn.com/b/officedevdocs/archive/2012/02/06/insert-database-query-results-as-a-table-programmatically-in-word-2010.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now