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))
Showing posts with label rpt. Show all posts
Showing posts with label rpt. Show all posts
Friday, March 23, 2012
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
Subscribe to:
Posts (Atom)