Search results for query: *

Hi All, I clearly need someone to help me with a piece of code that I found online that I have hard to understand and apply it to my project. I'm totally new to C# and LINQ and I would really appreciate if someone could help me out due to the short deadline. So, I'm trying to read in the data...

Hi I'm struggling with SSRS again after not been using it for over 2-years. Anyone knows how to save the input values from a multivalue parameter to the DB? I appreciate that you taking the time. Thanks in advance.

I'm trying to use the iif(RowNumber(.... But how do i retrieve the current rownumber that is been picked thru the action when button is clicked? Thanks again

Hi All, I have a question regarding a deletion of a picked row from a reports result set using action buttons for each row. I'm trying to find a way to not using a function with multivalue parameters to pick the values that needs to be deleted from the table. So, instead having an action button...

SOLVED** It seems to be working now, I really don't know why it didn't execute in the first place. Thank you mstrmage1768 it is much appreciated. /R

Hi All, I get an error with this code even though is a sample straight out from the book "Start with C#". This should be a fairly simple error but i'm new to C# programming. The issue I have is that it does executing when I'm using an integer for var1 and var2, so a whole number works fine but...

Hi All, I have installed Adventureworks DW 2008 and everything looks fine except when I'm trying to deploy solution. It points to a bin directory that doesn't exist under the enterprise folder.??? Anyone that have seen this before?? I appreciate all efforts, thanks in advance. cheers "Error 1...

Denny, thanks for your respond. I was able to figure it out and ssis was exellent to use for this purpose. I created an xslt style sheet and denormalized the xml data and brought it back in ssis for transformation. Worked like a charm. Thx

Hi All, long ago I posted something here, I'm happy to be back. I have a question regarding blobs and how to deal with them in order to create a reporting platform and eventuelly create a BI layer of top. But, first thing first, what the firm has is a front end system that saves all the data...

Hi, I'm trying to connect siebel tools with bi publisher without any success. So, now i'm would like to try to connect oracle 10g with siebel tools and bi publisher with 10g. Any ideas or advice on how to do this? Btw is it even possible to run bi publisher without siebel crm and just have the...

Hi, I have to ask someone to help me to translate a t-sql date parameter report to a pl-sql (Sql*Plus). This was a while ago I did something in Oracle. All help is much appreciated. Thanks declare @StartDt date ,@EndDt set @StartDt ='2001-01-01' set @StartDt ='2001-02-01'...

Hi All, I was hoping for someone to help me out on how to use cursors and declared tables using t-sql in SAS. I keep getting this error message when i execute the script. /*----------- declared variables ---------------*/ 17 declare @CustomerID CHARACTER(12) _______...

I need to clarify I can see that. So, each ID has multiple classes such as 1001 has class 10,11 1002 has class 10, 23 So when I add the location to the query I get something like this 1001 class 10,11 location IL 1002 class 10 location IL 1002 class 10 location PA 1002 class 23 location IL...

Hi All, This should be so simple but I'm to tired to think. I have a list of ID's that contains classes and some of the ID's has multiple location. For these that has multiple locations I get dupes. Please help me out here I'm so I can't see the screen Thanks in advance

Hello All, I have an issue with my store procedure that has several date parameters in a report that allow blank values. When I try to execute the report my datetime picker force me to pick a date, how to get around this? I tried using expressions in the front-end with something like this...

********Solved********* Hi bborissov, I did it your way and finally got it right. Thanks so much.

hi bborissov, thanks once again for your respond, I do need to solve this issue in the backend though. This part is just a small part of the whole query and it contains more than just one section of comma delimited lists. This starts to qive me some headaches. I found a piece of code that does...

Thanks again man, yes that would be great if you could help me tomorrow. I need to come up with a solution on this before monday. The problem is that I can't join to a string of systemId's. I need to do something like this DECLARE @cols varchar(8000) declare @t1 (systemid varchar(50)...

Hi bborissov, I really appreciate your respond. I found another thread answered by you that is a much more brilliant solution with less code than I have presented. I agree with you when it comes to using declared tables instead of tmp tables, sometimes though you need to use tmp tables that...

Hi All, I'm trying to create a comma delimited list of classcodes and I can't see why the piece of my code beneath doesn't working. The purpose is to add this snippet to a main piece of code and to publish a report on the Reporting Services. I first tried to use a cursor that obviously doesn't...