Viewing 15 posts - 91 through 105 (of 134 total)
Any given tablix can only be associated with one dataset at a time, but there are two ways to accomplish your goal that I can think of.
First, you could create...
May 16, 2013 at 8:51 am
Thanks, I will give this a try. For the time being I just told the customer to hold down the Ctrl key while they click. I even put that into...
May 16, 2013 at 7:11 am
It's more about the order of operations than the format of the string. You must first convert the string to a decimal type before you put it into the NULLIF()...
May 15, 2013 at 8:17 am
Unless you can create a dataset that joins the tables together from the two datasets you have now, you will have to use a LookupSet function to return each value...
May 15, 2013 at 7:04 am
In this case the SQL server, report server, and my local machine are all one and the same. My locale is English (United States).
May 14, 2013 at 1:38 pm
A foreign key constraint requires that the value exist in the foreign table, so adding two foreign key constraints means that the value you add to T3 must exist in...
May 4, 2013 at 9:33 pm
Rather than populate a variable with a subquery, use a simpler subquery directly inside the IN value list position, like this:
select * from scpcommandeventlog where messageid = 3 and param1...
May 4, 2013 at 1:06 pm
The parameter name is misspelled as "Stauts," which could be the main issue. Also, if the original status values are integers, then you should change the Data type of the...
May 3, 2013 at 8:44 am
I'm not certain that the parameter value has been configured correctly. There should not be any list of values like that in the parameter setup. Each value/label pair needs to...
May 1, 2013 at 8:24 pm
If you can post a screenshot of the complete error message, I might be able to point to a possible resolution for the error.
April 30, 2013 at 6:37 pm
I cannot say if the error you are receiving is directly related to the multivalue parameter option, but I can tell you that the only comparison operator that works with...
April 30, 2013 at 1:12 pm
To extract the year value, my suggestion is to use a SUBSTRING function instead of nested LEFT and RIGHT functions. This is possible if the four digits of the year...
April 29, 2013 at 9:07 pm
The start of such a solution would be to create ten additional parameters corresponding to the ten you already have: for Param1 have a Param1Type parameter; for Param2 have a...
April 29, 2013 at 8:24 pm
It is not possible to assign formatting to an entire row with a single property. However, you can select all the text boxes that make up the row and then...
April 29, 2013 at 4:36 pm
Every parameter has a "Value" and a "Label." The "Value" is what the parameter passes to any filter or query variable reference to itself. The "Label" is what shows to...
April 29, 2013 at 2:25 pm
Viewing 15 posts - 91 through 105 (of 134 total)