SSRS COMPLEX SCENARIOS & SSRS IMPORTANT SCENARIOS

SCENARIOS 1:

=======================================================================

NEED A COMPLEX REPORT FOR THE YEARS BETWEEN 2000-TILL THIS YEAR WITH SUM, AVG OF INCOMES WITH PROFITS PERCENTAGE.EACH YEAR DISPLAYS VARIOUS LOCATIONS INFORMATION.FOR EVERY LOCATION I WOULD LIKE TO SEE THREE KINDS OF INFORMATION

      A)     SALES INFORMATION IN TABLE FORMAT

      B)      MANUFACTURING INFO IN CHART

      C)      PRODUCTION VS RAW MATERIALS INFO IN MATRIX FORMAT.

ANS:

CREATE PROCEDURE WHICH RETURNS SUM,AVG,PERCENTAGE BETWEEN THE YEARS 2000-TILL TODAY.

CREATE A DATASET FOR THAT.

TAKE MAIN REPORT->USE YEAR,LOCATIONS, AGGREGATE INFO,TAKE SUBREPORTS HOW MANY LOCATIONS YOU HAVE.

CREATE CHILD REPORT WITH TABLE,CHART AND MATRIX AND DISPLAY BY USING PARAMETER CONTENT.

SCENARIOS 2:

 

=======================================================================

DISPLAY  IN EVERY LOCATION  FOOTER SECTION,COLORS RED AND YELLOW BASED ON AGGREGATE INFO.

CREATE TABLE LOC_INC(ELOC VARCHAR(30),INC1 INTEGER,INC2 INTEGER,INC3 INTEGER);

INSERT INTO LOC_INC VALUES('HYD',1000,2000,3000);

INSERT INTO LOC_INC VALUES('HYD',2000,3000,4000);

INSERT INTO LOC_INC VALUES('HYD',3000,2000,3000);

INSERT INTO LOC_INC VALUES('CHE',1000,2000,3000);

INSERT INTO LOC_INC VALUES('CHE',2000,3000,3000);

INSERT INTO LOC_INC VALUES('CHE',2000,4000,4000);

INSERT INTO LOC_INC VALUES('MUM',3000,2000,3000);

INSERT INTO LOC_INC VALUES('MUM',3000,2000,4000);

INSERT INTO LOC_INC VALUES('MUM',2000,2000,3000);

=iif(avg(Fields!INC1.Value, "ELOC")<>min(Fields!INC1.Value, "ELOC"),"red","yellow")

TAKE THIS IN EVERY CELL OF INC1,INC2,INC3--GROUP FOOTER  UNDER FILL EXPRESSION.

SCENARIOS 3:

=======================================================================

DISPLAY PERCENTAGE OF VALUE IN THE GROUP  LIKE BELOW.

(THE VALUE SHOULD BE THE RESPECTIVE PERCENTAGE OF THE DEPT)

Take Matrix report ,Add new row->below-> Take two place holders

One place holder->sum(fileds!partyincome.value)/sum(Fields!partyincome.value,”dst”)

SCENARIOS 4:

 

=======================================================================

DISPLAY  A CHART REPORT,SCALE SOULD BE TILL THE MAXIMUM VALUE AND
LABEL SHOULD INDICATE THE PERCENATE OF VALUE IN THE TOTAL ALL
LOCATIONS.

Take chart, category section and sum(partyincome) in data values section.

Vertical axis properties->min value auto, maxvalue->sum(partyincome,”dst”),increment->50000

Data label properties->

=cstr(round(sum(Fields!PARTYINCOME.Value)/Sum(Fields!PARTYINCOME.Value, "DataSet1") * 100 )) & "%"

SCENARIO 5:
======================================================================
DISPLAY OUTPUT LIKE BELOW FROM THE SPECIFIED INPUT

 

 

SCENARIO 5:

I NEED TO WRITE AN SSRS EXPRESION TO CHECK AND REPLACE NULL WITH ANOTHER FIELD VALUE…HOW DO YOU DO THAT?

=IIF(ISNOTHING(F1),F2,F2)

Explain about Choose function…

Choose(eid.value,”one”,”two”,”three”,”four”) –english translation

Displaying only date from datetime

=FormatDateTime(Today(), DateFormat.ShortDate)

 

SCENARIOS

CAT1

          SUBCAT

                SUBSUBCAT

          SUBCAT

               SUBSUBCAT

ETC… USING DRILL DOWN

SCENARIOS

NEED REPORT , TWO PARAMS AVAILABLE.WHEN CAT YOU SELECT SUBCAT ITEMS SHOULD DISPLAY.

WHEN ALL CATS SELECTED , NO SUBCAT REQUIRED.CREATE  SUCH A WAY

SCENARIOS

Need a report which take four params ,if all selected then only report required (not cascaded)

 CHART ADDITIONAL:

 Take pie chart.

 

SC1:LESS THAN THE SPECIFIED PERCENTAGE VALUES INTO SINGLE SLICE

 In the General section, expand the CustomAttributes node.

Set the CollectedStyle property to SingleSlice

 Set the CollectedThresholdUsePercent property to True.

Set the CollectedThreshold property to 10.

 

SC2:LESS THAN THE SPECIFIED VALUES INTO SINGLE SLICE

 In the General section, expand the CustomAttributes node.

Set the CollectedStyle property to SingleSlice

 Set the CollectedThresholdUsePercent property to False.

 Set the CollectedThreshold property to 5000.

 

SC3:TO COLLECT SMALL SLICES INTO A SECONDARY, CALLOUT PIE CHART

 

In the General section, expand the CustomAttributes node.

 set the CollectedStyle property to CollectedPie

 Set the CollectedThresholdUsePercent property to True.

 Set the CollectedThreshold property to 10.