Viewing 15 posts - 181 through 195 (of 3,544 total)
Not sure of your exact requirement but
UPDATE #table SET num = -(num + 1) WHERE num >= 5;
UPDATE #table SET num = 5 WHERE num = 0;
UPDATE...
Far away is close at hand in the images of elsewhere.
Anon.
June 10, 2019 at 12:57 pm
What do you mean by "a stacked timeline".
What is being stacked?
You can pad columns like this
=Space((RowNumber("DataSet1") - 1) * 4) & Fields!FieldNameFar away is close at hand in the images of elsewhere.
Anon.
June 6, 2019 at 12:54 pm
If you have a table for the times CREATE TABLE HoursList ( HourNumber TINYINT PRIMARY KEY , TimeSpan VARCHAR(10) NOT NULL ); Then you insert values for each INSERT...
Far away is close at hand in the images of elsewhere.
Anon.
May 22, 2019 at 7:42 am
I could be wrong but it looks like all of that only covers SQL Server. If there's something else on the box that's putting the hammer to CPU or...
Far away is close at hand in the images of elsewhere.
Anon.
May 22, 2019 at 7:41 am
Hi David, Thank you so much for the reply. The ISNULL in the SQL query was just the thing and it all works a treat now. Thank you so...
Far away is close at hand in the images of elsewhere.
Anon.
May 20, 2019 at 7:52 am
Actually my post was too much as you are already retrieving the address lines.
The only things I can suggest are (if you have not done so already)
Change the SQL query...
Far away is close at hand in the images of elsewhere.
Anon.
May 17, 2019 at 3:51 pm
Sorry my bad, I have fixed my post.
You will have to remove feeRef from the query to prevent the other errors.
If you require feeRef then unless there is only one...
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 2:01 pm
I think your problem is not the multiple values of feeBufFee but the repeated values due to multiple rows from the other joins.
If you change the Earners join to
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 1:25 pm
Create a dataset that selects the address lines and set each address line parameter to use default from the dataset and use the parameter values in the report.
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 1:07 pm
How would you identify which Earners.feeBudFee to select out of the many?
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 12:58 pm
David you are an absolute legend. That worked perfectly Thank you 🙂
Your welcome and thanks for the feedback 🙂
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 10:20 am
PostingDetailsDate returns a date and time, not sure if thats the issue. Not even sure how to use the CDbl expression
=Sum(
CDbl(
IIF(Year(Fields!PostingDetailsDate.Value)=Year(ToDay)
AND Month(Fields!PostingDetailsDate.Value)=Month(ToDay),
Fields!SplitBillsMasterSplitAmount.Value,
0)
)
)
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 9:48 am
If you are not getting a syntax error then the problem is almost certainly to be the data.
Is PostingDetailsDate a date or is it varchar containing a date?
I have also...
Far away is close at hand in the images of elsewhere.
Anon.
May 16, 2019 at 7:52 am
Thanks David I got the following error The Value expression for the textrun ‘SplitBillsMasterSplitAmount.Paragraphs[0].TextRuns[0]’ contains an error: [BC30451] Name 'PostingDetailsDate' is not declared.
Sorry my bad, missed of Fields...
Far away is close at hand in the images of elsewhere.
Anon.
May 15, 2019 at 3:56 pm
This should give you what you want
=Sum(
IIF(Year(Fields!PostingDetailsDate.Value)=Year(ToDay)
AND Month(Fields!PostingDetailsDate.Value)=Month(ToDay),
Fields!SplitBillsMasterSplitAmount.Value,
0)
)
Far away is close at hand in the images of elsewhere.
Anon.
May 15, 2019 at 1:19 pm
Viewing 15 posts - 181 through 195 (of 3,544 total)