Friday, May 13, 2016

Salesforce Interview Questions-Reports & Dashboards Part-1

1. What are different types of reports?
  • Tabular report. This is the most basic report. It displays just the row of records in a table like format with grand total. Tabular reports cannot be used for generating dashboards.
  • Summary report. This is the most commonly type of report. It allows grouping of rows of data. It supports sorting and displaying subtotals. For example in a recruiting app, a summary report could be used to display open positions classified by department name.
  • Matrix report. This is the most complex report format. Matrix report summarize information in a grid format. Matrix reports allows records to be grouped by both columns and rows.
  • Joined Reports: Joined reports let you create multiple report blocks that provide different views of your data. Each block acts like a “sub-report,” with its own fields, columns, sorting, and filtering. A joined report can even contain data from different report types.
2. What all reports can be used to generate dashboards?
Summary and Matrix reports

3. What all things are not supported in joined reports?
The following items aren’t supported in joined reports, and aren’t converted:
  • Bucket fields
  • Cross filters
  • The Rows to Display filter
4. What are bucket fields?
Bucketing lets you quickly categorize report records without creating a formula or a custom field. For example, create a bucket field named Size based on the # Employees field. Then, create buckets that group records into “Large,” “Medium,” or “Small” ranges that you define. Bucket fields can be used like any other field to sort, filter, and group your report.
You can add up to five bucket fields per report, each with up to 20 buckets. Only numeric, picklist and text field can be used for bucketing. Other data types are not supported.

5. Can we create a formula type in reports?
Formula are not available in tabular reports but available for other report types.
Formula can be only in number, currency and percent format.

                                                                                Reports & Dashboards-Part 2


  1. I would like to thank you for the efforts you have made in writing this blog

  2. Thanks for sharing useful info!
    looks great
    We are Top in salesforce Online Training Hyderabad@Capitalinfo solutions. We provide quality training for salesforce, Devops with realtime project+Placement Assistance
    slaesforce online training
    slaesforce Integration training
    slaesforce online training

  3. Great Article. Thank you for sharing! Really an awesome post for every one.

    IEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

    JavaScript Training in Chennai

    JavaScript Training in Chennai

  4. Share wonderful details concerning your blog site, Blog truly useful for us. Annual Report Inner Page Design

  5. I rejoice to this blog offering distinct as well as handy understanding regarding this subject. Branding

  6. This blog is really helpful to deliver updated affairs over internet which is really appraisable. Bakery Layout

  7. Great blog ! I am impressed with suggestions of author. Wordpress Help

  8. Share wonderful details concerning your blog site, Blog truly useful for us. Digital Marketing In Lucknow

  9. Thanks a lot for sharing a posts with valuable information
    salesforce administrator training.

  10. last question i dont understand proper ...whats is formula type in report?

  11. You truly did more than visitors’ expectations. Thank you for rendering these helpful, trusted, edifying and also cool thoughts on the topic to Kate
    Best Project Management Software

  12. how many record can be seen when you run you run report

  13. how many record can be seen when you run you run report