Viewing 15 posts - 1 through 15 (of 33 total)
Thanks for the clarity on this - I think when I tried to extend my test query I put the On's one after another rather than at the end of...
December 31, 2020 at 1:32 pm
Hi,
Thanks I managed to get this sorted by creating 2 queries and then joining them together. Where I was struggling was where I was placing the max element.
December 14, 2020 at 9:27 pm
Hey Phil
Thanks for coming back to me. Ive probably not explained myself properly and maybe grouping is the answer. The code column can contain multiple duplicate records each of these...
December 14, 2020 at 10:15 am
Thanks again, and you'll have to excuse me my SQL is still at its early stages.
If I use the following query
Select STKTraceItemBatchAttribute.TraceableItemID,
STKTraceItemBatchAttribute.Title,
...
January 3, 2020 at 2:00 pm
Thanks Thom I was trying to structure the data as you mentioned rather than uploading images but the layout was going all cockahoot. Is there a way to insert a...
January 3, 2020 at 1:12 pm
Hi,
When you say I might be passing Fields!users_text04.Value as a string how do I check? I thought that having "'s around the value defines what it is? On the properties...
March 21, 2019 at 11:07 am
March 18, 2019 at 5:49 am
March 15, 2019 at 10:14 am
Hi,
I've given it a go and it seems to work although I cant seem to set a parameter on the data now I am using a stored procedure? Before I...
March 15, 2019 at 4:14 am
March 14, 2019 at 2:41 am
I think the reason for the loading loop and SQL Report Builder crashing when I run this report is something to do with the date selection format I have set...
March 8, 2019 at 2:30 am
Thanks Sue but I may be confusing my original question. I was struggling with my original question (which I was developing in SSMS and saving it as a view to...
March 7, 2019 at 9:14 am
Sorry the query was timing out - I have managed to get it working within SSMS by adding
Declare @theDateDATETIME
Set @TheDate ='2019-03-04'
and then using...
March 7, 2019 at 7:44 am
Hi,
Any reason why my SWITCH statement isn't returning any values?
=SWITCH(Fields!PAL_product.Value = "R00505", "TEST")
March 1, 2019 at 9:22 am
Thanks I've got to be honest I don't fully understand your reply am I correct in thinking if the user doesn't select anything then it parses all? I managed to...
February 26, 2019 at 8:38 am
Viewing 15 posts - 1 through 15 (of 33 total)