I have a SELECT statement which returns a result, depending on the selection the users make (application written in Visual Basic 2005). I want to export the result of the SELECT statement to a Excel file (.csv, or .txt). How should I proceed?
Are you using SSIS? Can't you just write out the data from the VB application?
Monday, March 26, 2012
Export data from SELECT statement
Wednesday, March 7, 2012
Expanding the Multi-Valued Parameter Dropdown Menu
Hello Everyone,
I am trying to expand the multi-valued parameter menu object so I can display the selection list in a more user-friendly format since the text is fairly long. If left at the default setting then I have to scroll to the right to see the complete string(s). For a single-select parameter I can just CAST the string to CHAR(100) and the menu object will expand. However, it seems that this approach is not working for multi-valued parameter menu objects.
Is this a bug in SSRS, and is there another way to accomplish this. Please let me know.
Thank You!!!
I apologize for bumping this topic, but could some of the Microsoft guysplease let me know if this is possible. I'm sure I'm not the only one trying this. Thank you so much!
Expanding the Multi-Valued Parameter Dropdown Menu
Hello Everyone,
I am trying to expand the multi-valued parameter menu object so I can display the selection list in a more user-friendly format since the text is fairly long. If left at the default setting then I have to scroll to the right to see the complete string(s). For a single-select parameter I can just CAST the string to CHAR(100) and the menu object will expand. However, it seems that this approach is not working for multi-valued parameter menu objects.
Is this a bug in SSRS, and is there another way to accomplish this. Please let me know.
Thank You!!!
I apologize for bumping this topic, but could some of the Microsoft guysplease let me know if this is possible. I'm sure I'm not the only one trying this. Thank you so much!