Search results for query: *

Hi , In order to determine my db for my variable datasource i need to get the clients pc-name/address from where the report is being started. How can i get that into my report. I'm using SSRS2008 version 10.0.1600.22 tx for any solution

parameter driven hidden column is exported to csv although it's hidden. At the report mgr it works fine when the parameter makes the column hidden it isn't shown at the report. But when exporting it to a csv file the hidden column is exported !? How can i avoid it from being exported when it's...

No answers , and i'm still facing the problem from time to time. But i think that it has something to do with the available memory/cpu at the moment of execution.

Hello i'm using a linked server to execute loads from 1 server to another . The procedure is started by a sql job and runs very often without any problem. Sometimes i receive the above error , but when i then reëxecute the same procedure it runs smoothly . It's never on the same qry . I'm...

Hi , Is there a possibilty to qry the security of each report. I want to see for a particular user which credentials he has on which reports in order to change/delete these by using a qry instead of open 1 by 1 the security at the reporting site. tx regards Steven

Hi , I receive very often the error message 'Thread being aborted' at several subscriptions of different reports. The strange thing is that it's not always the same subscription/report . Sometimes there's no problem at all . Wen i run the report again everything goes well. Can anyone help how...

Hi , i'm using reporting services ver 10.0.1600.22 (sql 2008) I've very often for a certain report that i ran every week by a subscription the error 'Report processing has been canceled by the user.' although that it has not been canceled by any user ! Before there was no problem , nothing has...

Same identical email sent to both machines? -> yes both options are checked. The strange thing is if i copy and paste the link in a new mail then the url is underlined .

hi , i'm using win xp and MS office 2003. When i receive a mail with an hyperlink it's sometimes not recognized as a hyperlink and i need to copy and past it in order to open it. the hlink is fe \\192.1.1.237\e$\data\Reports\Management-Weekly_figures.xls or...

All, i'm using dependant parameters in my report but the report refreshes the webpage after each selection of a parameter on which another one depends. Is there a possibility to avoid the refreshing of the page ? Every refresh takes a few secs and it's very annoying for the user. Any help...

hi , I want to export a report on a regular basis to an xls format and save it into a shared folder. I don't want to mail it (it's too big) , i just want it exported and sent a notification that it's there. When i use the history or snapshot option then i still need to manually export the...

Geoff, it's the same result ,in other words the parameter value isn't passed for some reason stanja

Hello , i've got a report with a hidden parameter that's used to return a dropdown list for selection in the report. When i passthrough the parameter by the url it doesn't pickup the value . Do i need to activate a setting or ... in order to get this working ? Beneath the url i'm using , i...

Hi , I'm using the subscription in report manager to create ,export to xls and mail a report. The xls is getting a huge size which causes problems to open it. When opening the file and saving it the size reduces a lot. So is there a way to reduce the file size at the moment of the export ...

When i process the sp or the preview in VS then everything runs fine. When i then try to consult the report through the report manager i receive the above error. I'm using Microsoft SQL Server Reporting Services Designers Version 9.00.2047.00 on a windows server 2003 and sql server 2005...

Geoff , i've got already subtotals for each group but what i want is a grand total of each group at the end of the report. fe store1 tot div1 tot subdiv1 tot store2 div1 tot subdiv1 tot subdiv2 tot div2 tot subdiv1 tot grand total stores (this i...

Hello, i've got a table with 3 groups , store, division,subdiv. I wont a report total for the stores , for each subdiv and each div. how can i do this. I only manage to get a total of everything but not seperate totals for each group I'm using Microsoft SQL Server Reporting Services Designers...

Paul , tx for the info but is the time stated in the columns in msec or ??? tx stanja

Hello , Is there an option/setting/??? that i can change in order to get the report execution time more or less equal on the query execution time ? I'm using sql server 2005 and Microsoft SQL Server Reporting Services Designers Version 9.00.2047.00 I'm having now great differences fe query...

Hello , is there a possibility to change the layout off the calendar in which you select dates for report parameters of type datetime ? Now its stating sunday to saterday and we want it showing monday to sunday. I'm using sql server 2005 and Microsoft SQL Server Reporting Services Designers...