Navigates to the subreport using a link from one of the textboxes in the table. We are using SharePoint 2003 so it might be a version problem but I have...

We have SharePoint with Reporting Services in integrated mode and our ReportServer database does not have a Users table. I checked the SharePoint database and could not find a Users...

I solved it. The problem was that my sub report had parameters that had available values. sub reports can't have available values in their parameters

Hi Frank,

I'm getting the same problem. Did you solve it?

Yes. Both were deployed. Eventually found out that you need to open the main report with report builder, right click the sub report click on properties and then browse to...

If I'm getting this right, that is actually what parameters are used for. Get a value for something that affects the result of the report.

When you create a parameter...

convert(varchar(30),@variable,120)

just replace @variable with the column or value you want to format

If you are receiving the value in the report as a parameter you should format it before the report. If you are filling the available values of the parameter for...

Thanks Lynn and Ed for your prompt replies. I agree, Lynn's approach is reusable but for temp queries I might use Ed's

Thanks again

Found an answer

sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'

😀

Instead of using CAST try with CONVERT(varchar(10), DESPATCH_DATE,101). That might help

I'm not sure I get your question. Could you copy your query so I can take a look?

Lowel thanks for your reply.

But no, I'm using the relay server's userid and password. Same ones I'm using from outlook and it works fine there

Unfortunately there is no email administrator. I was recently hired as developer/dba and the only IT guy here.

Emails were already setup when I got here (thank god)

Any help, please?

The thing is I'm not looking at having the header in the web page but in the actual report. Showing the header in the page is not a problem. But...