Attached sample screen for empty space (in report header) while passing single parameter value.

Note: we have multiple (6) level of groups in the table.

we need to display Report parameter value...

Hi, I tried with 2 option.

Thing is Report body section start with some empty space while passing single parameter value.

i.e. there will be space between the header and body...

.

Thanks for Your suggestion. Let me check with my Client.

Thanks Lot.

Hi,

I've applied in sub report level.

Sub report group properties->visibility(show or hidden based on exp)

=IIF(RowNumber("DataSet") > 0, False, True)

& Mentioned no row message in sub report tablix property...

I'm getting No data...

Awesome!...

When i use "Field!"value in subreport working fine.

Another thing is,I trying to display No data Message when particular sub report don't have records.

Can you give me idea on these.

Thanks

HI,

I've subreport item in Main report.

I will be invoking the subreportin general property ( by selecting subreport in drop down list)

parameter mentioned as -> =Join(Parameters!GroupLEVEL3DATADistrict_ID.Value, ",") in sub report property...

HI,

I will be using Tablix for the design.

Thanks,

Thanks, when I use this option, Excel values are precedes with ' code.

Is any work around to remove the ' code in reporting side.

Ty

J

Thanks for your reply,

But I want to insert below selected values to another table by random way.

Ex:

select Distinct code_id from Pri_codes_master

where code_description like '%assignment%'

--ORDER BY NEWID()

Cod_id...

Thank you so much. We are trying analysis & priorities the report complexity based on the certain constrain (Generalized manner-it’s not based on requirement).

I got input from your points. Thanks.

Hi,

Data-type for those date columns in the COALESCE is varchar 10 and 8.

Thanks,

Thanks For your reply…

But I am facing issue while changing the data type from INt32 to double.

Let me explain some more detail my task..

I have 2 data...

Thanks For your Reply.

There is some change in my Expression.

It is like (Row_count(tblA) -Rowcount(tblB)) / Row_count(tblA) *100

I have changed the your Expression based on my modification. As...

Thanks, ya, i refered the link.but still i'm facing issue.

My case is like...

I have created 2 variables data type as int32 in package level scope, which holds the 2 row...