You are not logged in [login] | [register]

you are here: home » blogs (technical) » development news

SEARCH FOR A FEED

Google
Web RSSMad.com

Searching 185428 articles in 8938 feeds.

RSS CATEGORIES

TELL A FRIEND

Do you like RSS MAD? Why not spread the news and tell a friend about it - it's as easy as filling out this form!

SQL Reporting Services - Answers to your questions

added: Wed, 21st September 2005 | 8841 views | 1x in favourites
feed url: http://www.sqlreportingservices.net/Ask/defaultxml20.rs...

If you have a Reporting Services Question - just ask away!

Latest feed entries:

remote connection of the sql reports in express edition

Hello Dear Friends I work for a small organization and on my reference my team downloaded the express editionof web developer 2005 and Sql server 2005 WE have worked on two products And now iunderstand that "Report data sources must be SQL Server relational databases that run locally in SQL Server Express" !!!!!!!! We are able to connect sqlserver database The work on products is almost complete and at this point cannot revert back to any other reporting services. DO I HAVE HOPE....is the

Subscription parameter

Hi, I'm having trouble setting up a subscription for a report. I want to run the report on the first day of every month, withthe start date parameter being the first day of the previous month. Is this possible? Thanks

Change exported report's defualt name

Hi Iwant to change the name of the report at the time of saving/exporting to some format. as it always gives the name of the report for saving as file, the same as the Name of the original report file name. please guide me, can i change the name of the exported report at the time of saving. i think this should be the propery of Report viewer used by reporting services. To give you detail about my approach. i am viewing reports using reporting server (URL report viewing).

Total by groups

I am have my data grouped by the department then grouped by district. Then I total each group I need a way to total the two groups now. AuxliliaryLife1685 842509 183629 853836 774352 1505559 377056 459365 1849569 289785 2919889 359978 639981 15010002 1110029 9610041 12110046 12110221 5010252 147Total - DAK991793-- END OF GROUP ONEAK23Total - AK23 -- NOTE I really need this total to be the total of GroupOne Total plus the (23) from Group two. (Th

Pass Dataset to Custom Assembly

Is there a way to pass an entire dataset instead of passing individual fields?

Reporting Services

Default value or value provided for the report parameter 'intSecurityID' is not a valid value. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Default value or value provided for the report parameter 'intSecurityID' is not a valid value. ---> I am getting the above error when 'intSecurityID' parameter contains the value of 150 or greater than 150. If the 'intSecurityID' value is lesser than 150 then reports working fine, not displaying any error... please help!!

Please help Urgent SQL 2000 reporting Analysis

I was able to resolve to work Asp .Net 1.1 with IIS issue. Now when I am intalling system is saying "This edition of reporting services does not support installing the server components on this operating system." I am installing this on my Laptop with Operating system WIN XP, VS .NEt2003 and 2005. I have SQL 2000 Client utilities enterprise manager etc. PLease help. Thanks A

Complaing Asp .NEt 1.1 was not installed URGENT

Can anybody help me please. I have ASP .NET 1.1 and 2.0 WHen I am installing SRS 2000 it is complaining that Asp .Net 1.1 is not installed. I registered it through VS .NEt Cmd prompt still it is complaining. Can some body help me in resolving this issue. Thanks in adance Anupama

Select all by default for parameter

Hello. I have a parameter with multi values taken from a query. When I open the report the first option in the parameter option list is "select all". I want the "select all" to be selected by default when I open the report. I Tried to use the same query in the default value of the parameter in the hope that this will check all the values but it didn't work. Any ideas? Thanks!

Extra window is opening up while viewing reports

Extra blank window is opening up while viewing reports from application. The reports are opening up in pdf format. Can anyone pls let me know the reason why it is happening. One more problem i am facing is the currency symbols i am printing on reports are shown as '??' on reports, it happens for some specific symbols. I have acrobat reader 7.0 installed. Thanks Anurag

Installing SQL 2000 Reporting Services

Hi There, I am new to SQL 200 reporting Services. I am middle of installing Sql 2000 Reporting on my local machine. I have Visual Studio .Net 2005. I still have to install VS .NET 2003 in order to install SQL reporting Services. Do I have to do the same process on production server too Please help me. Thanks Anupama

Regional Languages Problem (date)

Iam trying to access reports from other country . Their regional settings of PC are different than English. So when i try to give parameters to my reports it gives me error. What i have found if regional settings are changed Date format automatically change by it self . it does not take any date in English. I have add English language using Internet explorer options. That solves the problem. But report services should automatically handles this situation. Any idea how would it take the corre

problem export footer to excel

Hi, I have a report with text in the footer. When I exported it to excel, every thing except from the footer is exported (the report body and header are OK). I'm not getting any error but the text in the footer just doesn't appear. Any solution? Thanks.

Case trouble with IN subquery

I have the following in my WHERE clause for my Sql Server Reporting Services 2000 report (the user can use the parameter @MaxRevs to view all numbers (colNumber) or only the max of colNumbers when grouped by colParentNumber): AND (tblMain.colNumber IN CASE @MaxRevs WHEN '' THEN '(SELECT colNumber FROM tblMain)' ELSE '(Select max(colNumber) From tblMain Group By [colParentNumber])' END)) I get the following error:1. ADO error: Syntax error or ADO access error I've used Case in the past,

Report Builder not available for Power User

Hi, How do I configure RS so that the Report Builder button is available for Power Users? The button is there for administrators, but not for members of the Windows Standard Users (Power Users) group.

Failure to connect to reporting services from Management Studio or reporting services config tool

Hello, I'm having an issuetrying to connect to reporting services from Management Studio or reporting services config tool. I'm getting the following error message.... When I open the Reporting Services Config tool, I'm seeing a blank "Instance Name" field, I'm not sure why. Any help/tips are greatly appreciated! Thanks, Matt =================================== Cannot connect to .. =================================== Provider load failure (System.Management) --------------

Auto Refresh jumps to top of the page

Hi all, I have quite a long report and the need to auto referesh every 15 seconds. If the user is looking at something at the bottom of the report and the refresh kicks in the report jumps to the top of the page. Is there any way to force the page to stay in the same position in the window while the refresh occurs. Thanks in advance. Will

How to hide Series label in a chart

Hello, I have a Chart with one series as values. The chart is good and I can see the series label in the corner. I can hide it by uncheck the "show legend. Now I added another value to my chart and got another series label. Is there a way to hide only one label? If I use =" " in the "series label" of that data then the label its self is hidden but the label mark is still visible. Thanks.

subreport for export purposes...help!

I am wanting a sort of start page for our engineers that looks like a bit like the following: Search forPart ID?: then the engineer types in their part id pushes search and it launchesa subreport thatreturns the results. The reason for this is so that he/she can then do an export as (if they want) and manipulate it to suit them. Currently I have everything working but only as a main report. This causes a problem because when you export it it shows a bunch of stuff (the above) at the top whic

ADD A FEED

Is RSS MAD missing something? Tell us about new feeds here.