Saving reports or folders don't show up

rbuser

I'm trying to make an end user solution where the user can create folders
and reports which get saved in the database.
I've create 2 tables 1 for items and the other for folders. When I create a
folder and check in the table I see a newly created record. But when i start
the ReportExplorer again the folder isn't shown. This is the same with
Reports they get saved but they don't show up in the explorer.
I'm using ReportBuilder 7.04.
What can the problem be?

Luc Neville
DMS Software products

nicocizik

Hi Luc,

1. Which database/connectivity are you using?
2. Are you able to successfully get the enduser database demo working for
your specific DB/connectivity combo? Be sure you are creating the tables
using the SQL or tables provided in the examples. See \RBuilder\Demos\4.
EndUser Databases\...

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> 1. Which database/connectivity are you using?

I'm using the BDE with MSSQL 2000
But I'm going to have a look at ADO after i get things working


I've changed some settings in the demo so it would connect to the correct
tables / database with the fields i created.
Right after I launched the explorer i see the folders and reports i've
created earlier with my program.

rbuser

I think i was using an incorrect tablestucture (mssql2000) .I was using
binary instead of text for the template field and i was experimenting with
and without identity(1,1) for both itemid and folderid and it seems to work
if i use identity(1,1). hopefully it keeps working now, thank you for your
support.

create table RB_folders
(
FolderId integer identity(1,1),
FolderName Varchar(100),
ParentId Integer
)

create table RB_Items
(
ItemId integer identity(1,1),
Deleted datetime,
FolderID Integer ,
ItemType integer,
Modified datetime,
ItemName Varchar(100),
ItemSize integer,
Template text
)