Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts

Monday, March 12, 2012

Question on particular report region layout properties

Hi, all experts here,

Thanks a lot for your kind attention.

I have been trying to adjust the report regions fit into the whole report page. I could see the width and height property of the whole report page from the report property dialogue, but where can I find the width and height for the particular report region like the table? Then I could accordingly adjust the layout of both the report page and report region like table?

Hope my question is clear for your help.

With best regards,

Yours sincerely,

Clicking on the top left corner of the table object, you can see the properties of the table. There should be a Size property that has width and height.

Hope this is what you're looking for.

cheers,

Andrew

|||

Hi, Andrew,

Thanks a lot for your kind suggestion.

Yes, I clicked on the left corner of the table and the table property dialogue box appeared, but there is no size property there.

Any futher advices? I am looking forward to hearing from you further shortly.

Thanks a lot again.

With best regards,

Yours sincerely,

|||

Did you click twice & hit F4 to see the properties window? That is strange. You can also click anywhere on the report and hit tab to cycle through the controls, or hit F4 to view the properties window and select the table from the drop down list.

cheers,

Andrew

|||

Hi, Andrew,

Thanks a lto for your kind advice.

By all means I could be able to make it work. Jutst wondering a simpler way of doing it.

With best regards,

Yours sincerely,

Saturday, February 25, 2012

Question on Cube actions

Hi, all experts here,

I am having a question on cube actions. What is the easiest way for us to see all actions properties(including objects to trigger the actions, etc.), hope it is clear for your help and I am looking forward to hearing from you shortly.

Thanks a lot in advance.

With best regards,

Yours sincerely,

Hello Helen. Are you missing any information in the actions tab of the cube editor?

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your kind attention.

Well, I asked the question from a end-user point of view like when they browse their data from end clients like Excel 2007, rather than respectively click on each object displayed in Excel to see know available cube actions, is there any way that they can have an overview of all available cube actions on the cube they are browsing in Excel? So that they are able to have a whole idea of what actions are available on the cube.

Thank you very much again for your kind advices and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

|||

Hi Helen. I have not seen this option in Excel2007. I think it is only possible by right clicking a member.

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your very kind atttention and advices and help.

With best regards,

Yours sincerely,

|||I suppose you could shade the back color of all cells that have actions on them using a Back_Color(this) = assignment in the calc script. I personally think that would clutter a spreadsheet, but it's an option if you're desperate.|||

Hi, Furmangg, thank you very much for that. It's been very helpful advices.

With best regards,

Yours sincerely,

Question on changing startup parameters

I'm new to SQL Server...running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.

Server won't start as I messed up and did not include the file name in the new designated path...just down to directory level.

From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.

Is there a file that contains these parameters I may edit or should I try using the command line options.

Many thanks in advance.Was able to do a reg edit on the parameters and have it running.|||You can also start it from a command line with parameters.

sqlservr [-sinstance_name] [-c] [-dmaster_path] [-f]
[-eerror_log_path] [-lmaster_log_path] [-m]
[-n] [-Ttrace#] [-v] [-x] [-g number] [-O] [-y number]

Look at SQL BOL for the complete reference. It's a handy thing to know at 2:00am.

Regards,

hmscott|||I'm new to SQL Server...running SQL Server 2000. Had to move the system database logs to a different drive. Used EM, Server properties, Startup parameters. Changed the transaction log designation. Closed that window. Stopped the server.

Server won't start as I messed up and did not include the file name in the new designated path...just down to directory level.

From what I've seen, I have to be able to start the server service to change the parameters and the server won't start.

Is there a file that contains these parameters I may edit or should I try using the command line options.

Many thanks in advance.
Just a note: sometimes the paramters, when used in conjunction with other parameters, will act in an unpredicatable way. use google for more info|||just another reason to script everything.|||just another reason to script everything.
a real reason to script everything? all these sex ads (http://www.napstergirl.com) floating around the internets. I once thought that it was cool, but think of all the space this is wasting? anyway, this one ad kinda made sense to show cause look at the website: it is so advanced and could be used for other things