Search results for query: *

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

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

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

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

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

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

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

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

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

I'll appreciate if somebody can help me. PLEASE!!! I can't find something to solve this issue: Database in NoArchive, Tablespace USERDATA dropped included Datafiles, I keep the last cold backup only. What are the correct steps to restore and recover the tablespace included datafiles WORKING...

I have two OS in my Laptop. Wvista and XP. How can I extend the Windows Vista partition (c:\)? I have a "free partition" aside, but on the Wvista partition the extend option is disable!!