Hi,
I've searched the forum for "show datasource" to no avail so apologies if my searching isn't up to scratch.
Basically how do I show the datasource that is being used in a report?
I know how to specify different datasources and companies but i just want to see what datasource and company was used as default in the ribbon.
Any ideas?
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment I went with =NL("Rows","Company",,) in cell c1 then referenced =Left(C1,10) and =mid(C1,11,20)
That gives you the text that the key runs on for the default.
It's not pretty and relies on the datasource database and company names being a certain size but it's enough for a reference. -
Jet Reports Historic Posts There's no way to know what the default was when the report was run. The best thing to do in this case is to put the data source on the report in the report options and use DataSource= and reference it in your Jet functions. Then it doesn't matter what the default was when it was run since the report used whatever data source you specified and you can see that. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts There's no way to know what the default was when the report was run. The best thing to do in this case is to put the data source on the report in the report options and use DataSource= and reference it in your Jet functions. Then it doesn't matter what the default was when it was run since the report used whatever data source you specified and you can see that. Does this help?
Regards,
Hughes
In regards to setting the datasource on the functions, you're absolutely right but the Jet Report displays all the ledger entries for 51 testing scenarios and as such has many many many NL's and i couldn't bear the thought of going through them all! :roll: -
Jet Reports Historic Posts That's an interesting thought to parse the data source out of the record key. I hadn't thought of that! So actually you can do even better and not depend on the data source being a specific size by using the Excel FIND function. So if the record key is in cell C1, then in cell D1 you could have this: =FIND("""",C1,2) and in cell D2 you could have this: =MID(C1,2,D1-2). The first function should find the position of the 2nd quote character (the one after the end of the data source name). Then the mid function gives you the text starting after the first quote character up to but not including the 2nd quote character. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Thanks I'll give it a shot on Monday!
Please sign in to leave a comment.