Viewing 15 posts - 181 through 195 (of 3,543 total)
What do you mean by "a stacked timeline".
What is being stacked?
You can pad columns like this
=Space((RowNumber("DataSet1") - 1) * 4) & Fields!FieldName 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...
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...
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...
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...
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...
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
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.
May 16, 2019 at 1:07 pm
How would you identify which Earners.feeBudFee to select out of the many?
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 🙂
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)
)
)
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...
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...
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)
)
May 15, 2019 at 1:19 pm
Not a problem. Happy to help. Hopefully we hear from a few others as well. There is some degree of disagreement on this topic.
Not from me 🙂
May 15, 2019 at 1:04 pm
Viewing 15 posts - 181 through 195 (of 3,543 total)