Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

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

edited December 2002 in RAP
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.

Comments

  • edited December 2002
    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


This discussion has been closed.