Activity overview
Latest activity by KathiK
Need an author
I've had a request for an article about transitioning from Entity Framework to developing T-SQL directly. If anyone has experience in this and would be willing to write an article for Simple Talk, ...
Week 5 video is available
See week 5 https://youtu.be/LUtuR4d7YZs
Week 4 Video
https://www.youtube.com/watch?v=jjIsmcMzMew&list=PLhFdCK734P8D3_iyp_nStc0RWfz0zJ6o9&index=18&t=0s
Assuming that the first parameter is called @Type and it returns a string of either "DepartureDate" or "ReturnDate" then this query would work: SELECT DepartureDate AS TheDate FROM Schedule WHERE 'DepartureDate' = @Type UNION ALL SELECT ReturnDate FROM Schedule WHERE 'ReturnDate' = @Type / comments
Assuming that the first parameter is called @Type and it returns a string of either "DepartureDate" or "ReturnDate" then this query would work: SELECT DepartureDate AS TheDateFROM Schedule WHERE 'D...
Probably the easiest way to do this would be to have the second drop down be based on a stored procedure that has an IF so that the correct query runs. But, you might be able to do something with a UNION of the two queries. I have a meeting in a couple of minutes, but I'll get back to you with some pseudocode after that. / comments
Probably the easiest way to do this would be to have the second drop down be based on a stored procedure that has an IF so that the correct query runs. But, you might be able to do something with a...
I'm thinking that you probably want to use a stored procedure for the dataset if your data is in SQL Server. / comments
I'm thinking that you probably want to use a stored procedure for the dataset if your data is in SQL Server.
Can you upload an image of what this report looks like? / comments
Can you upload an image of what this report looks like?
I'm assuming you mean these reports are published in the Web Portal. You need to have permission to the report (content manager, publisher, or report builder). Click the ellipsis next to the report name. Select Download to get the report definition. You can then pull it into a report project in VS. / comments
I'm assuming you mean these reports are published in the Web Portal. You need to have permission to the report (content manager, publisher, or report builder). Click the ellipsis next to the report...
Are you saying that the dataset of the first dropdown changes? I'm not sure how that would work. / comments
Are you saying that the dataset of the first dropdown changes? I'm not sure how that would work.
Week 3 video is available
https://www.youtube.com/watch?v=yLqw-60VOyg