Matrix Report, Date: 1900-01-01 Wrong!! Suppose To Be Empty, How?

Aug 10, 2007

Hi
I am making a report in Visual Studio. I€™m making a matrix report. I have made a UNION of 2 tables. One of them has a field called Date and the other one does not. But to make a UNION of these 2 tables so that the results are printed in a Matrix I have to have the same fields€™ aliases at least. So what I did is that in the second table is:
SELECT €˜ €˜ AS €˜Date€™
Right?

Now, in the report the first table gives me the dates in a format:
=Format(Fields!Estimated_Close_Date.Value, "yyyy-MM-dd")

But, the second table is it doesn€™t have a date in that field when I run the report it gives me:
1900-01-01

Something I don€™t want.

So, how do I make it understand that the second tables date field is suppose to be empty?

View 8 Replies


ADVERTISEMENT

Row Group Text Is Wrong In Matrix Report

Nov 6, 2007

I have a matrix report with 4 row groups. I am experiencing a bug with the text that is displayed in the second group.

When it changes group 1, the text for second group is alway wrong for the first row in the list. It always shows the text that was displayed for the first row of the previous group1.

Here is what it looks like. Has anyone else seen this? Please tell me there is a solution and that matrix reports aren't just broken ...

Revenue

Income Type 1

Income A
Income B
Income C
Income Type 2

Income A
Income B
Expenses

Income Type 1

Expense A
Expense B
Expense C
Expense Type 2

Expense A
Expense B
Expense C
Expense Type 3

Expense A
Expense B
Expense C

View 5 Replies View Related

SSRS - Matrix Report (Reference Date And Main Date)

Nov 19, 2007

Dear Friends,
I have a doubt related with a report parameter in matrix control.
I have this interface:













Valor da Carteira (VC)
29-12-2006
31-07-2007

Valor Carteira
EBIT (Ytd)
Valor Carteira
EBIT (Ytd)

Sub-Total
Securities
Equities
120.213.477,65

758.105.292,62
-100.201.155,67

Bonds
4.012.782.282,99

3.355.388.548,39
-3.723.587.783,92

Warrants Equity



27.167,63


99.999.999,00
99.999.999,00
99.999.999,00
99.999.999,00

Traded and OTC Options

99.999.999,00
99.999.999,00
99.999.999,00
99.999.999,00

Other Derivatives

99.999.999,00
99.999.999,00
99.999.999,00
99.999.999,00

Money Market

99.999.999,00
99.999.999,00
99.999.999,00
99.999.999,00

Others




0,00


99.999.999,00
99.999.999,00
99.999.999,00
99.999.999,00

The MDX statment:


Code Block
SELECT NON EMPTY {
[Measures].[NC_ValorCarteira],
[Measures].[CM_EBIT] } ON COLUMNS,
NON EMPTY { (
[DimTime].[Hierarquia].[Dias].ALLMEMBERS *
[DimStructure].[Entidade_ID].[Entidade_ID].ALLMEMBERS *
[DimStructure].[Carteira_ID].[Carteira_ID].ALLMEMBERS *
[InstrumentoTipo].[InstArea].[InstArea].ALLMEMBERS *
[InstrumentoTipo].[InstTipo].[InstTipo].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (
SELECT ( { [DimTime].[Dia].&[8878],[DimTime].[Dia].&[9092] } ) ON COLUMNS FROM (
SELECT ( { [DimStructure].[Carteira_ID].&[LIS_CPR] } ) ON COLUMNS
FROM ( SELECT ( { [DimStructure].[Entidade_ID].&[LIS] } ) ON COLUMNS
FROM [cbRentabilidade])))
WHERE ( [DimTime].[Dia].CurrentMember )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS



I have 2 dates as input. The main date and reference date (Last date of previous year) of the main date.
At the moment I manually insert the values for main date and reference date, but I only one to select the main date and automatically insert in the first column of the matrix report the reference date.

Understood?
Thanks!!!

View 6 Replies View Related

Updating Database Date Field Results In Date Value Of 01/01/1900

Jun 18, 2007

Brand new to this, so please bear with me.I'm using the following code fragment to update a datetime field on a SQL Server 2005 database table:cmd.CommandText = "Update Projects Set EntryDate = " & Convert.ToDateTime(txtEntryDate.Text)cmd.ExecuteNonQuery()The result of the update operation is the the database field contains the value "1900-01-01 00:00:00:000".  This probably means that I passed nulls to SQL; however, I see a valid date in the txtEntryDate field on my web form (i.e., "06/18/2007").  I also did a "Response.write" to display the txtEntryDate and it looks Okay.Can someone tell me what I'm doing wrong?Thanks!Using Visual Web Developer 2005 Express.

View 1 Replies View Related

1/1/1900 Date

Oct 2, 2001

I insert an empty field from a form to a SQL 7.0 table which has a collumn with datetime type and allowing nulls, but I always get a default date 01/01/1900. I don't want this date, how do I get rid of it? Thanks

View 1 Replies View Related

Birth Date 1900-01-01 00:00:00.000

Apr 12, 2005

Hi,all,

How to check the default value set up for datetime field? The reason I am asking is my database

field "birthday" is datetime(8), the default value I set to '' already. Everytime my asp program
have empty birthday or invalid birthdate for this field, the system automaticaly set it to

1900-01-01 00:00:00.000

Do you know what happened?

Thanks!
Betty

View 3 Replies View Related

T-SQL (SS2K8) :: Date Column With 1900-01-01 Value

Dec 23, 2014

I have a date column with 1900-01-01 value, I am trying to get the min(date) without 1900-01-01.My problem here is: there are some records with both 1900-01-01 and real date. How do I get the MIN of the real date without getting 1900-01-01. Below is my query sample.

CASE WHEN MIN(CAST(PROJECTEDSTARTDATE AS DATE)) = '1900-01-01' THEN NULL ELSE MIN(CAST(PROJECTEDSTARTDATE AS DATE)) END as 'ProjectStartDate'

View 3 Replies View Related

SQL Server Automatically Changing Date 1900-01-01 To 2001-01-01

May 16, 2008

I have a SSIS data flow task that downloads data from an Oracle source which has some real dates and some date values of 0001-01-01 which I am trying to convert to '1900-01-01' using a decode(Date1,'0001-01-01','1900-01-01',Date1). The problem I am having is that when I run the package in Business Intelligence Development Studio on my local machine the date value is stored correctly in the SQL table in a datetime field as 1/1/1900 12:00:00 AM, however when I run the package from the server the field gets saved as 1/1/2001 12:00:00 AM.

I have tried a bunch of ways to work around this issue and the only solution I have found that works it to download into a temp table and then load into the live table. Does anyone have any idea of what might be causing this issue when I run the package from the server?

View 1 Replies View Related

Date Selection Giving Default '1/1/1900' For NULL Values

Feb 9, 2005

'XXX_DTE' is character type which wont take NULL.

SELECT CONVERT(Datetime,XXX_DTE) FROM XXXX

I get result as : 1/1/1900

Why is it so.....

What I expect is '0000-00-00 00:00:00.000'

View 1 Replies View Related

Why Date Columns Default To 1900 After Inserting Dates In SQL Server Everywhere.?

Sep 19, 2006

I have created a sample Database for the school project,

After executing the query below, the Date column is supposed to have the dates I have entered before,

However the dates shown are 1900.

Any idea why is this happening?

I appreciate your help.

Thank you.
Query:
 
Drop table AccountReceivable
GO
--BEGIN TRANSACTION
Create table AccountReceivable
(
 AccountRecID int identity (1,1) not null,
 PatientID int not null,
 PresentCharges int default 0 not null,
 PaymentMade money default 0 not null,
 PreviousBalance money default 0 not null,
 BalanceDue money default 0 not null,
 LastPaymentDate datetime not null,
 PresentDate datetime default GetDate() not null
)
GO
ALTER TABLE AccountReceivable ADD CONSTRAINT
PK_AccountRecID Primary Key (AccountRecID)
GO
 
ALTER TABLE AccountReceivable ADD CONSTRAINT
FK_PatientID_PatientID FOREIGN KEY (PatientID) REFERENCES PATIENT (PatientID)
GO
--COMMIT
--query to find delinquent accounts
--DATEDIFF (d, LastPaymentDate, PresentDate)
 
--Populate the Accounts Table
DELETE AccountReceivable
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate )
                    VALUES (913235,451.34,50,0,401.34,4/7/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (918035,109,109,0,0,3/6/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                            VALUES (914235,279,89,0,190,5/9/2005,5/9/2005)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                            VALUES (914235,0,90,190,100,5/9/2005,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (912224,67.90,67.90,0,0,2/2/2006,DEFAULT)
GO
 
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (900814,678.32,78.32,0,600,4/6/2006,4/6/2006)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (900814,0,500,600,100,4/6/2006,4/16/2006)
 
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (900814,0,100,100,0,4/16/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (913010,203,0,100,303,2/6/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (913010,0,80,303,223,8/3/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (913230,1030.89,1030.89,0,0,4/16/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (918035,78,60,0,18,7/1/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (941235,902,502,0,400,8/15/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (941235,0,200,400,200,8/15/2006,DEFAULT)
 
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (952235,134,24,0,110,4/18/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (952235,0,20,110,90,4/18/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (921635,257.87,57.87,0,200,5/27/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (921635,0,20,200,180,6/27/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (915235,1204,200,0,1004,3/15/2006,DEFAULT)
 
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (915235,0,100,1004,904,4/27/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (900035,578,178,0,400,7/10/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (900035,0,100,400,300,7/19/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (913241,157,0,0,157,5/12/2006,DEFAULT)
GO
INSERT AccountReceivable (PatientID,PresentCharges,PaymentMade,PreviousBalance,BalanceDue,LastPaymentDate,PresentDate)
                    VALUES (913241,0,57,157,100,5/16/2006,DEFAULT)
 
 
GO
 
--sample query

select PatientID,PresentCharges,LastPAymentDate,PresentDate from AccountReceivable

GO

--result

PatientID PresentCharges LastPaymentDate PresentDate

----------- -------------- ----------------------- -----------------------

913235 451 1900-01-01 00:00:00.000 2006-09-15 12:54:55.297

918035 109 1900-01-01 00:00:00.000 2006-09-15 12:54:55.297

914235 279 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000

914235 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.297

912224 67 1900-01-01 00:00:00.000 2006-09-15 12:54:55.297

900814 678 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000

900814 0 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000

900814 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.313

913010 203 1900-01-01 00:00:00.000 2006-09-15 12:54:55.313

913010 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.313

913230 1030 1900-01-01 00:00:00.000 2006-09-15 12:54:55.313

918035 78 1900-01-01 00:00:00.000 2006-09-15 12:54:55.313

941235 902 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

941235 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

952235 134 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

952235 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

921635 257 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

921635 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

915235 1204 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

915235 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.327

900035 578 1900-01-01 00:00:00.000 2006-09-15 12:54:55.343

900035 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.343

913241 157 1900-01-01 00:00:00.000 2006-09-15 12:54:55.343

913241 0 1900-01-01 00:00:00.000 2006-09-15 12:54:55.343

(24 row(s) affected)

 

View 6 Replies View Related

Problem With Subtotals Of A Matrix (Blank, Pdf, Empty Column)

Apr 16, 2008

Because i get no answers i will try it again:

Hi,

i have the following problem:
I have a matrix with a right subtotal column and this matrix was in a list (because in the end i will have more than one matrix). The list fits perfectly the matrix in design mode. But if i render the report in the viewer or to pdf, an additional blank area (like a blank copy of the subtotal column) was inserted after the right subtotal column of the matrix and increases the list too. You can see this easy by set the backgroundcolor of a list to a color. Without the subtotal column the list fits perfect after rendering. The problem is that this additional blank "column" creates empty pages in .pdf rendering, if the width of the matrix is near the page width. The same behaviour happens if i put the matrix with subtotal in a rectangle.
I must use a list in the end because the the final report contains some matrixes and a subreport.
So is this a bug?
Someone must have this problem too?

Thanks for any help.

View 5 Replies View Related

Broken Lift Chart And Empty Classification Matrix In Data Mining

Sep 5, 2007

Hi,I am studying data mining features of SSAS and for a workshop I'vecreated 2 views derived from vTargetMail view of AdventureWorksDW.Train data consists every record except those in Pacific, and testview consists only records from Pacific area.1. I've created a mining structure based on Decision Tree and selectedBikeBuyer as predictable column.2. According to input column suggestions, I've selected Age,Eng.Education, NumberCarsOwned, YearlyIncome, CommuteDistance,NumberChildsatHome and TotalChildren as input columns,3. I've modified no other setting, and deployed project.I can get training results in decision tree browser and dependencynetwork (and both seem to give rather logical results) however, when Itry to browse lift chart or classification matrix I get an emptyclass.matr. and a lift chart of a single 45 degree line.Am I missing a step, or must I do some fine-tuning on (what)parameters?Thanks...

View 2 Replies View Related

Broken Lift Chart And Empty Classification Matrix In Data Mining

Sep 5, 2007

Hi,
I am studying data mining features of SSAS and for a workshop I've
created 2 views derived from vTargetMail view of AdventureWorksDW.
Train data consists every record except those in Pacific, and test
view consists only records from Pacific area.


1. I've created a mining structure based on Decision Tree and selected
BikeBuyer as predictable column.
2. According to input column suggestions, I've selected Age,
Eng.Education, NumberCarsOwned, YearlyIncome, CommuteDistance,
NumberChildsatHome and TotalChildren as input columns,
3. I've modified no other setting, and deployed project.



I can get training results in decision tree browser and dependency
network (and both seem to give rather logical results) however, when I
try to browse lift chart or classification matrix I get an empty
class.matr. and a lift chart of a single 45 degree line.



Am I missing a step, or must I do some fine-tuning on (what)
parameters?

View 3 Replies View Related

Problem With Report Viewer , No Data Is Displayed And Report Comes Out As Empty

Dec 6, 2007

Hi ,

I have a problem using Report Viewer With SQL Reporting Services 2005.


I had a really weird issue with a ReportViewer. It would show the little green Loading progress bar image €¦ but it wouldn€™t show any data, just a white background where the output should be. I knew the data was there because exporting to Excel or PDF showed the data just fine.

The problem is report toolbar is display but NO DATA is displayed and the report comes out as EMPTY .


Thanks in advance..

Can you please help me out in resolving this problem.

View 18 Replies View Related

Adding Columns To A Matrix Report That Don't Belong To The Matrix Columns Groups

Jan 2, 2007

Can we do this?



Adding more columns in a matrix report that don€™t
belong to the columns drilldown dimensions€¦



That is, for example, having the following report:

Product Family


Product

Country City Number of units sold





Then I
would add some ratios, that is, Units Sold/Months (sold per month) and other that
is the average for Product Family (Units Sold/Number of Product Family), for putting an example€¦ some
columns should be precalculated prior to the report so do not get into it, the
real problem I don€™t see how to solve is adding one or two columns for showing
these calculated column that doesn€™t depend on the column groups but they do
for the rows groups€¦




Any guidance
on that?


The only
way I am seeing by now is to set it as two different reports, and that is not
what my client wants€¦






Many
thanks,
Jose

View 4 Replies View Related

HOW To Select A Matrix (cross Join) With Empty Records To Retrieve The Same Amount Of Records For Each Cell

Nov 2, 2006

Hello

Im searching for a solution to set all matrix row or cell the same height.
it schoud looks like this example:

This is a simple matrix


test a

text b








text c








text d

text e

text f








text g










This is a matrix with all the same row-height.



test a

text b

.








text c

.
.









text d

text e

text f








text g

.

.









Thx you a lot

View 3 Replies View Related

What Is The Best Way To Get Empty Date?

Feb 20, 2008

tbl_store
id numeric(9)
enddate datetime(8)

tbl_store Data
ID Enddate
1 01/02/2020
2
3 01/02/2010
4
5 01/02/2001

(empty enddate data is showing <null>)
This is my query...but i want to get date empty records too.
select * from tbl_store where Enddate> '02/20/2008'

I want output
1 01/02/2020
2
3 01/02/2010
4

View 21 Replies View Related

Inserting Empty Date

Oct 11, 2004

undefined

I am using VB6 and SQL7. I am asking a user to enter a date if applicable - specifically a product manufactured date. I then take that date, using the dateadd function, query a table for a specific code, and calculate an expiration date based on the particular code.

The problem - if the user does not enter a manufactured date, which is OK, SQL inserts 01/01/1900 - which I do not want. How do I handle?

I am inserting the date, if there is one, from a flexgrid. I am declaring the variable as variant. The SQL field is DateTime.

Ex:

sSQL = "Insert into RecI(manufacdate) values ('" & (flxRec.TextMatrix(ctr,14)) & "')"

Please Help!

View 2 Replies View Related

Getting Wrong Date Format

Apr 8, 2008

Hi Guys, I am trying to convert a date to yyyymmdd format

This is the input date: 1/10/2008 2:59:58 PM
This is what I am getting: Jan 10 2

Field definition: MaxDate (nvarchar (8) , not null)

Code:
INSERT INTO tblCurStatus (ResultsPKey, Status, MaxDate)
SELECT ResultsPKey, Status,
MaxDate = (REPLACE(REPLACE(CONVERT(varchar(8), tblStatusHistory.Date, 112), '-',''), ' ', ''))
FROM tblStDate INNER JOIN tblStHistory
ON (tblMaxStDate.CurStatDate = tblStHistory.Date)
AND (tblMaxStDate.ResultsPKey = tblStHistory.ResultsPKey)

I cannot understand why I’m not getting the format I want. What do I need to do to get yyyymmdd?

Thanx much,
Trudye

View 4 Replies View Related

Log Shipping Report Empty

Oct 4, 2007

I have implemented log shipping on one my databases. Logs are being shipped just fine and are even being applied. Change something on primary and you will see it on the secondary.

However when I generate Transaction Log Shipping Status Report from the Primary Server, I see that Stauts is GOOD. I see primary and secondary servers names. I see when the Last backup occured. But there is no data on COPY and RESTORE. Those columns are grayed out or should I rather say colored gray with no values.

When I go onto secondary node and generate Transaction Log Shipping Status Report, columns under Restore header are popluated. But columns under BACKUP and RESTORE are grayed out.

On monitor node Transaction Log Shipping Status Report doesnt show when the last backup, or restore or copy occured. It only shows the threshold value for backup and restore.

So I have two questions:
1) why am I not seeing all the info in one place? how can I find out how far behind is secondary?
2) shouldnt Transaction Log Shipping Status Report from any node show me same information?
3) even though changes are making it to secondary once the threshold value is hit, status would not be GOOD anymore. so no matter what I do it would be out sync when it is not.

what has gone wrong here?

View 3 Replies View Related

Report Parameters Not Empty

Jan 8, 2007

Hi,

I have four reports with the same three report parameters. Two of them have defaults. Last is empty and must be selected.

I created one main report and added those four reports as sub reports. I also created 3 parameters in the main report and mapped the parameters of the subreports to the main report. I also setup that the first two parameters are filled and that the last one is empty

Now if I run the main report in the IDE it gives for the last one an empty parameter which is correct.

If I publish it to the reporting server, the last parameter gets filled by the first of the drop downlist.

Why is it not empty ? And how do I clear it ?

With regards,

Constantijn Enders

View 1 Replies View Related

How To Update An Empty Date-type Field

May 23, 2006

Hi,
I have update function that updating sql database table.
In the table I have fields like: name, address, phone, …, install_date
 
updateScreen(txtSName.text, txtSLocation.text, txtSPhone.text, txtSAddress.text, txtSPostal.text, ddSCity.SelectedItem.text, ddSCountry.SelectedItem.text, txtSOwner.text, txtSInstall.text )
 
The function work fine except the part whent install_date field is empty then I have the following message:
 
System.InvalidCastException: Conversion from string "" to type 'Date' is not valid.
 
Ii would like to use the same update function to make an updates even when date field is empty.
 
If someone has any idea how make it work, I would appreciate that
    
Alex

View 4 Replies View Related

Date Between Two Days Gives Wrong Output?

Aug 28, 2013

I have a table with a date column of datatype varchar(15) and the format is dd/mm/yyyy

When I write the following query, it displays complete data of the table and it cannot understand I want only between '01/08/2013' and '31/08/2013'

select date,column1,column2 from table1

where date between '01/08/2013' and '31/08/2013'

How to fix this?

View 4 Replies View Related

Report Shows Empty Page

Oct 10, 2007

The last page of the report has a table or rectangle (tried both) which is supposed to be invisible based on a parameter. However, the page still shows up with only the header! Apparently the report knows that the next element (table or rectangle) has to be on a new page, and only too late figures out that the element is invisible.


Anybody else encountered this, or has a solution?
Thanks

View 2 Replies View Related

Get One Extra Empty Page In My Report

Nov 23, 2007

Hi All,

I am desging my report with few text boxes , List , Matrix Tools and binding them with proper fields

if matrix having no data it is working fine
but when ever the matrix having data, then also it is working but am Getting One extra empty page
why this is happening i am not getting

plz help me some one

View 10 Replies View Related

Report Builder: I Must Be Doing Something Wrong...

Jan 11, 2008



Hi all, first post on Microsoft forums. Our agency is attempting to implement Reporting Services as a reporting platform (for both canned & ad hoc reports) for a system we're developing, and I'm running into some major problems with the ad hoc (Report Builder) portion.

To provide better context, let's set up an example. Say I'm tracking complaints filed by consumers against businesses. A complaint can be filed by multiple consumers against multiple businesses. There is a many-to-many relationship between consumer & complaint, and a many-to-many relationship between business & complaint. So the database would look something like this:
Consumer (PK: consumer_id)
Complaint (PK: complaint_id)

Business (PK: business_id)
ConsumerLink (FKs: consumer_id & complaint_id)
BusinessLink (FKs: business_id & complaint_id)


In my first attempt at making a model, I have flattened ConsumerLink with Consumer, and BusinessLink with Business. So I end up with 3 views:
Complaint (PK complaint_id)
Consumer (PK consumer_id, FK complaint_id)
Business (PK business_id, FK complaint_id)

Note that due to the flattening of the link tables, there may be some duplicate consumers & businesses in the above views if they are related to more than one complaint, which is fine.



Now comes the question. I want to build an ad hoc query that lets me enter a business name and show all consumers that have filed a complaint against it. In SQL this would be a very simple query:
SELECT b.business_id, b.name, c.complaint_id, co.consumer_id, co.name
FROM

Business b
LEFT JOIN BusinessLink bl ON b.business_id = bl.business_id
LEFT JOIN Complaint c ON bl.complaint_id = c.complaint_id
LEFT JOIN ConsumerLink col ON c.complaint_id = col.complaint_id
LEFT JOIN Consumer co ON col.consumer_id = co.consumer_id
WHERE

b.business_name = 'criteria'

However, because the Complaint table has an OptionalMany relationship with both tables, Report Builder prevents you from adding both tables to the same ad hoc report. As soon as you drag one of the two onto the report, it becomes your new "top level table" on the table tree, and you cannot drag the other table over anymore. Now, I understand that it makes sense to prevent the user from, say, trying to show all the consumers and businesses associated with a particular complaint in the same dataset, since that would result in a cartesian join and potentially lots of duplication. However, that's not what we're trying to show, we're trying to show all the businesses that match a criteria, all the complaints for those businesses, and all the consumers for those complaints.

After some research, I discovered this thread which describes the same problem:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=175657&SiteID=1
The solution proposed there was to drag the complaint & consumer tables onto the report, and add the business name as a filter only. Unfortunately, this is not good enough. If there is more than one business which matches the name you provide, you have no way of knowing which business is associated with which complaint. All you get is a list of complaints and the consumers associated with them.

Am I doing something wrong in the views/model? Is there any way around this without flattening the whole thing into a huge data warehouse with massive cartesian joins and do reporting against that? At this point, I'm sooner willing to accept excessive data as a cost of flexible reporting. I'm a huge believer that there's an elegant solution to any problem though, and none of the above are elegant.

Thanks,
Alex

View 5 Replies View Related

SSIS Converting To Date Empty Fields (no Values)

Jan 8, 2008



Hi, how do I convert dates with SSIS, when I receive dates I have no problem, with empty fields I have to go through a transformation as:


trim(field_name) == "" ? "999999" : substring....... (derive transform)

after this I have to update each field holding '999999' to NULL. (using sql task)

Is there an easier way to doing this?

Thanks

View 1 Replies View Related

Wrong Date Sort Order In Enterprise Mgr

Feb 3, 2006

When clicking on the header for the Date Created column in EM (SQL Server 2000) , in the tables list for a database, I noticed that the tables don't get sorted by created date at all - looks like random order, without looking too close.

Is this is a bug (probably not??) or some kind of collation-related problem?

View 2 Replies View Related

Wrong When I Specify The Report Server Database

Dec 10, 2007

My db version is sqlserver2005 sp2
Now, I need to install report services
However failed when i specify the report server database after report services was installed
It prompt the database version(C.0.8.40) does not match the report services installation.You must update your reporting services installation.
but how to update reporting services installation?
Thanks a lot

View 2 Replies View Related

Help With The Matrix Report

Mar 2, 2007

Hello All!

I developed a matrix SSRS report for a specific scenario, and the results look something like the example below. The result set is grouped by the date value, so for all records on that date in the first column I have just one value - 2/5/2007. The client would like to see a value for each cell in every row in the date column, so they can sort the results and do other manipulation in Excel. I tried to make it happen but I doesnt seem to work using the matrix. I would really appreciate if anyone has any suggestions on how to make it work. btw, it really has to be a matrix report :)

Thanks, everyone!















2/5/2007
Value 1
3604




Value 2
5250

Value 3
1281

Value 4
1612

Value 5
2861

Value 6
2135

Value 7
850

Value 8
5368

Value 9
1146

Value 10
2928

Value 11
1435


Value 12
195

Value 14
1414

Value 15
776

View 4 Replies View Related

Matrix Report

Jan 30, 2007

hello all,

I have to make matrix report,
my problem is that I have to make report like this picture:
http://img2.tapuz.co.il/forums/1_93196948.jpg

Is there is a way to make it?
do I need a subreport?


Any tips would be appreciated Thanks

View 2 Replies View Related

Add A New Row To Matrix Report

Apr 18, 2008



Hi ALL,

I'm trying to create a report using matrix report.
I use a simple query like this.

SELECT Catergory, Month, SUM(TotalApp) AS TotApp
FROM Table1
GROUP BY Catergory, Month

result is like thsi
Approved 2007-03-01 00:00:00.000 60198
Approved 2007-04-01 00:00:00.000 59786
Approved 2007-05-01 00:00:00.000 80608
Decisioned 2007-06-01 00:00:00.000 65981
Decisioned 2007-07-01 00:00:00.000 60217
Decisioned 2007-08-01 00:00:00.000 59040
Decisioned 2007-09-01 00:00:00.000 45180

Now I want to add Approved into one row and decisioned into the next row like that. I can easily do row grouping in the matrix. but then I wont be able to add new rows inbetween those groups. I want to add some rows inbetween those groups to include calculated fields.

I try to use something like this;

=IIf(Fields!Category.Value = "Decisioned" , Fields!TotalApps.Value, " " )

But It gives the same result for every group.( does not matter whether its decisioned , Approved or smthign else)

can any one tell me how to do this?

Thanks

View 6 Replies View Related

Help With Matrix Report

Apr 25, 2008

Hi Everyone,

I am having some trouble creating my employee schedules report. I would like to design a report like this:

Name | 7:00am | ............|..............|................|..30 minutes apart..|................|................| 8:00pm
Frank [ FIRST BRK ] [ LUNCH ] [ PROJ 23 ]
Tony [ FIRST BRK ] [ LUNCH ] [ COACHING ]


The dataset includes the following fields:


EmpID int

EmpName varchar

RowDate date

StartTime datetime

StopTime datetime

SegmentCode char(10)

ColorCode
Can someone please advise me on how I can create this report in SQL Server 2005 Reporting Services. Thank You

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved