About new a Blank User Report by SQL script in MS SQL Server

rbuser

Hi all,

I want to create a Blank User Report using SQL script in a MS SQL Server.
I have writtern and executed the following code:

INSERT INTO rb_folder (folder_name, parent_id)
VALUES ('PFG', 0)
GO

INSERT INTO rb_item (folder_id, item_name, item_size, item_type,
modified, template)
SELECT IDENT_CURRENT('rb_Folder'), 'PrePrintForm', 0, 1, GetDate(), ''
WHERE IDENT_CURRENT('rb_Folder') IS NOT NULL

Although the report can be seen in Report Explorer, but I cannot open it.
Is there any method to do this?

Thanks,
Raymond Ng.

rbuser

Hello,

i am not using that RB-function to store them in SQL, i am using my own
methods to do that. But it seems to me, that you only inserts the
"directory" entrys for an report. You also need a template which is a
special form like a delphi form. Perhaps you can create one blank report in
the report-designer and save it as a default template. Insert that as a
binary on the right place in your "directory" structure. look at some
existing entries, like they do.

chris