How to open .rdl to view xml in BIDS properly
-
I keep trying to open the .rdl file i have to take a look at some of the .xml and i know note pad works just fine, but i don't know why it all of a sudden opens in notepad instead of in bids like it used to. I know you don't exactly know my computer's file system very well, but i figure on install the files and folders for Microsoft SQL Server and pretty much the same. So i was wondering what the path is to open in MS Visual Studio 9.0 when you right click the .rdl and hit open with and go to browse.
i've even used this path c:\Program Files (x86)\microsoft Visual Studio 9.0\common7\ide\devenv.exe when trying to open with but its not working as it should.
The text is just black and white and i know that's not how it should be because key words turn red, and links turn blue and its not working this way.
And yes they are still .rdl files, i do not have a .txt extention on the end.
Attached are 3 different pictures.
One of what the .rdl files look like on my desktop and what i know they SHOULD look like
2nd is showing that it changed all my .rdl files to look like this, even in BIDS in the solution explorer
3rd is showing what i know an XML should look like in the editor (color wise) and what mine looks like when i open it now.
Any help would be appreciated thanks!
-
You should be able to open them in BIDs if you are not then something is wrong with your Visual Studio solution file, that is the file used to render the report. So you could try creating new solution and adding the old ones as existing items.
Kind regards,
Gift Peddie -
have you tried restoring file associations from within BIDS?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
Gift Peddie - they open in BIDS just properly not like i've been used to or expecting them. I explain that pretty well in my post on what is wrong.
mister.magoo - I tried this and nothing happened it just said "All default file associations have been restored"
-
c:\Program Files (x86)\microsoft Visual Studio 9.0\common7\ide\devenv.exe
The above is not the path to open the files you need to double click on the solution file for it to load the rdl files into BIDS for you.
Kind regards,
Gift Peddie -
i understand, but i'm not trying to see the actual report through the .rdl. I want to look at the XML part of the .rdl file. Most of the time i use this technique to search the xml to find out what stored procs are being used in the report.
-
avitale (7/8/2011)
i understand, but i'm not trying to see the actual report through the .rdl. I want to look at the XML part of the .rdl file. Most of the time i use this technique to search the xml to find out what stored procs are being used in the report.The rdl is the xml file Microsoft called it rdl because it is proprietary so just load it to any xml editor or text editor and you can read the file. If it consumed stored proc then you see only the name, if .sql file yes you can copy the code.
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply