Solved

Text alignment Justify (Ctrl+J)

Posted on 2013-12-10
5
959 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 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

726 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