Solved

Text alignment Justify (Ctrl+J)

Posted on 2013-12-10
5
870 Views
Last Modified: 2013-12-16
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
Comment
Question by:sharepointDepot
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
virtuadept earned 135 total points
ID: 39708919
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
 

Author Comment

by:sharepointDepot
ID: 39710801
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
 
LVL 8

Expert Comment

by:virtuadept
ID: 39711392
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
 

Author Comment

by:sharepointDepot
ID: 39717788
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
 
LVL 8

Expert Comment

by:virtuadept
ID: 39721560
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now