I have had a couple of crazy things like that happen before. I don't remember the specifics though. I do remember I just wound up recreating the BAQ. It was easier than trying to fix a corrupted one.
I have had BAQs get corrupted before as well. It seems to happen when I attempt to remove a field from the display items. Somehow it thinks the field is still there but gives and error when retrieving the data. Again, I just recreated the BAQ. Don't see any real need to call support since they won't fix it anyway...can't recreate the error. Such is the world of programming. If something does not happen every time then it is not a bug. I was on their side of the fence for 20 years.
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
I have had BAQs get corrupted before as well. It seems to happen when I attempt to remove a field from the display items. Somehow it thinks the field is still there but gives and error when retrieving the data. Again, I just recreated the BAQ. Don't see any real need to call support since they won't fix it anyway...can't recreate the error. Such is the world of programming. If something does not happen every time then it is not a bug. I was on their side of the fence for 20 years.
Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: kw_foo
To: vantage@yahoogroups.com
Sent: Wednesday, September 30, 2009 4:06 AM
Subject: [Vantage] Export BAQ report to another company
Hi,
I am a newbie in Vantage, encounter a funny problem when I am trying to copy a BAQ to another company in another server (same version & patches - 8.03.408).
Everything is working fine in the source, able to view the report without any problem.
I following the step by export the BAQ, BAQ report & import it back to another server. Everything working fine and I able to load them without any problem. Last step is to copy the crystal report to the server.
When I try to test run the report, when Crystal runtime trying to load the report, it prompt a message saying a formula field (DATE() - PartTran.TranDate) must be a number.
After some detail checking, I realise a funny problem where in the BAQ manager, I am not able to remove the PartTran.TranDate from the Display Column(s) list, and has no problem with all other fields.
When I try to export the BAQ from the new company and compare the XML file against the source, realise that there is some different as follow:
New company XML:
<SelectedField>
<Company>123</Company>
<DCDUserID>manager</DCDUserID>
<ExportID>123-Test</ExportID>
<DataTableID>PartTran</DataTableID>
<Seq>8</Seq>
<FieldName>TranDate</FieldName>
<DBTableName />
<DBFieldName />
<DataType />
<Description />
<External>false</External>
<Formula />
<FieldLength>0</FieldLength>
<FieldFormat />
<FieldLabel />
<LikeDataFieldTableID />
<LikeDataFieldSeq>0</LikeDataFieldSeq>
<LikeDataFieldName />
<DisplayName>PartTran.TranDate</DisplayName>
<FieldOrder>8</FieldOrder>
<RowIdent />
<RowMod />
Source XML:
<SelectedField>
<Company>123</Company>
<DCDUserID>manager</DCDUserID>
<ExportID>123-Test</ExportID>
<DataTableID>PartTran</DataTableID>
<Seq>8</Seq>
<FieldName>TranDate</FieldName>
<DBTableName>PartTran</DBTableName>
<DBFieldName>TranDate</DBFieldName>
<DataType>date</DataType>
<Description>date of transaction.</Description>
<External>false</External>
<Formula />
<FieldLength>0</FieldLength>
<FieldFormat>99/99/99</FieldFormat>
<FieldLabel>Tran Date</FieldLabel>
<LikeDataFieldTableID>TaxTran</LikeDataFieldTableID>
<LikeDataFieldSeq>0</LikeDataFieldSeq>
<LikeDataFieldName>TranDate</LikeDataFieldName>
<DisplayName>PartTran.TranDate</DisplayName>
<FieldOrder>8</FieldOrder>
<RowIdent>0x000000000045ac52</RowIdent>
<RowMod />
<DBRowIdent>AAAAAABFrFI=</DBRowIdent>
</SelectedField>
Seem likes the some of the important (data type & field format) info is missing when importing to the new company. Anybody experience problem like this?
[Non-text portions of this message have been removed]