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.

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

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

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

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

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

Hi All, I have a problem with a report that contain a subreport that generates policy classcodes and a main reports with policy details. I would like the main report to show all the classcodes generated by the subreport for each policy on one page. Instead the result returns the policy details...

Hi All, I have an issue with an insert that gets me headache at this point, I can't see what I'm missing so another pair of eyes would be much appreciated on this one. So, I'm trying to insert a policyNo, FirstName, LastName,FirstName1,LastName2 etc into temp table. Here is my tmp table "ID...

Hi, I can't figure this one out. I have the following expression. =fields!Name.Value The sample return this value. Amy Anderson - >#500 The first part including the dash is a string, the string is concatenated with a column value which returns the >#500 part. My question is how do I get rid...

Okay, I decided to start a new thread due to the fact that my issue is a little bit different than Bessebo's on this subject, sorry about that. I'm trying to create a report with multiple parameter choice and being able to use the 'ALL' option. It works fine picking multiple values as long as...

Hi guys, I have an issue with the reporting part in Visual Studio 2005. I’m trying to create a report with a script that runs fine in sql server but, not in the Visual Studio environment. The script uses parameters multiple times and that is what its complained about. Here is a simplified...

Hi guys, I was hoping for some help with my little problem. I’m using previous status together with previous date if the current status is not what I want. The table is joined twice so I can use table b’s date is less then table’s a date to use previous date. The my problem is that when I use...

good evening folks, I have an issue with a loop and I was hoping for some input from any of you guys, that would be greately appreciated. I'm trying to update an empty tmp column with the average value of a product for each year, one year at the time. This should be fairly simple but, I can't...

Hi Fellows! I could definately need another pair of eyes to take a look at the issue I have with a replicate, I can't see what's missing in my code. As usual I appreciate all your input. Thx replicate('0',22 - len(round(abs((cast(a + b + c + d + e as decimal (38,2))) * f)...