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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SSRS embedded code scope question

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
 
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? 


View Complete Post


More Related Resource Links

Embedded code block question

  
Hello,i know it's a very basic problem but i can't use an asp.net code block the way i want.I have used those before but it seems i encountered a case i haven't seen before.<asp:SqlDataSource ID="SqlDataSourcetblCategoriesPourListe" runat="server" ConnectionString="<%$ ConnectionStrings:BottinConnectionString %>" ProviderName="System.Data.SqlClient" SelectCommand="SELECT label from mytable WHERE (HOrder = @HOrder)))"> <SelectParameters> <asp:QueryStringParameter DefaultValue="<% (int)GetDefaultValue()%>" Name="HOrder" QueryStringField="HOrder" /> </SelectParameters> </asp:SqlDataSource>Whenever i run this, i get an exception:Syntax error converting the nvarchar value '<% (int)GetDefaultValue()%>' to a column of data type int.How can i avoid this ?I am not doing it in the code behind because i use nested gridviews and sqldatasources.  Can't access nested sqldatasources from code behind, as far as i know.

Issue while using embedded vb code in SSRS 2005

  
Hi


Problem description:

    I am using the function to embedd within the report .This function is called the user presses the view report button.

It works in the report designer (in preview),but it doesn't work on the server after i deployed it to the server,
why does it give me the message that is Error during processing of '@ParameterName' report parameter.(rsReportParameterProcessingError).

I am using Mgbox to display some alert statements in the Custome code.. embedded into the.. report

do I need to do anything with custom assemblies?
or any ot
her reasons this?

Any help to solve this issue is greatly appreciated

Regards,
Kay


Question about user used to execute code from app_code

  

 Hello. I would like to know something about code execution  in App_Code folder.

Under wich user executed code from app_code.

I'm using impersonate in web.config


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............

How Can I use Code in SSRS?

  
Hi Everyone, I am using SSRS 2005 I want write Code for calculation or sum loops in the SSRS by using programming code. Any one can help me for how to write code in SSRS 2005. Please... Regards, Parikshit

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.

Question with this code

  
Hello all I have a question with this code, I'm still learning and I'm not sure what can be the possible error with this code Thanks in advance for the help! The error showed is this ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Index and count must refer to a location within the string. Parameter name: count Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentOutOfRangeException: Index and count must refer to a location within the string. Parameter name: count Source Error: Line 54: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Line 55: Line 56: Usuario = Context.User.Identity.Name.Remove(0, 6).ToString Line 57: Line 58: Dim myConnection As New Data.SqlClient.SqlConnection ----------------------------------------------------------------------------------------------------------- This is my code ------------------------------------------------------------------------------------------------------------ Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Usuario= Context.User.Identity.Name

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

SharePoint 2007 Enterprise Search Scope Question

  

Hello,

I have configured different search scopes to point to different search contents on my MOSS server and had them displayed on cope dropdown menu.  Everything is working great but with one issue; the selected scope from the default Search page does not stick on the Result page.

For example, I have three scope choices available on my scope dropdown menu: scope1, scope2, and scope3.  For this particular scope Display Group, I have selected "scope1" to be the default.  So when I go to the main Search page, "scope1" is shown as the default choice on the scope dropdown menu.  If I select another scope from the dropdown menu (e.g., scope2) and perform a search, it takes me to the Result page showing the result of the search and also shows what I typed in in the search text box.  The problem is that although I selected "scope2" on the original page's dropdown menu, the result page's dropdown menu shows "scope1" which is the default choice and not what I selected on the original page.  This behavior is confusing to my end users who want to refine their search from the Result page but then they have to re-select "scope2" from the dropdown menu.

My question is, is there a way for me to make the selected scope choice from the original page to stick on the Result page's s

SSRS 2005 to 2008R2 custom code migration issue

  

We have an SSRS 2005 report that we upgraded to 2008R2 with custom code in the report properties code tab that no longer works.  We checked permission setting in the report server config files, checked if the data set was passig nulls and it is not, looked to see if we ignored the error if the report would render the correct value anyway despite the error and it did not, tried different code variations and referencing different system libraries without luck....we are truly baffled.  The only thing that does work is setting the total to 0 and removing the loop through the jsColl to compute the total.  Here is the code that used to work on 2005.  Any ideas why it does not work on 2008R2?  We call it in an expression =Code.getTotal()

Public

 

jsColl As Microsoft.VisualBasic.Collection

 

General question: Using the VS Designer vs. the Source Code

  
I just finished Sams Teach Yourself ASP.Net in 24 Hours. I am now going through the Data tutorials here. I am a beginner at ASP.Net. One thing that I am having a little bit of trouble with is the idea that I am using the Designer in Visual Studio for just about everything except for a few code tweaks. I used to do a lot of HTML, JavaScript and CSS. I even did some programming (PowerBuilder). So, I am used to writing/typing code instead of using a Designer. (I always liked writing web pages in a text editor.) When I look at the code generated by the Designer in Visual Studio, I can understand what is going on there. But, to sit down and write that code instead of using the Designer to me seems impossible. There is just so much there. From what I understand, ASP.Net and Visual Studio were created to help streamline the code writing process. I suppose if I was used to writing VB code to create applications I might look at this from a different angle. But, I am learning ASP.Net using the VS Designer. Any comments or suggestions from experienced coders? I really don't want to have a battle between people who use the Designer and the Source Code editor. I am just hoping for some comments that will help newbies. Thanks.

SharePoint 2007 Enterprise Search Scope Question

  

Hello,

I have configured different search scopes to point to different search contents on my MOSS server and had them displayed on cope dropdown menu.  Everything is working great but with one issue; the selected scope from the default Search page does not stick on the Result page.

For example, I have three scope choices available on my scope dropdown menu: scope1, scope2, and scope3.  For this particular scope Display Group, I have selected "scope1" to be the default.  So when I go to the main Search page, "scope1" is shown as the default choice on the scope dropdown menu.  If I select another scope from the dropdown menu (e.g., scope2) and perform a search, it takes me to the Result page showing the result of the search and also shows what I typed in in the search text box.  The problem is that although I selected "scope2" on the original page's dropdown menu, the result page's dropdown menu shows "scope1" which is the default choice and not what I selected on the original page.  This behavior is confusing to my end users who want to refine their search from the Result page but then they have to re-select "scope2" from the dropdown menu.

My question is, is there a way for me to make the selected scope choice from the original page to stick on the Result page's s

SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029

  

Hi,

I am executing a huge report in SSRS 2008, after some time the report doesn't renders and there is an error icon at the left bottom of the web page. When I click open it to see the details, it gives following error;

Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while
processing the request on the server. The status code returned from the server was: 12029.

Any help on this will be appreciated.

Regards.


Format Code D0 is not working in SSRS 2008

  

We are trying to migrate all our RDL from SSRS 2005 to SSRS 2008.

In the rdl’s we defined format code for a  text box as “D0”  which is working fine in SQL 2005.

While migrating the rdl’s to 2008 it is not working and data is showing for that text box as “#Error”.

How to resolve this . I am having around 1000+ rdl’s to update with proper format string.

If I open the Rdl in BIDS I am getting below error.

 

[rsInvalidFormatString] The Format value for the textrun ‘textbox1_0_13.Paragraphs[0].TextRuns[0]’ is not valid. Format specifier was invalid.

[rsRuntimeErrorInExpression] The Value expression for

Embedded HTML using
to replace tags in ssrs 2008   

After doing various amounts of research and testing I need to post a question here. 

I am using an html editor to format html and data (for reports) and then using reporting services to render the html harnessing the report server to view, export, and print. 

As already many of you know around here you can set an ssrs table cell to “HTML – Interpret HTML tags as styles”.  Also many of you know that this functionality does not accept <table><tr><td></td></tr></table> tags.  However, the documentation says it support <div> tags. Yet when I try using div tags with the appropriate styles for creating tables this does not work either.  So if ssrs handles <div> tags could you please tell me a complete list of style attributes it handles as well?

Potentially an inScope Question (SSRS 2008)

  

Hello,

 

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%
           

Newbie question about SQl code and SSIS

  

Hi Guys,

Im coming from a SAP Datawarehouse background and i don't know much about sql queries or statements. I was wondering if i need this knowledge to learn SSIS, and if so in what situations?

Thanks in advance


Categories: 
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