Launch your Graphy
There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
SSRS usage Part1
access_time 1717245180000 face Vijay Kashyap
SSRS usage Part1 ----------1.Query reporting tables to see usage SELECT Catalog.Name AS ReportName, Catalog.Path AS ReportPath, Catalog.Type AS ReportType, Catalog.CreationDate AS CreatedDate, COUNT(ExecutionLog.InstanceName) AS UsageCount FROM Catalog LEFT JOIN ExecutionLog ON Catalog.ItemID = Exe...
SSRS Usage Part2
access_time 1717244880000 face Vijay Kashyap
SSRS Usage Part2 1.Add flag to see if a report is hidden or visible SELECT C.ItemID AS ReportID, C.Name AS ReportName, C.Path AS ReportPath, CASE WHEN C.Hidden = 1 THEN 'Hidden' ELSE 'Visible' END AS ReportVisibilityFlag FROM Catalog C WHERE C.Type = 2 -- Filter to select only reports (Type = 2) 2....
How to create a parameterised report in ssrs
access_time 1716534360000 face Vijay Kashyap
How to create a parameterised report in ssrs Creating a parameterized report in SQL Server Reporting Services (SSRS) allows you to generate customized reports based on user input. How to create a parameterized report in SSRS: Step 1: Launch SQL Server Data Tools (SSDT) Open SQL Server Data Tools (f...
How To Deploy A Report in SSRS
access_time 1716534000000 face Vijay Kashyap
How To Deploy A Report in SSRS SQL Server Reporting Services (SSRS) is a robust platform for creating, managing, and delivering various types of reports. Once you've designed your reports, the next crucial step is deploying them so that users can access and benefit from the insights they provide. P...
Shared vs Embedded Dataset
access_time 1716452880000 face Vijay Kashyap
Shared vs Embedded Dataset Shared datasets and embedded datasets are two different approaches to managing and using data in various applications, particularly in the context of software development and data analytics. Shared Dataset: A shared dataset is a dataset that is stored separately from the ...