Solved

Text alignment Justify (Ctrl+J)

Posted on 2013-12-10
5
854 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

762 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

14 Experts available now in Live!

Get 1:1 Help Now