Sfrgttk

Is layered encryption more secure than long passwords?

How to draw these kind of adjacent ovals with arrows in latex?

How can I portray body horror and still be sensitive to people with disabilities?

Father gets chickenpox, but doesn't infect his two children. How is this possible?

General derivative of the exponential operator w.r.t. a parameter

Why did Tywin never remarry?

Why do BLDC motor (1kW) controllers have so many mosfets?

How to fetch users in particular domain programmatically in Sitecore9

Does a star need to be inside a galaxy?

Pictures from Mars

Ethernet cable only works in certain positions

How to make my enemies feel real

How to play song that contains one guitar when we have two guitarists (or more)?

Can a planet be tidally unlocked?

Is 'bad luck' with former employees a red flag?

Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?

How to assess the susceptibility of a U.S. company to go bankrupt?

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Can I legally make a website about boycotting a certain company?

Which was the first story to feature space elevators?

Identical projects by students at two different colleges: still plagiarism?

Why does finding small effects in large studies indicate publication bias?

How to make clear what a part-humanoid character looks like when they're quite common in their world?

Is a 1hr 3min layover at ORD (Chicago) enough when coming in international?

Conversion failed when converting from a character string to uniqueidentifier

Conversion failed when converting date and/or time from character stringHow to pass multi-valued characters in SSRS Report?Date picker is dynamic in SSDT but not in SSRSConversion failed when converting date and/or time from character stringSSRS 2014 - query running fine on management studio - report timing out - how to troubleshoot?Conversion failed when converting date and/or time from character string while inserting datetime sql server“Conversion failed when converting date and/or time from character string”Averaging 2 values based on an ID in SSRSConversion failed when converting date or time from character string error?SSRS Rectangle visibility based on Parameter Value

0

I am creating a Dynamic CRM 2011 Report in SSRS.
I use several joins, And use GUID in joins.
For ex :

Quote.OpportunityId=Opprtunity.OpportunityId

The problem comes from parameters.
I have a parameter which its label is a name and the value is GUID of a record.
I retrieve them from a Dataset.
The query of the this Dataset(named siteDataset) is this :

select site.SiteId, site.Name from Site;

the siteId goes to the value of the parameter and site.name goes to the label of the parameter, the Parameter is named siteId itself.

But when I try to do this in another DataSet :

siteGUIDInAnotherEntity='@siteId'

Give me the subject Error.
I even tried this :

CONVERT(VARCHAR(50), site.SiteId)

in siteId DataSet; But no success.

Any help will appreciated.

sql-server reporting ssrs-2008-r2

share

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am creating a Dynamic CRM 2011 Report in SSRS.
I use several joins, And use GUID in joins.
For ex :

Quote.OpportunityId=Opprtunity.OpportunityId

The problem comes from parameters.
I have a parameter which its label is a name and the value is GUID of a record.
I retrieve them from a Dataset.
The query of the this Dataset(named siteDataset) is this :

select site.SiteId, site.Name from Site;

the siteId goes to the value of the parameter and site.name goes to the label of the parameter, the Parameter is named siteId itself.

But when I try to do this in another DataSet :

siteGUIDInAnotherEntity='@siteId'

Give me the subject Error.
I even tried this :

CONVERT(VARCHAR(50), site.SiteId)

in siteId DataSet; But no success.

Any help will appreciated.

sql-server reporting ssrs-2008-r2

share

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am creating a Dynamic CRM 2011 Report in SSRS.
I use several joins, And use GUID in joins.
For ex :

Quote.OpportunityId=Opprtunity.OpportunityId

The problem comes from parameters.
I have a parameter which its label is a name and the value is GUID of a record.
I retrieve them from a Dataset.
The query of the this Dataset(named siteDataset) is this :

select site.SiteId, site.Name from Site;

the siteId goes to the value of the parameter and site.name goes to the label of the parameter, the Parameter is named siteId itself.

But when I try to do this in another DataSet :

siteGUIDInAnotherEntity='@siteId'

Give me the subject Error.
I even tried this :

CONVERT(VARCHAR(50), site.SiteId)

in siteId DataSet; But no success.

Any help will appreciated.

sql-server reporting ssrs-2008-r2

share

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Quote.OpportunityId=Opprtunity.OpportunityId

select site.SiteId, site.Name from Site;

siteGUIDInAnotherEntity='@siteId'

CONVERT(VARCHAR(50), site.SiteId)

share

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

alireza azadialireza azadi

33

New contributor

alireza azadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 6 mins ago

alireza azadialireza azadi

33