Post reply

Hi...please help mePublish a report

  • December 11, 2008 at 11:45 am

    #204027

    Hi,

    Please help me publish a report...Giving the steps..

    Suggest me a good online maual with some good examples

    It's really taking away all my time I'm getting some strange errors of ever seen lenghier.. 🙁

    I need a step by step process of deploying a report...

    Please provide me solution asap...

    Thanks in advance

    Vsoma

  • December 12, 2008 at 3:49 am

    #911532

    Select the solution on top of solution explorer. Right click and go to properties.

    There are two option - Debug and deployment.

    IN deployment there are 4 options:

    Overwritedatasource - U can select false or true. If u want to overwrite each time then select yes. By default it is false.

    Targetdatasourcedatefolder - select the folder on your report server. U will have the name of folder on your server. You can write the same text as you can write in Targetreportfolder.

    Targetreportfolder - this is the place where you wanna deploy your folder. say on server SQL01 you have folder calle REPORTS.

    You will write REPORTS. If you have folder calles reports and then subfolder called finance then u will write REPORTS/FINANCE. SO it will deploy your report into finance folder of reports into SQL01 server.

    TargetserverURL - http://SQL01/ReportServer

    Then you press ok and deploy it.

    Please note that i have assumed your server name as SQL01. u need to write name of your server where Reporting services installed.

    regards,

    vijay

  • December 12, 2008 at 11:47 am

    #911848

    HI,

    Thankyou for responding

    I tried doing as you said. But, still it's asking me for Report Services Login.

    First time, I didn't change anyhing, it had the default values for Targetdatasourcefolder as 'Data source'

    and left the targetport folder as the default value what it was. It was still asking me for the Reporting services logon

    (it was asking me to give the Reporting Services Login, where I had to enter two fields (the Server name was showinup with URL) . (I think I gave URL correctly like http:\\ \ReportingServer) But I'd to enter the other two fields which are related to Webservice logon User name and password. )

    Can you tell Where can I get the webservice logon things..? Please help me resolve this issue

    Actually, I think I might have done wrong at what you said to do for

    Targetdatasourcefolder - Can u please explain me how can I grab this thing from the report server. I see only default thing there is ReportServer folder which didn't work in my case.

    Targetreportfolder - You said this is the place where we wanna deploy our folder. I didn't get this thing. I choose something else for this. Is this where we save our report package. I'm lost here.

    I'm pretty much new to SSRS.

    Can you please explain me some thing more of targetdatasourcefolder and target portfolder. And also before doing this do I have to configure any thing in Reportserver Configuration manager?

    I know this really costs a lot of patience to go in detail. But, please try to provide me as many details as you can.

    Thank you,

    Vsoma

  • December 15, 2008 at 12:06 pm

    #912708

    Are you creating a new ssrs environment or trying to take over an existing SSRS setup?

    If new:

    Install the SSRS package from scratch on the webserver you are deploying to (same one running IIS) and if security allows it, the same one running SQL Server. This may not be the most secure way to do it, but it is the simplest.

    If existing:

    Find all of your .rdl files and make sure you have a good copy of them. If you can obtain the logon credentials for the person who created the environment...this may be who you need to login as to make the thing work, at least until you can provide yourself sometime to move the environment to another profile...If you can't find the logon credentials, see step one...create the environment from scratch....then add back your rdl files....

  • December 15, 2008 at 1:46 pm

    #912778

    Thanks a lot for responding

    I got it in an easy way with the feature of IIS, and having everything set at default.

    But, I'd like to know more about the credentials concept. What are these for? I understand these for some authentication purposes. But, I'd like to know if we can implement this with in just IIS - Reporting environment everything set at default.

    Also, I'd like to know what more we can do with every option we have in Report Configuration manager. I understand it's working having everything by default. If I go for changing anything, It asks me for the logon credentials while deploying to the Reporting server.

    Also, I didn't understand the purpose of rdl files. Where can I find these things? Can you please tell me something more of rdl files.

    I appreciate for spending your time on this..

    Thank you,

    Vsoma

  • December 15, 2008 at 3:27 pm

    #912840

    The authentication has to do with what type of environment you are deploying to....if it's within a windows domain inside a firewall or to the external world....Best case is that you are allowing users inside your domain to run the reports and they can run them using their existing network credential....

    The RDL files are the report definition. This is what you create normally with Visual Studio (although you can do it notepad). The Visual Studio option is all that I know...another file type you'll want to look for is the .snl and/or .rptproj which are project files that the rdl files are grouped with....Also look for RDS files which are report data source files...they define how you connect to the database

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply