GilaMonster (4/12/2012)

---

tt-615680 (4/12/2012)

---

I was thinking of creating another user with a similar privileges as the SysAmin user but what would be the advantage of creating yet another user, which would...

Thank you all for all your comments and opinions!

I was thinking of creating another user with a similar privileges as the SysAmin user but what would be the advantage...

Thank you for your reply!

I used the following expression and it worked

=(IIF(IsNothing(Fields!Planneddate.Value), Fields!appl_status_date.Value,IIF(IsNothing(Fields!ActualDate.Value),"",Fields!ActualDate.Value)))

Thank you!

Thank you for your reply!

The report result should look like the following:

City ...

Thank you for the reply!

No, the expression is: =(Fields!ThisWeekTotal.Value)/SUM(Fields!Total.Value) but it still gives an error

Thank you!

anthony.green (3/19/2012)

---

unsure on that, what I would ask you do is post the query in question, along with data DDL and the rdl file, and detail what the results should...

anthony.green (3/16/2012)

---

1st error, lookup requires 4 parameters, if you used my above expression it only passes in 3.

2nd error, you have a extra function like MIN/MAX/AVG/SUM etc somewhere else which...

I changed the query to what you've suggested, but it now gives the following error messages:

[rsWrongNumberOfParameters] The Value expression for the textrun ‘Textbox52.Paragraphs[0].TextRuns[0]’ has an incorrect number of parameters...

Thank you!

Daniel Bowlin (3/6/2012)

---

Rather than use a text based query with EXEC spname, just set the dataset to use a stored procedure directly. There is an option in the dataset...

Thank you for your response!

I'm trying...

Here is my scenario:

We have an application which we use C#, but the way the Architecture for creating the Application is that only Views can be used to get...

Thank you for replying anyway! I created a rule to for Service Broker to have access, which is port 4022.

Thank you.

I had to unintall and reinstall SQL Server and everything is working good. I first took a backup of the data before I did anything.

Thank you very much for your...

Jeffrey Williams-493691 (7/26/2011)

---

Do you have a query window open with a connection to that server?

Gus has asked this multiple times, and you still have not answered that question.

Do you have...