mvc display pdf in view : Convert pdf to word text online SDK software service wpf windows winforms dnn MMUC_S1S4_ReportWriterAdv_Halicki0-part1390

5/17/2016
1
Advanced Report 
Writer
Presenter: Sharon Halicki, Wayne RESA
Facilitator: Cindy Zemaitis, Oakland Schools
Michigan MISTAR User Conference -5/25/2016
Topics
Report Types
Data Source Field Names
Filters /Comparators
Multiple Qualifiers
Session Variables
Mail Merge Report
Multi-Line Report
Pivot Table Report
Report Output -PDF/Export to Excel
2
Convert pdf to word text online - SDK software service:C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net, ASP.NET MVC, WinForms, WPF application
C# PDF to Text (TXT) Converting Library to Convert PDF to Text
www.rasteredge.com
Convert pdf to word text online - SDK software service:VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net, ASP.NET MVC, WinForms, WPF application
VB.NET Guide and Sample Codes to Convert PDF to Text in .NET Project
www.rasteredge.com
5/17/2016
2
Report Types
Roster Report
Simple Table Listing 
showing rows of data
Data can be sent to pdf  
or extracted to Excel  
Mail Merge
Microsoft Word-based 
report
Great for personalized form 
letters
Pivot Table Report
Excel-based pivot data
Extracts  considerable 
amount of data presented 
in  succinct numerical 
format
Multi-Line Report
Accommodates sophisticated 
design
Allows for use of Sub-Reports 
3
Change Display Name in Data Source
 Data Sources
 View/Procedure/Data Designer 
Source title
When Data Source Fields appear,  enter 
recognizable label
 New Display Name
Submit
ID
Last Name
First Name
4
SDK software service:VB.NET PDF Convert to Word SDK: Convert PDF to Word library in vb.
Convert PDF document to DOC and DOCX formats in Visual Basic control to export Word from multiple PDF files in Create editable Word file online without email.
www.rasteredge.com
SDK software service:C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
Quick to remove watermark and save PDF text, image, table Convert PDF to multiple MS Word formats such as .doc Create editable Word file online without email.
www.rasteredge.com
5/17/2016
3
Change Display Name in Data Source – Report Heading
Changing Data Source Display Name will change Report Heading.
To change 
Report 
Heading, 
use Field 
Properties .
If you are exporting to Excel do not leave spaces between column 
heading words.  Use _between_words to identify column name.
5
Whether or not you’ve changed the Data Source Display Name, you can still changethe 
ReportHeading
Filters
SDK software service:VB.NET Create PDF from Word Library to convert docx, doc to PDF in
PDF to Word, C# extract text from PDF, C# convert PDF to Jpeg, C# compress PDF, C# print PDF, C# merge PDF files, C# view PDF online, C# convert PDF to tiff
www.rasteredge.com
SDK software service:VB.NET PDF - Convert PDF Online with VB.NET HTML5 PDF Viewer
PDF to Word, C# extract text from PDF, C# convert PDF to Jpeg, C# compress PDF, C# print PDF, C# merge PDF files, C# view PDF online, C# convert PDF to tiff
www.rasteredge.com
5/17/2016
4
Using Filters –Default Student Filter
“Built-in”  Default Student Filter 
Provides standard set of filters that 
can be chosen separately or in any 
combination when running the 
report. 
7
You can use data source fields to limit your report result set.
 Filterscan be used alone or in combinations.
 The fields you filter on do not have to be printed/displayed on 
report
 Filtersare literal!  Take care when using the equal/not equal 
comparators.
 Filterscan be used with wildcards ? and      ?^
Using Filters  -Comparators
8
SDK software service:C# HTML5 PDF Viewer SDK to convert and export PDF document to
PDF to Word, C# extract text from PDF, C# convert PDF to Jpeg, C# compress PDF, C# print PDF, C# merge PDF files, C# view PDF online, C# convert PDF to tiff
www.rasteredge.com
SDK software service:C# PDF Text Extract Library: extract text content from PDF file in
But sometimes, we need to extract or fetch text content from source PDF document file for word processing, presentation and desktop publishing
www.rasteredge.com
5/17/2016
5
Available Filters/Comparators 
(dependent upon field type)
9
Using Filter Qualifiers
Single Fixed Value
Combination  Fixed Values
Group Code
Multiple  Fixed Values
Group Code 
(from Group Editor)
Be sure comparison 
values do not to 
contradict each other.
10
SDK software service:VB.NET PDF Text Extract Library: extract text content from PDF
Best VB.NET PDF text extraction SDK library and component for free download. Online Visual Basic .NET class source code for quick evaluation.
www.rasteredge.com
SDK software service:C# Convert: PDF to Word: How to Convert Adobe PDF to Microsoft
C# Convert: PDF to Word: How to Convert Adobe PDF to Microsoft Word (.docx) File. Empower C# users to easily convert PDF document to Word document.
www.rasteredge.com
5/17/2016
6
Filters/Comparators –Wild Cards   ?   and    ?^
?
Prompts user to enter a value when generating 
report
?^
Creates a list of values from which to choose
Name
Must use 
in list 
Comparator with ?^
Comparison Value
Can use Ctrl 
and/or
Shift keys to make 
selection(s)
In List  comparator 
can reduce report 
performance if returning 
large amounts of data
11
Using Session Variables – Report Heading and Filter(s)
Built in session variables provide the ability to dynamically change 
Report Headers, Filters and Parameter Values.
When using a viewas the data source report filters can limit the 
data results.  Below is an example of limitingschool results and 
displayingsystem date using @SystemDateand @SchoolCode. ( 
Case Sensitive)
12
SDK software service:C# HTML5 PDF Viewer SDK to view PDF document online in C#.NET
PDF to Word, C# extract text from PDF, C# convert PDF to Jpeg, C# compress PDF, C# print PDF, C# merge PDF files, C# view PDF online, C# convert PDF to tiff
www.rasteredge.com
5/17/2016
7
Using Session Variables – Report Heading and Filter(s)
You can use more than one session variable in your 
Report Heading
13
@StaffID–Limits report results to logged-in user
@SchoolCode–Limits report results to logged-in 
school
Session Variable examples to limit report results:
Using Session Variables –Stored Procedure Parameter
When using a Stored Procedure as the data source Parameteror Default 
Value can limit the data results.  Below is an example of hidden parameter 
limiting results to the logged-in track.
Show Advanced Options opens additional fields  
Parameters can be visible to allow users to input data; or can be hidden 
(unchecked) and defaulted to a specific value or session variable.
Control Type can be changed to List Box and a SQL statement can be 
added to Value Source to create a drop down list. (requires knowledge of 
sql) 
14
5/17/2016
8
Available Session Variables
Case 
Sensitive!  
Must be used 
exactly as 
shown
15
Mail Merge Reports
5/17/2016
9
Mail Merge Report 
Type
Creating a Mail Merge Report
Available Field  list appears
Select fields and filters  
then Submit to save
17
Manage Documents
Select Create Blank Merge 
Template from drop-down 
Menu
Submit
Creating a Mail Merge Report –Select Template
18
5/17/2016
10
Creating a Mail Merge Report-Working in Word
Incorporate these mail merge fields into your letter/form by typing 
around them/moving them as necessary .  Save completed document to 
your local drive.  Back in MISTAR Q:
Manage Documents
Select Local Document, Choose File and upload your newly saved 
Word Document
Submit
You are now in 
Word…...
Word Document 
contains Report 
Heading Fieldsfrom 
your Q Report in mail 
merge format.
19
Creating a Mail Merge Report –Working in  Word 
Preview
Create Report
The Word Document is stored with the report.  If you decide to alter your original Word 
Document (perhaps after reviewing your report)….you must bring in the newly-revised Word 
Document.  To do so:
Manage 
Documents
Select Local 
Document
Choose File
Navigate to newly-
revised Word 
Document
Submit
20
Documents you may be interested
Documents you may be interested