Showing posts with label rpt. Show all posts
Showing posts with label rpt. Show all posts

Friday, March 23, 2012

Report name (XYZ.rpt) to be printed on the report without the path where its sav

Hi,
Can anyone tell me how to print the name of the report (XYZ.rpt) without the path. In special fields there is a field called "File Path and Name". I need to print only the name and not the path of the report.
If anyone has done this before please let me know.
Thanks,Soething like

select reverse(substring(reverse(path),1,charindex('/',reverse(path),1)-1))

Wednesday, March 21, 2012

report model and it's datasource

hi everyone,

I created a report model and deployed it. When I open the rpt builder on web I get the following error.

'The selected data source does not have and content available'

Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa

If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql