I can't get ANY query with Report Builder to work!

I don't want to use a stored procedure, or do I have to?
I can't get any of my querying (whether from a dropdown or not) to do
anything other than display entire table...I'm creating report from
report wizard.
Help IS appreciated.
TrintTrint,
Each report has one, or more, datasets assigned to it.
Each dataset is independant of each other (except foe the datasources of
course), and each table on any report can be assigned to one of those data
sets.
I would finish with the wizard (I NEVER use those wizards) open the report
in design view, look at the dataset associated with the report, and alter it
accordingly. The dataset GUI in VS2003 is exactly the same as Enterprise
Manager for SQL.
Any further problems, just ask,
Hope this assists,
Tony
"trint" wrote:
> I don't want to use a stored procedure, or do I have to?
> I can't get any of my querying (whether from a dropdown or not) to do
> anything other than display entire table...I'm creating report from
> report wizard.
> Help IS appreciated.
> Trint
>

Hyperlink in Excel

Hi.

When creating a report builder and exporting to excel, the excel file keeps the hyperlinks. How can this be switched off ?

Many Thanks.

Sorry, hyperlinks are always included on all output formats. There isn't any way to turn them off for a particular renderer.

If you explain your scenario, we may consider it for a future release.|||We are having the same issue of clearing out the hyperlinks from excel sheet rendered using sql reporting services.

The scenario is once the report is generated in report viewer, we require the hyperlinks to navigate to other linked reports. But when we export the report by clicking on the export link available on report viewer, we want to remove the links in the excel worksheet.

When the export link is clicked on report viewer i do not have any exclusive control where in i could identify the click event of the export type as Excel selected from the drop down.

Thanks

Sups
|||I understand what is being asked, and would like to see it as a feature. I have many reports that link to other reports for drill-down. When view in the report viewer everything is great, however when exported the link is something like "http://reportserver/ReportName?parameters" which is not a valid URL. It would be nice if this was removed from excel so as not to confuse the end consumers of the report.

Hyperlink in Excel

Hi.

When creating a report builder and exporting to excel, the excel file keeps the hyperlinks. How can this be switched off ?

Many Thanks.

Sorry, hyperlinks are always included on all output formats. There isn't any way to turn them off for a particular renderer.

If you explain your scenario, we may consider it for a future release.