Recent content by Gonfer

Hello, I am working in SQL Server 2016 report builder. I need to use any marker or indicator when the value in a data column is NULL, otherwise display the value. I was dealing with the indicators and after inserted a column beside then I could to set an indicator for the NULL values but How...

Hello Guys: Please i need your support. I have developed a tool in excel containing a FORM saving data to a SQL server database. Everything is working smoothly when I test the tool in my network with many users simultaneously. My problem begins when I test the tool with remote users. I have...

Hi guys, I will appreciate any suggestion. I am reading the fields of a record set from the first field to the last one in order to write the data of each field into different cell addresses in a spreadsheet. What I need to know what is the correct syntax to refer correctly my variable name...

Thanks for the response mintjulep!! Declaring the arrays with the size was not the solution. I haven't expertise with VBA. The goofy problem here is originated for a really stupid action in the watch window in VB. The values were really kept in the variables, buy for some "microsoft" reason...

Thanks Andy for your response In the Module : Option Explicit Public MyArray() As String Public MyArray2() As String Sub Button_Retrieve_Click() UserForm1.Show End Sub In my UserForm I have also put "Option Explicit" in the top GonFer

Hello Guys, please help I have this piece of code in my UserForm_Initialize(): r = 0 ReDim MyArray(MyArray_Upto - 1, 5) Do While Not Rs.EOF MyArray(r, 0) = Rs.Fields(4) MyArray(r, 1) = Rs.Fields(5) MyArray(r, 2) = Rs.Fields(6)...

Hi guys, I have a form in Excel with a button for inserting data to a SQL table. The insertion works fine, the row is inserted successfully but the trigger related to my table in my database doesn't work, however when I perform any insertion working in my SSMS the trigger works fine!. I need...

Hi guys, I have a form in Excel with a button for inserting data to a SQL table. The insertion works fine, the row is inserted successfully but the trigger related to my table in my database doesn't work, however when I perform any insertion working in my SSMS the trigger works fine!. I need...

Bill, thanks for your response. Is there some select to know what tables are currently in auditing and what tables not? Thank you

Hello guys, I have 50% of tables in a database NOT SET UP in auditing, so I cannot get the information about if they are currently used by any app or if any of them are read by some SELECT statement. Like with the All_Tab_Modifications table where I can get Inserts, deletes, and updates...

Hi guys, I have defined an expression (fx) for a textbox showing the result of 3 different calculations in just in one textbox. Based in this formula: =CStr(Count(...))&" "&CStr(Count(...))&" "&CStr(Count(...)) I can get the counting for each one correctly, and show the 3 values...

SkipVought He he hates pdf format :). He must to send this report after look at it and send it converted in csv format. You know? If I export this report in Ms Excel standar (it means NOT DATA ONLY), the column dates works perfectly! but in this standar mode, there are problems with the cvs...

Thanks SkipVought !! for your response You are right those are values for the date column, but I am applying a formula field in my crystal report design for this column: ********************************************************************************** If Maximum ({eePayStatus.idPayStatus}...

Hi guys!!! I've designed a report containing a column with data type DATE cutomized as YYYYMMDD without "/" (only digits), It works in Crystal perfectly, when there is any date to show, and when there is no, shows blank, but when I export to Excell in DATA ONLY mode, the column with DATE data...

Thanks Charliy for your response, your suggestion is correct, but it doesn't solve my problem. My only one problem is how can I to sum the formula fields on the report footer Anyway Thanks!