Same id name "gotcha"

pinbot

I've created some custom SQL queries for my .net report.

By default the names of these are "Table","Table1","Table2", etc.

I was up to "Table6".

To display the data from this table, I copied an existing TableObject.

You guessed it, FR.Net made it "Table6" also.

I designed the report and viewed it just fine. After displaying the preview, my TableObject Table6 was deleted and my parameters for my SQL Object were deleted.

Simple fix really, just rename one of the objects, either the SQL or TableObject.

I believe FR Studio would warn you if two objects had the same name.

No video this time!

:-)

AlexTZ

How did you copy the TableObject? Clipboard operations are disabled for database objects.

pinbot

TableObject is the "Table" icon at the left that you can drag/drop on the report.

Picture attached.

You can copy/past that and it uses the same naming convention "tablexxx" as creating a sql query.

It just happened that an SQL query and a TableObject both had a design id if "Table6". After previewing, FR.Net deleted my TableObject and erased my Query's parameters.

AlexTZ

I see now, thanks. The fixed version will be available later today.

pinbot

Thanks for the quick fix.

I figured it would be easy, just default the custom SQL queries to something like "Queryxxx" instead of "Tablexxx" .


Bryan