Showing posts with label selection. Show all posts
Showing posts with label selection. Show all posts

Monday, March 26, 2012

Export data from SELECT statement

Hello,

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?

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 guys
please 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 guys
please let me know if this is possible. I'm sure I'm not the only one trying this. Thank you so much!