question

Naina_S avatar image
Naina_S asked

Import .rpt file directly in SQL Server

Hello All, Please let me know how to Import .rpt file directly into SQL Server without changing the format. Thanks Naina
sqlserver
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What do you mean by RPT file? There are various different definitions.
0 Likes 0 ·
Hello All, Thanks for ur response. Yes im talking about Crystal report.i have heard about Report Commander .But I wanted to know can we write a script in query analyser to import data from .RPT file or is there any way we can do it from Management Studio. Thanks Naina
0 Likes 0 ·
Do you mean the report definition or the data contained in it? If you mean the data, you could possible export it to CSV and then import into a SQL database. Why dont you extract the SQL statement from the report at run that within SQL?
0 Likes 0 ·

1 Answer

· Write an Answer
sp_lock avatar image
sp_lock answered
Do you mean RDL? RPT is normally a Crystal report.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.