Search results for query: *

Hi Guys, I'm running in Visual Studio 2010 (Visual Basic) two Crystal Reports when I press a button in my app. For Example : Button1_Click Report1() <-- This report has two pages Report2() <-- This report has one page But something happen when I run it because when you click the command...

Hi guys, We already have a server 2008 to create Reports but I need to install reporting services 2008 in my PC in order to design with the corresponding tool but I cannot find it.... I have Visual Studio 2010 installed on my PC and somebody told me that Installing SQL Server 2008 R2 I can...

Hi All ! In the past I used to work with VB 6.0 but now I need to start working in Visual Studio 2010 (Visual Basic .Net). Today My knowledge is about SQL 2008 Stored procedures for Programming and Reporting Services but I need to lear about .Net. I read in some sites about the Environment...

Hi Guys, Sometimes I receive messages as this one: E847 - You cannot Change Item 000020 This is when I'm trying to post a Shipment..... By my question is related about this: Is there a place (Website or something else) where I can go and found more information related to this kind of...

Hi guys! I'm curious in trying to understand how to debug with the debugging menu and Breakpoints in T-SQL. I'm using now the 2008 Version but I always use the Print '' Method in order to debug what is happening with my code.... Can you let me know how can I use the debug/Breakpoints in...

Hi Guys! I would like to know how to use the "Begin Trans" (Commit and Rollback) Process because is the first time that I'm going to use one.... (and I don't want to block anything of course) I have a Stored Procedure that do two steps: In the first step Insert/update one table (Master) and...

Hi Guys, I don't know what happen with my Laptop I just tried to turn it on and I cannot start Windows... It stay always on the windows screen without any move (As frozen)... I tried with the Safe Mode, Last Know Configuration, etc... and the same result.. I tried with the Windows XP...

Hi Guys, Just curious, I have an Excel Application that when I push a command button it runs severals processes (Around 30-45 seconds). Can I put a messagebox that says "Be patient.. etc" and then when the process finish to release this messagebox? It is because takes time and just the hour...

Hi guys, This looks very simple but I don't know why this is happening... I have a condition in my query like this: Where (sm.TransactionDate >= @LastDayInWeek and sm.TransactionDate <= @LastDayInWeek) When I run my query like that it tooks around 14 seconds to finish. But if I do this...

Hi guys, Right now I know this: SELECT * FROM TABLE WHERE CAMPO1 = 'Something' AND CAMPO2 = 'Other' If I used this Query without index it will do a Full Scan in my table to find my two conditions... But If I add an Index with this two fields it will be an index scan (faster) and I see the...

Hi Guys, I'm very interesting in improving my SP's, I would like to know how to use the Execution Plan in order to improve my SP's... Do you know guys where can I learn about this topic? I mean a place that talked about this and says step by step how to improve my queries using this Tool...

Hi Guys, I already finish with a Excel Spreadsheet that works with a main tab sheet that contains some graphics, of course the information of these graphics are in other tabs... what I see now is that other people (users) are moving the information of my tabs and also moving the graphic on the...

Hi Guys, I'm new working with Charts with Microsoft Excel (In my case Office 2003 yet). I finished my work but the only thing that I still missing is that I don't know how to handle that every bar change the colors depending of one range... for example: Day1 Day2 Day3 Worker 1...

Hi guys, Maybe an easy question... but a Have a Bar Chart that I would like to know if I can Click every Bar and send me depending of the bar to other Links? for example to another Excel Tab or a HyperLink? Is this possible? Or any suggestions? Thanks! MR

Hi Guys, Do you know if there's a function that give me this information? If I have the Date of today ( For example Getdate() ) depending of that day can I know the first day of the actual month and the last one with a function? For example I have this: 2-Jun-2010 And I Will know this...

Hi Guys, I'm trying to create a New DataSet with the option of putting CommandType as "Text" on my Report and this is what is working now: Select Company_Code, Department, From MyTable Where Accounting_Month = @Month But I Would like to manage the "MyTable" HardCode into a Variable as...

Hi Guys, I'm new working with Visual Studio .Net (2005 is what I have Know) and I know that working with Data we can Use Connected or Disconnected Environments... What I would like to know is how do you decide which one to use? I know that one is quicker than the other... But how can I know...

Hi Guys Maybe an easy question, but I don't know how to do it.... I have a SQL Table that is filled from an External Application. What I like to do is the next: I Have a field from this Table that now is filled with "NA" in every new record, this "NA" comes from the Default value on the SQL...

Hi Guys, Since sometime ago, I have always an issue with the Excel Format when importing something from other format. But the thing is this: Did you guys have an issue in the past trying to format a Column that already have values (For example changing the Date Format) and the Excel doesn't...

Hi Guys, Just curious, in some Web sites mention to use the Control K and then run some queries... What is the use of this HotKey? when I'm trying on the SQL New Query Windows it put me a message "Waiting for a second Key", also if I pressed twice it put a little box on the left of my code...