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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What do you mean by RPT file? There are various different definitions.
0 Likes 0 ·
Naina_S avatar image Naina_S commented ·
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 ·
sp_lock avatar image sp_lock commented ·
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

·
sp_lock avatar image
sp_lock answered
Do you mean RDL? RPT is normally a Crystal report.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.