Search the Community

Hello, I'm new to SQL and I need help understanding the best approach to our current problem. I need to build a custom parameter-based report in Microsoft SQL Report Builder 3.0 where you select two or more collections as parameters. The report should then cross reference which computers exist in all selected collections and output their name it to the report. I have built a static query I can run against the SQL server directly, but we need to be able to dynamically select a collection for easier reporting purposes. This is the query I use: SELECT v_GS_SYSTEM.Name0 FROM v_GS_SYSTEM WHERE Name0 IN (SELECT Name from v_CM_RES_COLL_CMS0020B) AND Name0 IN (SELECT Name from v_CM_RES_COLL_CMS000D1) I don't know how to proceed in how to make the above query into a parameter report in Report Builder, or how to otherwise get what we're looking for. Does anyone know? Any help is greatly appreciated.

Hi, I've come across a Report Builder issue, which is quite baffling. I have installed Report builder 3 , and two in the meantime, and tried the fixes as below, switching between two and three respectively within registry, but no luck I've also tried to launch configmgr as local administrator, and two domain admin accounts on two seperate domains, and still no luck, please advise. http://social.techne...4e-329698a917f2 Thanks. Coenie

I keep getting the following error when I try to edit SCCM reports. I downloaded and installed reportbuilder 3.0 on my deployment server and my workstation. I changed the registry to point to 3.0, restarted server, and ran as admin. Regkey that changed: “HKLM\Software\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\Reporting\ReportBuilderApplicationManifestName” I even reinstalled as the Local Admin account. Same error. Anyone have any ideas on what else I may need to do?