HI.
I need to develop a new report. But I need to know how can i do in SSRS
I have two tables-Setup master
Fields(item id,(invent table0-item id-lookup)frequency interval)
Customized table(item id,Status-machine,available,maintenance,machine ids,Frequency in 15 days,frequency in 60 days). No relation of table with each other
Image in attachment below-the format of report in the attchment
What should be the design of report
I was planning to go for SSRS report but i dont know
1-How to get the count of machine status on header part-if u see the format of the report(it cant be group as i want to show count)
2-How will i give an option to retrieve the 15 days frequency and 60 days frequency . I dont know how to design the SSRS report
please throw some light. thanks you all in advance
Hi NDngankar22,
If you don't have experience with SSRS, you have to go for some learning. There is documentation available here: docs.microsoft.com/.../development-tasks-for-reporting
You can also search on the internet for blogs and videos which could help you.
When reading your requirements, I do think you have to build a report using a data provider and temporary table which collects the data to print before sending it to SSRS.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154