Comments
Sort by recent activity
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...
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...
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...
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 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.
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.