Thank you for replying.

@Jeffrey Williams -

So the datetime data in transactional DB system is always stored in UTC. This datetime data is then converted in whatever timezone the user wants...

• This reply was modified 3 years, 7 months ago by  H4K.

In SSIS, the data type for this column is DT_NUMERIC is that causing the problem?

Need to check 2 things here:
1) If there consists variables(SchoolName) with same name but in different scope
2) If the query to get school name bringing any NULLs.

does opening the script and compiling and saving it resolve this issue for may be a single package ?

Solved that by MultiLookUp ssrs function. Thanks

How can i do that...

To add to the 1st reply above :

1) You should know the syntax of MDX also how does it work.

2) What are the functions in MDX ?

3) You should also...

Does anyone have suggestions on how to handle the grouping, parameters, datasets, really anything so that I can list multiple properties in this table, but each row only references the...

First of all, you have make this "WHERE RMPROPID = @PROPERTIES"

to this "WHERE RMPROPID in (@PROPERTIES)".

what is the datatype of the column 'ID' in the database table ?

Check this out : http://stackoverflow.com/questions/5388398/format-number-in-ssrs-report

it can't be achieved, as i had face a similar situation.

The user has to deselect the 'All' when choosing other values.

When you create a group, select 'Add group header' to add a header to the group.

Now a header is added as well as a column.

Delete the column by...

What is the sql query to get the data ?