Software training videos from a leading UK-based training company. Learn useful techniques in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access, Microsoft PowerPoint, Microsoft Word and more!
Hi! You'll need to create some sort of date table that contains an entry for each month and combine this with your existing data. You can see some suggestions on how to do this here: stackoverflow.com/questions/45890909/ssrs-display-all-months-in-a-year-with-no-data stackoverflow.com/questions/44549413/ssrs-how-to-show-all-month-of-a-year-as-x-axis-of-a-graph
Hello Andrew, Your videos are fantastic, love the passion in your voice. Actually i have one question and hope that you will help me even though this video is 2y old. But when i put in vba the formula ....FindElementByClass(...).Click i have a debug which says "Run - time error "32" : Invalid selector Error invalid selector From java script error {"status":32 " value : "Compund class names not permitted"} (sessio info: Microsoft Edge = 126.0.2592.87) Driver info: msedgedriver = 126.0.2592.87 and some random numbers and letters.platform=Windows. Do you know maybe hot to repair it ? Thank you for the help
Hi! You might find this video helpful ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lr7CFZEI2YA.htmlfeature=shared I'm fairly certain I mention compound classes in there and it provides various other options for finding elements that you should find useful. I hope it helps!
we can also do like this OR(ISBLANK(Movies[Box Office]),Movies[Budget]) as it's only two values are evaluated rather than using two pipes || for OR condition
Indeed you can! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KNt5NI5kAbg.htmlfeature=shared&t=1207 Although you need to include the ISBLANK function for Budget as well as for Box Office: OR( ISBLANK(Movies[Box Office]), ISBLANK(Movies[Budget]) ) Personally, I prefer pipes because they work regardless of how many conditions you're using, while OR only works for two conditions.
Hi! The add-in does not need to contain Sub procedures (but you can include them if you want to). If you want to use the functions in the worksheet they need to be public. If you don't declare a function as Private, it will be Public by default. I hope it helps!
Hi! Carry on watching the playlist and you'll get to the videos on optional parameters ru-vid.com/group/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&feature=shared I hope it helps!
Hi, Thank you for your amazing tutorials, they are very clear. It has helped me developing many reports and improve my skills. I have question, Can you please explain how to pass a user defined table type to SP in Report builder? I would really be Grateful if you can help me. Thanks.
Hi! Happy to hear that you enjoy the tutorials. Sorry but I don't know how you'd pass a user-defined table type from Report Builder to a stored procedure.
Hi Andrew, can you help me with the following please? Case Complexity 1 = CALCULATE( COUNT('Cases'[Case Number]), DATESYTD('Cases'[Resolution Date],"3-31"), 'Cases'[statecode] = "Resolved", 'OS Case Complexity'[Value] = 1) I'm getting this error message and no matter what I try I can't fix thing: Couldn't load data for this visual MdxScript(Model) (320, 5) Calculation error in measure 'New KPI Measures'[Case Complexity 1]: DAX comparison operators do not support comparing values of type Text with values of integer. Consider using the Value or Format function to convert one of the values
Hi! Without seeing your data model I would guess the problem lies with this part: 'OS Case Complexity'[Value] = 1 I'm guessing that the [Value] field is stored as text rather than a number. You could either change the data type of the column in the data model, or enter the number as a string like so: 'OS Case Complexity'[Value] = "1" Let me know if that helps!
Hi Andrew. I've benne using so many times your lessons that i fell like we know each other since 30 years!!!!! Thank you! I'm facing a new issue. Trying to delete a row in a database, i've got this error: 2147467259 ISAM pilot. Do you know how i can fix this please ?
Hi! Thanks for watching so many of the videos! Unfortunately, the SQL DELETE statement for deleting rows in a worksheet using ADO isn't supported. You can use the INSERT and UPDATE statements however, as later videos in this playlist show ru-vid.com/group/PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK&feature=shared
Hi Andrew, I like your video but there is alot of overlapping stuff. Would it be possible if we could shorten and recomend based on the one that is most useful? For example, concatenate can only use for 2 values, instead if we use & or combine value are even much better. The reason is because I learned the concatenate and I need to let go of it to learn the another 2 which are better. Thank you.
tutorials are awesome....very well explained...though not sure why he refers to himself as sven ..since after the video feed goes off ..its still him talking ..not some other person called sven
I would like to echo the comment by @robworcester, I first began watching WiseOwlTutorial videos in 2016. There's loads of content on these subjects from many providers, but I always find myself coming back to this channel. The presenter (I believe I read in comments the name is Andrew), he has an amazing gift for taking some pretty heavy & intimidating applications/languages, and he breaks them down into very clear and understandable demonstrations that are really enjoyable to follow-along with. The skills I have developed and use every day to earn a living were first planted and nurtured by the wonderful content of WiseOwlTutorials videos, thank you so much for making these videos, you are the one of the best teachers I have ever had the pleasure of learning from.
I wrote the same vba code, but I keep getting the error that the format is out of order when I run the PrvSideber Java phrase, so please tell me how to solve it..
Yes! See this video for how to control the rows on each page ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nBYn1DU3VMQ.html To make sure the headers appear on each page you may also need to set the KeepWithGroup property of the Static member to After as described here stackoverflow.com/questions/11285923/tablix-repeat-header-rows-on-each-page-not-working-report-builder-3-0 I hope it helps!
I occasionally get issue with SSRS whereby it times out when running a new report despite the background SQL running speedily in SQL management studio. If I somehow manage to get the report to run once in SSRS in then subsequently runs very quickly (I assume because the rendering has been cached?). Anyone also know of this error and have any fixes? Thx
Hi! You may find the information here (and the associated articles in the menu on the left) useful learn.microsoft.com/en-us/sql/reporting-services/report-server/setting-time-out-values-for-report-and-shared-dataset-processing-ssrs?view=sql-server-ver16 I hope it helps!
Hi! We could have used the FILTER function here, I just chose to use CALCULATETABLE instead. You can find a later video in the playlist which explains the differences ru-vid.com/group/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX&feature=shared I hope it helps!