SQL Server - Quickly changing RDL files
Asked By CharlesL
18-Mar-10 01:41 PM
Hello, I have a series of 50+ RDL files that had to get srestored from a
data drive, and I do not have the original .VS solution that created them -
the reports all use different data sources. Is there a quick way to
dynamically change the name of the SQL server they are pointed to?
Bit
(1)
Report
(1)
Anohter
(1)
Dans
(1)
IMO
(1)
XML
(1)
RDL
(1)
Patrice replied to CharlesL
Any decent editor able to open 50 documents and being able to do a
search/replace especially if it has regular expression (perhaps Notepad++)
or a tool such as http://www.replsoft.com/replacer.html
In the worst case you could do it yourself programmatically (for example
once the reports are uploaded you could programmatically change them uses
SSRS web services or yet anohter option would be to work directly on the XML
RDL files) but it could take a bit longer IMO especially if you are
unfamiliar with those programming models..
BTW have you open those ? Are you sure the server name is in those files ?
The model we are always using is that the report just references a separate
data source file...
--
Patrice
no working drilldown in reportViewer, ASP.NET SQL Server I have Report A and report B. Report A has under "navigation-> Jump To Report", report B selected from the list. I also used the parameters button to insert both parameters required by Report B. Deploy both reports. On the catalog (server / reports / <folder> / A), I run the report A and can drill to report B. PROBLEM: When I go to my ASP.NET application, it doesn't;t work
Jump to Report problem SQL Server Hi, I guess this is a simple question. When I'm using "jump to report" in report A, it will navigate to another report (report B). The problem is, in report manager, there is no "back to parent" button in the report B, so I can back to report A. Is there any solution to solve this? Thanks SQL Server Reporting Services Discussions Create
SSRS 2008 SQL Server Hi All, I have a report with nested sub reports and these sub reports are toggled by parent report items. for Example: Country List - -- (Main Report) State list - -- (sub report of Country list report) - -- report results based on country key input. . . County list - -- (sub report of State list) - -- report results based on state key input. . . when I run the report showing all countries list
is in integer SQL Server I have an integer which is the summation of several bit-values. For example: bit(0) = 1 bit(1) = 2 bit(2) = 4 bit(3) = 8 If the integer field is 15, I know that is has bit(0)-bit(3) in them. If the integer field is 3, It contains bit(0) and bit(1) If the integer field is 10, It contains bit(1) and