Error logging is the best you can do...

Is happening again or just once...

have you checked whether you are still connected to DB.

hello Pam,

You can use ISNULL(value_to_check,default_value)

So if value_to_check is NULL it is replaced by default_value else not.

Have you tried the query with FULL JOIN

Hi,

I would suggest http://www.databasejournal.com

and then search MDX

Pradeep,

you can use expressions. the values of Header fields can be manipulated using the values of certain selecteion you make...such as parameters....

Hope this helps.

Thought you required answer...turned the other way round...cheerz!!! 😀

Creating parameters in SSRS is step one...done

have you referenced those variables in your underlying dataset SQL query

Creating parameters in SSRS is step one...done

have you referenced those variables in your underlying dataset SQL query

Hi Pam,

It is bound to happen....you can use FULL JOIN.

Also can you provide some snapshots

Hi,

The values in SSRS are only returned as NULL if source field is null or is empty....

In either case you can use the derived column data flow task to manipluate...

HI,

Try the following syntax:

CREATE TABLE "@SELECT"

(

COLUMNNAME VARCHAR(20)

)

select * from "@select"

Also remenber to enable the Set Quoted identifier property....

Can you suggest a certification for BI and any pre-requisite. if any.

Many Congratulations for the achievement.

Can you please specify the Exam module number for BI certs...

I was earlier told that SQL Server certs are a prequisite before appearing for BI certs......

Thank you.

Can you please specify the Exam module number for BI certs...

I was earlier told that SQL Server certs are a prequisite before appearing for BI certs...