.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS question?

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server

Hi Experts,

We have query with sample data as :-

	IsManager		CHAR(1),
	EmployeeName	VARCHAR(10),
	StateName		VARCHAR(10)


View Complete Post

More Related Resource Links

Question regarding IIF statement and Grouping in SSRS 2005

Hi Guys, I am using SSRS 2005. I am facing small prob in using IIF statement to hide a column. I am having a Grouping in my table. (Emp_Group and the values are 'Yes' and 'No') Now, I want to hide a column of the table if Grouping is Yes and I want to show the table if Grouping is No. (When exported to excel it will appear in two different sheets). Any suggestions please............

Question regarding SSRS 2005

Hi Guys, I am using SSRS 2005. I am using a parameter named Employee (and it has the ability to accept multiple values like this : '100,200,300' or '100', or '100,'1453' etc. I made this possible in the Stored Proc using some Split function) Now What I want is when we enter values manually in the Employee parameter, I want to display their respective names in the Header part of the report. For example, if we enter values '100,'1453'  and view the report, I want the Header information to be displayed as 'James,Steve'. And I am having fields named Employee_Code and Emplyee_Name in my report. And the report designed so that user should manually enter the values of employee codes. ANy ideas??? Thanks, Bablu.

SSRS 2008 question? Date Help

Hi Experts, I'm new to SSRS world. I'm trying to print current date in the format of "Month-Name Date, Year", here is the t-sql query:- SELECT DATENAME(MONTH, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) + ', ' + CAST(DATEPART(YEAR, GETDATE()) AS VARCHAR(4)) AS [Month DD] --'September 14, 2010' Everything is working perfectly untill here, now I placed text-box with exp as :- =DATENAME(MONTH, NOW()) + " " + CAST(DAY(NOW()) AS VARCHAR(2)) + ", " + CAST(DATEPART(YEAR, NOW()) AS VARCHAR(4)) AS [Month DD YYYY] But it is giving error as :- The Value expression for the text run "Textbox22.Paragraph[0].TextRuns[0]' contains an error: Name 'DATENAME' is not declared. I understood the error, saying DATENAME is not the appropriate function in SSRS, so my question is can somebody write me correct code to give me o/p in the form of my above t-sql query   Any Help? I'm using SSRS 2008 Thanks Regards, Kumar

SSRS embedded code scope question

Can someone please provide some insight about how embedded code works in terms of scope?  I am trying to show moving average values on charts using the custom code from http://msdn.microsoft.com/en-us/library/aa964128%28SQL.90%29.aspx.  My chart has an actual series group, which has multiple values.  To be specific, my data series is profit per unit; my series group is division; and I have time on the X axis.  The "division" series group can have multiple values such as "US", "Europe", and "Asia".  Looking at the moving average custom code from the above link, I really wonder how the global variables, such as "queue" and "queueSum", are handled across the multiple series group values.  Can it correctly separate the queue for division "US" from the queue for division "Europe" and "Asia"?  Also, I have multiple charts ont he same report and they all use the moving average custom code.  Does SSRS use different instances of the global variables so that one chart is calculated separately from another? 

Potentially an inScope Question (SSRS 2008)




I have a problem which is similar to some of the others here, but not the same.

I'm trying to build a grid, like so

      Category1 Total
      Delivered Target Attainment Delivered Target Attainment
2010 Q1 Jan 1 1 100% 1 1 100
    Feb 1 0   1 0 0
    Mar 1 2 50% 1 2 50%
    All Months 3 3 100% 3 3 100%

SSRS 2005 export to csv has question mark in place of sterling currency symbol



I've upgraded reports from SSRS 2000 to 2005, and since then when I export to csv I get a question mark wherever there ought to be a sterling currency symbol. The table cell in the report is formatted correctly and when exporting to xls the currency symbol is preserved. One of my users requires the data as csv.

Can anyone help with this?



SSRS 2005 Subtotal Question


I am using a matrix to display some numbers and in my data column, I am displaying average values.  More specifically (# of actions/# of opportunties).  This gives average # of actions performed per opportunity.  And it's being displayed per sales person.   The columns are grouped by certain type of actions (phone call, email, voicemail).  What I want to capture in the subtotal area is sum of the average, not the total average.  

In otherwords, if 3.5 phone calls, 2 emails, and 2.5 voicemails, I want to display 8.  Not 2.6.  How is that done?  Thanks.

Question regarding Subscriptions in SSRS 2005


I have a question regarding subscriptions in SSRS 2005.

We have development (reports_dev)  and Production (reports_prod) environments .

I created a subscription in the Production environment for a report, and ticked the Include Link so that I can get the link of the Production environment reporting services of the report.

I am getting the email but in the email its showing the link of Development environment. (http://reports_dev/reportserver................)

So my question is where can I find this information and how to change it to the correct Production environment link http://reports_prod/reportserver ..................

Any ideas?



Question on Reporting Services 2005 Date from iseries to ssrs

I was wondering I am using SQL server reporting services 2005 and I-series to gather my data.
I need to convert a date from yymmdd to mmddyyyy to use the calendar in a parameter. Is there anyway to do this? I have tried many different ways with no success. basically because the date in the i-series is 110414 (today's date) The datetime option on parameter will not work. I can use it as a string and type it in. I would really like to convert it to 04/14/2011 so that I can let the user select from a calendar. Let me know if you know anyway or anywhere I can post it to get an answer to this question.
Thank you

Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Web Site to Web Application Question


I've been building web sites and for my next project I will be creating a web application.  I use a 'BasePage' class in all my projects but, since web applications do not contain the 'App_Code' folder, what is the best place/practice for the 'BasePage' class?



connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

Security Question Answer Retrieval


I know there is a method built in for retrieving the encrypted password, but how do I retrieve the encrypted security answer?

What I want to do is have a member profile update screen that the end user can update their password and security question and answer. However, when they get to this page, I want to already be showing the security question (the easy part) and its answer (the not so easy part).

I have updated web.config with passwordFormat=Encrypted and have added a machineKey with the generator (forgot the link, but located on eggheadcafe somewhere).

I haven't done ANYTHING yet, since I already have a user store with hashed information. I wanted to get some functionality done before publishing, wiping the store and recreating users (only a couple developers).


Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




C#, LINQ: (List<>) Question???


Hi Everyone,

I have a strange problem:


There is an entity (Table) called "Filters" in my .edmx which has all my tables and stuff in it (to use it for LINQ queries)

I have created a class called "CustomFilters" which inherits "Filters". So now my cutom class has all the properties of the original "Filters" class (table) and 1 more additional property that i wanted which is a List of "CustomFilters":

List<CustomFilters> children = new List<CustomFilters>();

Now i get all my records into:

List<CustomFilters> theOriginalList = new List<CustomFilters>();

NOTE: first all records are tken into a List<Filters> and then these are added into List<CustomFilters> where List<CustomFilters> for children of that record is added, and then children of the child records, and so on......

so now, every record is an instance of CustomFilters which has a property named "children" which is a list again; and each child again has instanaces of "CustomFilters", and each instance again has children...and on and on and on.....

(basiacally its a data source for a treeview in my silverlight control)

every thing is good and working as expected.


linqdatasource parameters question



I'm currently getting to know the linqdatasource control. What would happen if several WHERE parameters are added to the linqdatasource control declaritively in the aspx page but no WHERE clause is defined? 

1. is there any issue with setting up multiple WHERE parameters in the aspx markup for linqdatasource but then deciding which ones actually get used at runtime by setting the actual WHERE clause at run time? Would the unused parameters simply be ignored and cause no issues?

2. when you need to modify WHERE clause or WHERE parameters at runtime do you need to do so in an event handler? such as linqdatasource.selecting?
I see from the above link it is possible, but is that the standard way to handle controlling filtering in code behind for linqdatasource?

2b. if you use an event such as linqdatasource.selecting to add where parameters and/or modify the where clause in code will that also break the builtin sorting and paging support of the linqdatasource with a gridview? 

database interface design question


For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend