microsoft reporting services

Hi,
In Microsoft Abalysis Manager one can browse the cube data by right
clicking the cube and drag and drop columns to view data. Can the
same be achieved with reporting services.
Thanks in advance
BajiraoI'm not sure if I understand your question perfectly. There is a preview
function that you can use in the Report Designer that allows you to see what
a report would look like, plus you can preview the data set. If you're
asking whether or not you can query OLAP cubes from Reporting Services, the
answer is that you can, but you need to know MDX in order to do so.
We are working on a whitepaper that addresses this topic. It assumes you
already have good knowledge of MDX. Given the number
of inquiries, I've gone ahead and posted it over on the OLAP MSN group. You
can find it in the general discussion are of.
http://groups.msn.com/OLAPServicesDevelopersForum/
Sean
Sean
Sean Boon
SQL Server BI Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Bajirao.B.T" <btbajirao@.yahoo.com> wrote in message
news:736f0ba3.0403180730.4e63cfd5@.posting.google.com...
> Hi,
> In Microsoft Abalysis Manager one can browse the cube data by right
> clicking the cube and drag and drop columns to view data. Can the
> same be achieved with reporting services.
> Thanks in advance
> Bajirao|||Thanks for the reply. I my be not clear in expressing what I want.
In microsoft analysis manager on right click, browse cube data > one
form pops up. There we can drag and drop dimensions from the top to work
area. So that the cube takes different shapes.
The same functionality I want to achieve in the web browser useng
Reporting services is that possible or not is my question.
Regards,
Bajirao
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

sql

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

MICR Font Issue When Exporting to PDF

Hi,

I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is.

Thanks in advance,

Tom

Hi Tom,

I am having the same problem did you by any chance solve this problem?

Thanks

|||

We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on.

|||

Hi Tom

Thanks for replying

But i tryed even to Open the PDF on the same mechine that i am running the SSRS Report From that has the micr font in it , and still dont see the Micr Font in the PDF at all not even substitute with a other font what could be the problem?

Thanks

|||anyone have a answer for this?|||Microsoft tech support says the font must be a True Type font. Also, for some reason, the fonts seem not to work at 12pt or above. 10 and 11 pt seems to work fine.|||Witch font are you using that works with 10 and 11 pt becuase my font dose not work with this either so can you tell me witch micr font are you using?|||so can you please tell me which micr font will work by pdf export?|||

Like Ryan said, make sure you have the font installed on both the server and on the client.

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

I am facing the same problem. The text in MICR Font disappears when i render the report to PDF.

Is there any solution/workaround for this problem?

|||

Ok... we found a solution.

Increase the height and width of the textbox, which contains the text in MICR font.

that solved our issue

|||Could you help me fix my MICR report like you fixed yours? I tried increasing the height and width of the text box. I need help ASAP. Thanks|||Make sure the MICR font is on the same mechine that you open the pdf and leva space fot the height and the width and try woth Size 12 max this worked by me|||I tried that. Could you send me a .rdl file by email? I would appreciate that.|||

can also be that your rdl file is corupted so try the same on a other rdl file with same font and a text box the hight be bigger than the font and see then

also check the pdf file by CTRL-D fonts tab check if the pdf has the font in it, if it dose you shuld be good to go just play around with the Height if the text box

btw: no email address is specified

Mgmt Studio: List versus Details view

So now all the Details views have the "Policy Health State" column. Great. But when will we be able to add other columns to the details views? Or at least put back what SQL 2K used to show in details views? Pretty please?

Hi Bob,

We actually have plans to only display the Policy Health State in the Details section for only those objects that have policy state. For CTP6, we are looking to extend the Object Details to show many more properties than you had in the past. Please stay tuned.

Bill Ramos,

Lead PM

|||Many, many thanks Bill.

Merging two dbs

Hi
I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?
Thanks
RegardsYou can script out all the objects and try running on the 2000 Server|||The easiest way would be to add an instance of 2005 on that server and
simply copy them<g>. But assuming that is not an option and you have not
used any 2005 specific features or datatypes you can still do it. First
script all the objects using SSIS and then run those scripts in the other
db. Then export the data from the 2005 dbs and import them into the tables
in the 200 instance. Make sure to backup everything first.
Andrew J. Kelly SQL MVP
"John" <John@.nospam.infovis.co.uk> wrote in message
news:%23AinXisUGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi
> I have two sql server 2005 dbs on server A. I need to copy all items
> (tables, view, sps and so on) from the two dbs into a single db on server
> B. The added problem is that server B is SQL Server 2000 so direct copy is
> perhaps not possible. How can I achieve this?
> Thanks
> Regards
>
>

Merging two dbs

Hi
I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?
Thanks
Regards
The easiest way would be to add an instance of 2005 on that server and
simply copy them<g>. But assuming that is not an option and you have not
used any 2005 specific features or datatypes you can still do it. First
script all the objects using SSIS and then run those scripts in the other
db. Then export the data from the 2005 dbs and import them into the tables
in the 200 instance. Make sure to backup everything first.
Andrew J. Kelly SQL MVP
"John" <John@.nospam.infovis.co.uk> wrote in message
news:%23AinXisUGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi
> I have two sql server 2005 dbs on server A. I need to copy all items
> (tables, view, sps and so on) from the two dbs into a single db on server
> B. The added problem is that server B is SQL Server 2000 so direct copy is
> perhaps not possible. How can I achieve this?
> Thanks
> Regards
>
>

Merging two dbs

Hi
I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?
Thanks
Regards
The easiest way would be to add an instance of 2005 on that server and
simply copy them<g>. But assuming that is not an option and you have not
used any 2005 specific features or datatypes you can still do it. First
script all the objects using SSIS and then run those scripts in the other
db. Then export the data from the 2005 dbs and import them into the tables
in the 200 instance. Make sure to backup everything first.
Andrew J. Kelly SQL MVP
"John" <John@.nospam.infovis.co.uk> wrote in message
news:%23AinXisUGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi
> I have two sql server 2005 dbs on server A. I need to copy all items
> (tables, view, sps and so on) from the two dbs into a single db on server
> B. The added problem is that server B is SQL Server 2000 so direct copy is
> perhaps not possible. How can I achieve this?
> Thanks
> Regards
>
>

Merging two dbs

Hi
I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?
Thanks
RegardsThe easiest way would be to add an instance of 2005 on that server and
simply copy them<g>. But assuming that is not an option and you have not
used any 2005 specific features or datatypes you can still do it. First
script all the objects using SSIS and then run those scripts in the other
db. Then export the data from the 2005 dbs and import them into the tables
in the 200 instance. Make sure to backup everything first.
Andrew J. Kelly SQL MVP
"John" <John@.nospam.infovis.co.uk> wrote in message
news:%23AinXisUGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi
> I have two sql server 2005 dbs on server A. I need to copy all items
> (tables, view, sps and so on) from the two dbs into a single db on server
> B. The added problem is that server B is SQL Server 2000 so direct copy is
> perhaps not possible. How can I achieve this?
> Thanks
> Regards
>
>