SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Report Advice


SSRS Report Advice

Author
Message
rocky_498
rocky_498
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2666 Visits: 1476

Hi All,

I need an advice. I have Report template who has almost 56 fields. I created this report for “Report Template” everytime client request this type of report.I just change Client Name, Start Date,
End Date and the Number of fields client want to see and rename header name accordingly. Then schedule the report weekly/monthly or daily as per client request. I am looking some type of way to our in-house users can run the report/create and schedule by itself instead of IT request. I am thinking SSRS (That’s the reporting tool we are using right now).

Any advice would be appreciated.


Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45622 Visits: 15487
If you deploy the report to your SSRS server, then any of your users will be able to access the report via the web portal; provided you have given them permissions to access the report. They can then chose the parameters they require, and export it in a format they want (i.e. PDF, Excel, csv, etc). If they want, and again, if you give them permissions, they can even set up they're own subscriptions.


Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
rocky_498
rocky_498
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2666 Visits: 1476
Thomas, Thank You for your reply. That I know I can do those things and I am doing for some reports. However, The question was how I am able to Pull the fields that I need from 56 original template fields and rename those fields as need and schedule it. e.g
If I run Template report with below Variables
Client Name = ABC
Start Date = getdate()
End Date = RD +14
and hit "View Report", now I am seeing data with 56 columns. What I am looking, Client "ABC" just want to see only 9 fields out of those 56 fields and it could possible Client "ABC" want to see 9 fields in a different header name.
My real question is, how can I accomplish this task in SSRS. Is it possible in SSRS or not?
Thank You.







Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45622 Visits: 15487
rocky_498 - Monday, October 16, 2017 8:47 AM
Thomas, Thank You for your reply. That I know I can do those things and I am doing for some reports. However, The question was how I am able to Pull the fields that I need from 56 original template fields and rename those fields as need and schedule it. e.g
If I run Template report with below Variables
Client Name = ABC
Start Date = getdate()
End Date = RD +14
and hit "View Report", now I am seeing data with 56 columns. What I am looking, Client "ABC" just want to see only 9 fields out of those 56 fields and it could possible Client "ABC" want to see 9 fields in a different header name.
My real question is, how can I accomplish this task in SSRS. Is it possible in SSRS or not?
Thank You.








You can't customise a deployed report, no. If the client wants to always pick and choose what columns and name they want, you'd be best supplying them all. Then the client can download the full file as an xlsx file, delete the columns they don't want, and rename the ones they want to rename.


Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search