Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gonfer

    How to Join or combine two data columns in a Tablix - Report Builder SSRS

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

    Excel Form - Compile error in hidden module.

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

    How to refer (Syntax) a variable name (cell address) in a range(varname)

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

    variables out of context when Click Event in a ListBox

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

    variables out of context when Click Event in a ListBox

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

    variables out of context when Click Event in a ListBox

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

    When Insert rows from VBA in Excel into a SQL Server table the trigger for insert doesn't work in DB

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

    When Insert row from VBA in Excel into a SQL Server table the trigger for insert doesn't work in DB

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

    How to Detect old tables not currently read

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

    How to Detect old tables not currently read

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

    Formating an expresion with colors

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

    19000100 when date is zero exporting to excell

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

    19000100 when date is zero exporting to excell

    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}...
  14. Gonfer

    19000100 when date is zero exporting to excell

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

    SOS with formula fields!!

    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!
  16. Gonfer

    SOS with formula fields!!

    Hi guys, Please!!, I need to solve a headache with formula fields, I need totalize each column column code on the report footer. Eeach formula field calculates the amount for each employee So, after I have grouped, I calculate the amount for each one, example: for @CALC22E I get the %value...
  17. Gonfer

    HELP TO GET AND SHOW XML DATA FROM A TEXT COLUMN SSRS 2008

    Hi guys, I need to get and show from a text column data with XML data I think...(<Id>10</Id><Field>a</Field>) it contains names and phones. How can set up in the tablix text column inside my design report in SSRS 2008 to read and show these names an phones?? I really...
  18. Gonfer

    How to select or highlight a row by clicking

    Hi guys I'am getting a nightmare to design one report by using SSRS 2008 (mandatory, I have no choice in this case). I need to solve a critical issue for the final users in my report: When you select by clicking the column of a row in the parent report to call any other "Child" report...
  19. Gonfer

    Prolem with Store SP with variables and parameters to exec a select

    Hi guys I'm trying to execute a store procedure in the query designer of a Dataset report in SSRS in visual studio. Depending of what I choose in the parameter called p_member (With membership, or No membership the Sp must to execute the select with the value text in the conditional, but I have...
  20. Gonfer

    How to use comparison parameters SSRS Visual Studio

    Hi guys, I am working in a project report for a single table. One of the reports is in cascade, reason why I am using parameters in the query for the Dataset, If I would need only indicate some specific data for each parameter, I don't have any problem. my problem starts when I need to indicate...

Part and Inventory Search

Back
Top