Just a few questions in getting into designing reports in BIDS (SSRS 2005):
1) Is there a keyboard shortcut (or icon on a toolbar) to perform an "Insert Column To The Right" in a report table object? If I need to add 10 columns, it's kind of a pain to right-click on a column and then choose "Insert Column" from the popup menu
10 times. I did find a way to add an icon for this to a toolbar, but it's disabled when it should be enabled. I haven't investigated trying to create my own keyboard shortcut... is that the only way?
2) This might eliminate the need for #1 above: Is there a way to somehow drag an entire dataset to a report table object to create columns in the report table for every column in the dataset? Or is there a way to drag multiple columns? I can't
seem to do a multi-select in the dataset... I can only drag one at a time.
3) When dragging columns from the dataset to a report table object, is there an option that I can set to prevent BIDS from massaging the title of the column? For example, if I drag a column called CustomerID from the dataset to the report table object,
it insists on changing "CustomerID" to "Customer ID" (embedded space) as the title of the column.
--Brad (My B
View Complete Post