[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Text alignment Justify (Ctrl+J)

Posted on 2013-12-10
5
Medium Priority
?
1,014 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
virtuadept earned 270 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Suggested Courses

656 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