CrystalEnterprise 9 Error: "The rowset column could not be found"

[hc5316]

----------------------------------------------------
Error Type:
webReporting.dll (0x80004005)
"The rowset column could not be found. File 5b42f5f41b6fd2.rpt."
/crs/getreport.asp, line 231
-----------------------------------------------------

Line 231:
Call exportControl.ProcessHttpRequest(Request, Response, Session)

My getreport.asp (using SDK connect to crystal enterprise server to get report) works with most of reports.. but for some report... the script returns the above error. Any idea ??

Thanks,
-Howard

 

[cjlarue]

I have seen this when the stored procedure for the report was missing or had a problem.




Regards
Chuck LaRue
ADRS Computer Services

 

[hc5316]

Thanks... for your reply

The problem was b/c I don't know there is another report with the same name on a different folder... my query (accidentally) pull out that old report (which doesn't work)....

Problem was solved by adding parent_folder_id.. into query to pull out the exact rpt.

my problem now... is reading parendfolderid return object... and I don't know how to convert object to string... (cstr doesn't work with object)


----------------------------------------------------
'' The data from query result.. I have is an object....(parentFolderId)
'' Response.Write display the value... but I have problem when append the parentFolderId to another string
'' How to convert the object to string (get object value) ??

Dim parentFolderId
set folderResult = IStore.Query("Select SI_ID From CI_INFOOBJECTS Where SI_PROGID = 'CrystalEnterprise.Folder' And SI_NAME = 'CRS'&quot
parentFolderId = folderResult.Item(1)
Response.Write(parentFolderId )
Response.Write(VarType(parentFolderId) )

otherString = "parent folder id: " & parentFolderId


Error:

------------------------------
Microsoft VBScript runtime (0x800A000D)
Type mismatch
-------------------------------



Thanks,
-Howard