Skip to main content

Posts

Showing posts with the label Reports

Crystal and Reporting Services Interview Questions - Part 2

Introduction   This FAQ will give you a quick start for two report giant's crystal and reporting services. We have two IIS application 'Reports' and 'Reportserver' what do they do ?   When you install reporting services there are two virtual directories created as shown in the figure below. Figure : - IIS Applications for reports The 'Reports' virtual directory is like an admin. If you browse to http://yourpcname/reports/home.aspx   page you can view, edit properties and display reports. We have numbered the below figure. 1 à We can browse reports and see the output of reports. 2 à We can upload a RDL file directly in the report's database. 3 à Using the report builder link we build new reports. 4 à Using the properties we can do role assignment. 5 à Using subscription link we can add new outputs (FTP, Folder etc) to subscribe to the reports. 6 à Site settings help us to decide how many numbers of snapshots we want in the history, report time out...

Crystal and Reporting Services Interview Questions - Part 1

Introduction   This Interview Questions will give you a quick start for two report giant’s crystal and reporting services. How do we access crystal reports in .NET? Crystal reports comes with Visual studio setup itself. Right click the solution explorer a add new item and you can see a crystal report template as shown in figure ‘Crystal report template’. You can add an ‘.rpt’ file using this template. Figure 1:- Crystal report template What are the various components in crystal reports?   There are four major components in crystal reports Report designer, Reports engine, Report viewer and object models. Report designer gives a graphical interface to create and modify reports. To view the designer add a new crystal report file and double click on it you should see the report designer as shown in figure ‘Report designer’. Figure 2 :- Report designer Reports engine does the formatting and conversion part of crystal reports. It helps convert the contents of report...