I have a table in a report that is displaying some call duration data. I have a field that averages the results and displays them. My issue is the result is often a number with many decimal places (example 15.888883) and I would like the field to display a whole number (example 15). In report ...more >>

Hi Is it possible to have a line chart with one group of colums stacked based on 1 dataset with a column next to it based on a different datatset. the catagory would be a common field in both datasets (which is date) basically the chart would have 2 columns for each date, 1 would be the st...more >>

Hi all, 1)Is there a way to supress the textbox,image etc when the report is displayed in browser and then make them available for printing on paper alone? 2) how to construct url to call reports that has multiselect parameters. In other words how to pass values through url to a report for...more >>

Can anyone tell me what I could/should do to stop this stored proc from running. It has been running all day and consuming resources. I've tried killing the SPID and it just returns. We've stopped and started the SQL Server service and its there here. Absent rebooting is there anything els...more >>

I have a text box field on my report, it's value =Count(Fields!IdItem.Value) why can't I put this on my page header? the error message: c:\sql reports\items report\Items Report.rdl The value expression for the textbox ‘textbox39’ refers to a field. Fields cannot be used in page headers ...more >>

Hello! If somebody knows how to set page size (A4 etc.) on development, because when I trying to print my report (after deployee) from user's computer the settings are differents and not taken from default printer. Thanks. Gennady ...more >>

I have a chart that has dates list on the x axis in a horizontal fashion. I would like to change them to be vertical. Can anyone tell me how todo this?? Thanks, ...more >>

Is there way to export report as a landscape PDF? As far as I know a crystal report, there is way to make report as landscape or portrait. how about reporting service??? ...more >>

only one long column is showing up in the main report for the suyb report part of it, but when i run the subreport by itself it shows two. ...more >>

When a client types in the homepage of the RS it takes minutes to open instead of seconds. It is running on a W2K3 machine with SQL 2000 and the clients are a mix of XP and 2K Pro. Any advice would be great. Oh this also happens on the server itself. Once you open it once it opens in second...more >>

Hi, I have a column with numbers like this and the output desired. dataset output desired 0.170 0.17 0 0 1.120 1.12 0 0 But when i format it with number, #.## etc. i get "0" as 0.00 - which i dont want any suggestions ? Thanks RP ...more >>

Is there a way to include an 'ALL' option for a parameter when the data for the parameter selection is retrieved using an MDX statement? Is there an MDX function/technique similar to the UNION function in SQL to allow additional values to be added to the list of values? Thanks, PD...more >>

I have a table where i used almost 7 groups with toggle on each level ... so by default only one row shows up with a + - user clicks on it 2nd row shows up like that 7 groups and then they can c the rows. But is there anyway that i can use an option of Expand All in one click ? like have a ...more >>

is there a way to show a month chart?? If i have data only for the 5th and the 6th but i want the chart to show all month days(blank columns)......more >>

Instead of using the Report Manager that comes with Reporting Services, I have built a custom ASP.NET report interface that launches reports using URL access. When there is a problem displaying a report, I get the usual reporting services error, but I would like to redirect to a custom report ...more >>

Hi, I have some 26 rdl files (SQL Reports), i have written a code to render one rdl file to save in one pdf format. but my requirement is 26 rdl files has to be rendered to one pdf file. Is it possible to do so? if Yes, please suggest me. Please help me in this issue as soon as possible. ...more >>

dear all i have a dataSet in this way ID NAME 1 VALUE1 2 VAlue2 3 VALUE3 4 VALUE4 5 VALUE5 i need to display this daya as the following 1- VALUE1 2- VALUE2 3- VALUE3 4- VALUE4 5- VALUE5 is there are anyway thanks...more >>

Hi All, Have a report wih 4 drilldown levels as such: -JOHN Doe - Financial Service Division - Accounting Department - HEPA Compliance 1 80% ...more >>

hi all, i've got a win2003 server installed with WSS running on top of it. now on this same machine i'm trying to install Reporting services side by side, but i can't get "Reports" and "ReportServer" to work properly. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstal...more >>

i am new at this. but i need to do a calculation that has to sum a running value or running value of a running value . here is my expression. =sum((((Fields!PART_QTY_ON_HAND.Value - runningvalue((Fields!REQUIREMENT.Value), sum, "tbl1grp3") * Fields!Temp_Part_Cost.Value ) + .005) * Fi...more >>

I have a Datetime parameter from a dataset. It also shows the time but I only need the date, is it possible somehow to change how it displays the parameter. As what I can see it is only possible to choose datetime format. I tried to convert it like this convert(datetime,period,105) as dateonly an...more >>