Search results for query: *

Yes that is possible, First you need to set up a parameter in your report and set it up to list values from the stored procedure. Then you need to go to the data tab, click on the elipse next to the data source name and click the filter tab. From there you set your filter to equal your...

Anyone know how to turn off security on the report server? I have implemented my own custom security extention and don't need the default on in RS...

yes, add this to the end of the url link you send them "&rs:Format=PDF" that will prompt save as pdf, they also do html, excel etc. 1

I know this is easy but i just have no clue. I have a report parameter that has a drop down list and lets the user pick what project they want to query. Is there a way to put an option "All" in so they could get the totals for all projects??

Geoff, No need for sorry i appreshiate any idea that is sound, right now i am stuck and this package is supposed to be released to QA on monday, they will not be happy when i tell them they have less days to work lol. anyone else have a clue??? Bob

Yes, but the DTS is run on demand not schedule, sometimes a few hours and sometimes weekly. I want to call the report on demand to populate. I have only seen subscriptions populate at specific times. Can you set them up to be called by a trigger? I was hopeing there was a way to do it...

Hey all, i know someone has had to do this before. I am running a DTS package and the last step is to run this report export to PDF and send it to our clients. I know how to call a report to generate only as a PDF through the URL, but i cant get it to save automatically in a file so the DTS...

You can pass them through the URL. Look it up in the Help doc

Yes that would be good if i was writing a stored procedure to do it, but i want to do it in RS after all parameters have filtered the data.

I need a way for totaling columns. Currently i have I have data that looks like so Customer PaymentType Amount 111 Credit 100.00 222 Account 100.00 333 Credit 100.00 444 Transfer 100.00 The report looks like this, How can i get...

The SQL query works fine when i define the parameters. It is when i try to pass them in through the report that it doesnt work, it will filter the data correctly but will have the calculations for all the data in the dataset. I see what you are saying about the two different sides, where would...

I ended up creating an internal DNS that would only allow access to the report server within the internal dns and then just made an ASP page as the only portal in. Thanks for the idea

I am making a custom interface to do authentication and authorization for the different client we have. I am creating some SQL tables linked to an ASP.NET page. The problem is when they click on the hyperlink to get to the allowed report they can see the full address of the report, and revisit...

No i said above that it didnt work, is there another way such as calling a stored procedure once all the data has been pulled and filtered?

Hi all! In my report I am calling a stored procedure to supply the data. When the report is run the user gets to enter in the 'to' and 'from' dates and the report filters all dates not in that range. The problem is that I am doing calculations in the stored procedure and all the unfiltered...