Hi everyone,
i have a problem with Microsoft SQL Server Reporting Services (SSRS) report design.
I did all the steps to create a new project in SQL Server Business Intelligence Development Studio. I checked the report with "preview" and everithing is ok.
Then i used the LN configurator under tools to prepare the report to be deployed in LN. No errors found.
I modified the Solution Explorer / Properties, as shown in document U9657
I copied the file under:$BSE/application/tf<vrc>/btfgld
Then i went in LN to see if the rport works. But the message is that thre is no report on report server. I didn't know how to set the field "SSRS design present" in "Maintain reports" session.
How can i run a report using SSRS? How can i "import" the report in LN ( i tried also to import it using ttrpi1200m000 even if i know that it's not necessary).
Thanks in advance for your help
best regards
Camilla

I copied the file under:$BSE/application/tf<vrc>/btfgld

This is something you should not do manually, but leave it to session ttrpi1200m100 (Import SSRS Designs). Then also the flag "SSRS design present" is set in "Reports".
Use session ttrpi1200m000 (Export SSRS Designs) to send the designs to your report server.

Summarized the steps are:
1. Develop the design in BIDS
2. Prepare for Deployment
3. Import with ttrpi1200m100 from client project folder
4. Export with ttrpi1200m000 to report server
5. Print the report to the MS Reporting Services device which has your report server as the -server argument.

You can do an alternative route for step 3 and 4. Actually you don't need to have the report designs in the LN dictionary. This is only needed if you want to distribute the designs to other environments by means of a patch or PMC solutions. You can also deploy the report designs from BIDS directly to the report server. In the project properties in BIDS you need to define your report server and the target folder (the same folder you defined in ttrpi1500m000, but the placeholders like $pacc must of course be substituted by the real values). Then you can deploy from BIDS. After that you will be able to print the report from LN. Note that it may be necessary to restart the bshell in this case, because the result of the check whether a report exists on the report server is cached within the bshell.

Hello to everyone,
i solved the problem!
I imported the report from the project itself, selecting "client" in the session:
ttrpi1200m100.
After the import i was able to print the report using the printer MS_SSRS1
Thanks in any case!

Thanks a lot,
you helped me very much!

how can i import the report ? and what kind of file that i have to select and import ?

Hi,

The best way to start working on SSRS is to follow the standard documentation available on InforXtreme.

U9656G US is the code. All the necessary steps are properly documented. In case of any issues, you can post on the board. Basically, you need to create a device in LN. When you print a report, select that device. It will generate an XML file which needs to imported in BIDS. When you connect LN with SSRS, all the generated reports will be viewed from SSRS and you can just select it and import it. Later, create the design for the same.