Report doesnt sortPlease help

Hi everyone,
I created a report where I display informations about travels.

Data are grouped by a unique code (travel code), but they're not sorted chronologically, even though in my ASP page I specify ORDER BY date_beginning.

I also created a new group (for date_beginning) within Crystal Report, and then I moved it at the first position, but nothing changes.

I'm really in trouble, any help is appreciated
Thanks in advanceHi,

the best way to Handle this is to Order the way want in the SQL
Query and bring the Data, then on the Report just set the Group order to
'Original', first set the All the Group order to Original if u have other group as well then try this sql order it will work then one by one set the other gouping order to see which couses the prob... surely another gouping order is effecting the Order.

FaFa

Report does not display the same as in the Preview window in Visual Studio

After formatting the report and making it look like I want too in the
Preview window of Visual Studio. I deploy the report to the web server
and when I open it - the web rendering (formatting) does not duplicate
what I see in the Preview window. It looks like it's adding extra rows
between the objects and is not following the vertical alignment that
was used in Visual Studio.
Does anyone have ideas on what could be causing this?
Thanks..I do. Verify if there are textboxes overlaping each other. In preview
windows this issue do not cause problem, but at render time, it does.
[]s
Renato
"Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
news:ce53542a.0408260535.724891fd@.posting.google.com...
> After formatting the report and making it look like I want too in the
> Preview window of Visual Studio. I deploy the report to the web server
> and when I open it - the web rendering (formatting) does not duplicate
> what I see in the Preview window. It looks like it's adding extra rows
> between the objects and is not following the vertical alignment that
> was used in Visual Studio.
> Does anyone have ideas on what could be causing this?
> Thanks..|||Thanks... That worked.
"Renato Aloi" <aloi@.jew.com.br> wrote in message news:<OS$E9e3iEHA.2760@.TK2MSFTNGP15.phx.gbl>...
> I do. Verify if there are textboxes overlaping each other. In preview
> windows this issue do not cause problem, but at render time, it does.
> []s
> Renato
> "Manuel" <mxgamez@.kelsey-seybold.com> escreveu na mensagem
> news:ce53542a.0408260535.724891fd@.posting.google.com...
> > After formatting the report and making it look like I want too in the
> > Preview window of Visual Studio. I deploy the report to the web server
> > and when I open it - the web rendering (formatting) does not duplicate
> > what I see in the Preview window. It looks like it's adding extra rows
> > between the objects and is not following the vertical alignment that
> > was used in Visual Studio.
> >
> > Does anyone have ideas on what could be causing this?
> >
> > Thanks..

Report Does Not Display in Designer

Hello,

I am developing some reports for an ASP.NET solution, but my IDE does not display the design view of the reports. Instead, it only displays the XML definition even when I click View Designer. Yesterday the reports showed up correctly, and I know that the design view is there. Is there a setting that has been changed somewhere?

I guess you are trying to add the report to your ASP.Net application project. If you do that and view the report (.rdl file), you can only see the xml view. You can see the design view only if you add it to Report Server project under Business Intelligence Projects group.

Shyam

|||I figured it out. Thanks.

report does not display data

Hi friends
i created a very simple report (VS 2005 standard edition). which works fine.
i added a new column to the underlying table (actually its view) . this column's data is combinations of 2 other varchar columns.
when i added this column to my report, for some reason , report does not display any data when i run the report!! actually there is data as i run that view in query analyzer.
any ideas how to resolve this issue or investigate this problem ?
Thanks for your helplooks like i need to refresh "refesh fields" .after that everything worked nicelysql

Report display in Firefox

Hi everyone,

I know there are issue with reports not displaying as expected in ReportViewer when using Firefox, including the weird 'add something wide to your header' bug, but I've encountered a slightly different problem.

I'm using a matrix report, which displays perfectly in IE, and will render nicely when exported to either excel or pdf format with either IE or Firefox. However, when you simply view the report in firefox it looks awful: all the columns of the matrix are squashed so much that you can't read anything at all. OK, I can just say to people "export the report", but it'd be good if I could fix this.

Any ideas will be much appreciated. Thanks

This is a known problem. I don't know if there are any updates yet. What you can try is add a blank textbox to the footer of the report and stretch it manually to the width of your report. This will force the report to stretch in Firefox.

|||

Hi,

I already have a line the same width as my report in the header, and I've added a blank textbox the width of the report to the footer. Unfortunately, there's no change. The 'cells' of the matrix are still mini and totally unreadable. Thanks anyway

|||

dhassen:

and I've added a blank textbox the width of the report to the footer

Just to confirm, is this the footer of the report or the page. If its the report, then add it to the page footer. For inserting a page footer, do this:

When you are in the design view of report, go to Report Menu from the menu options, add a Page Footer (if you don't have one), drag and drop an empty textbox on this footer and stretch it.

If you have already done it, I am out of solutions.

|||

yep, unfortunately it was the page footer that I tried. Ah well... see if anyone else has any ideas

report description

Hi,
How can I display the report description on the report itself?
Have been looking over the books online but can't find the answer there.
Maybe its not supported?
regards,Please clarify the question.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi,
> How can I display the report description on the report itself?
> Have been looking over the books online but can't find the answer there.
> Maybe its not supported?
> regards,
>|||Hi,
Thanks for replying!
In the properties dialog of a report there is a 'Description' field in which
we are setting with text that describes the report's purpose.
Basically, I'm looking for a way to add this description field in a textbox
on the report, such that the description text is printed on the report. Is
there a global object collection which exposes this property?
example: Globals!reportName displays the report name, is there something
similar for the description?
regards,
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:uChoKJjpEHA.896@.TK2MSFTNGP12.phx.gbl...
> Please clarify the question.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Emmanuel" <emmanuel@.email.com> wrote in message
> news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > How can I display the report description on the report itself?
> >
> > Have been looking over the books online but can't find the answer there.
> > Maybe its not supported?
> >
> > regards,
> >
> >
>|||The Description property is not exposed. One workaround for this is to add a
textbox to your report that contains the description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emmanuel" <emmanuel@.email.com> wrote in message
news:uAvux$jpEHA.1300@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Thanks for replying!
> In the properties dialog of a report there is a 'Description' field in
which
> we are setting with text that describes the report's purpose.
> Basically, I'm looking for a way to add this description field in a
textbox
> on the report, such that the description text is printed on the report. Is
> there a global object collection which exposes this property?
> example: Globals!reportName displays the report name, is there something
> similar for the description?
> regards,
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:uChoKJjpEHA.896@.TK2MSFTNGP12.phx.gbl...
> > Please clarify the question.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Emmanuel" <emmanuel@.email.com> wrote in message
> > news:O3tHvnhpEHA.868@.TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > How can I display the report description on the report itself?
> > >
> > > Have been looking over the books online but can't find the answer
there.
> > > Maybe its not supported?
> > >
> > > regards,
> > >
> > >
> >
> >
>

report data with different char-set other than english

In my report i have to display data from sql db which has this data string in
Russian language. The report object and the text box object have a very
promising property
called: language but setting this property to the required language is not
helping.
How can i make my report to display this data. We changed the language
seeting and IE encoding settging to view the data in the report to the
correct format but its not working. So far what we found is either the report
or reporting services is escaping the high (over 128) characters in the HTML
page.
Any input is appreciated.
--
TIA
-PSHello PS,
I would like to know this issue clearly.
Did you mean that you want to show the text which is in Russian and stored
in SQL Server database?
If so, I don't think you need to do any configuration in the reporting
service and the textbox will show what you stored in the SQL server
database.
Could you please let me know more clearly about which data you stored in
SQL Server and what you want to show up?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the reply!
Yes i want to just display the text (Russian language data) in the report so
that user can read the data in Russian language without any problem. The data
is stored in the sql server by another application and we just use sql query
in report to select the data and display it in the report. We are able to
see the same data that is stored in the sql server in the report but the data
is not readable. It is like this "Iiia? aa. AAeeoae." in report. when we
select the data from query analyser it shows the same data("Iiia? aa.
AAeeoae.") which is not readble in russian lang.
When we put this data in a sample html page and set the enocding to
"Cyrillic (Windows) it is readable by russian user. But when we open the
report in report manager and set the encoding in the browser to "Cyrillic
(Windows) it is not readable. what we have to do in reports to make it
readable? we tired the report object and the text box language property to
the russian lang setting but we still get the same junk data. I hope this
--
TIA
-PS
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hello PS,
> I would like to know this issue clearly.
> Did you mean that you want to show the text which is in Russian and stored
> in SQL Server database?
> If so, I don't think you need to do any configuration in the reporting
> service and the textbox will show what you stored in the SQL server
> database.
> Could you please let me know more clearly about which data you stored in
> SQL Server and what you want to show up?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello PS<
I would like to know the data type of your problem column and you could
send me the sample HTML file to get the data and show up correct.
I guess you are using the varchar data type for the data and varchar data
type did not support the unicode. If you insert the Unicode char into it,
it will convert into some unreadable format and you may not conver it back
directly.
I would like to suggest you modify the application which insert the data
into your sql server.
Here is a sample to insert and retrieve the unicode data for varchar data
type. Or you may consider to use the Nvarchar data type.
drop table Russia
create table Russia (id int, mytext varchar(100))
insert Russia values (3, cast(cast (N''as varbinary(100)) as varchar(100)))
select id, cast (convert(varbinary(100), mytext)as nvarchar(100)) from
Russia
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the reply.
I changed the varchar data type column to Nvarchar data type as you said but
still getting the same issue. will my old data will be converted to nvarchar
type after changing just the column data type to nvarchar?
Regarding the html output here is the sample html snip from reporting
service. see the russian char are displayed as "#238;ì.." (reporting services
is escaping the high characters) when i view source from the IE.
In the browser output it is displayed as something like this .."�ëèòåë"..
when i applied the correct enocding in the IE and i still cannot view
correctly
<html>
<head>
</head><body>
Snip from Reporting Services <br>
/*+ RULE ORDERED INDEX(C IDX_TDC_PS_COST) */
N.CALLING_PARTY_NUMBER_RID as "�îìåð à á. �",
N.CALLED_PARTY_NUMBER as "�îìåð à á. �",
C.call_start as "�à òà ",
N.CALL_DURATION as "�ëèòåë.",
decode (CALL_DIRECTION, 'O',
</html>
Below is the sample html that i consturted manually with russian data from
db directly. When i use the correct encoding i'm able to view the russioan
data
<html>
<br><br>
Non escaped high characters will convert properly with the browsers View |
Encoding | Cyrllic (Windows) <br>
/*+ RULE ORDERED INDEX(C IDX_TDC_PS_COST) */
N.CALLING_PARTY_NUMBER_RID as "�îìåð à á. �",
N.CALLED_PARTY_NUMBER as "�îìåð à á. �",
C.call_start as "�à òà ",
N.CALL_DURATION as "�ëèòåë.", decode
(CALL_DIRECTION, 'O',
</body>
</html>
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello PS,
Changing the data type from Varchar to char will not convert it to right.
Since when you insert the Unicode characetors into a Varchar type column,
the information have corrupted yet. And changing the data type will not fix
those old data.
You may need to contact your application vendor to re input the data.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for that info.
ok then i will input fresh data and test it and will let you know.
Thanks
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hello PS,
> Changing the data type from Varchar to char will not convert it to right.
> Since when you insert the Unicode characetors into a Varchar type column,
> the information have corrupted yet. And changing the data type will not fix
> those old data.
> You may need to contact your application vendor to re input the data.
> Hope this helps.
>
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Wei,
we tested the nvarchar changes with new set of data and it did not work.
The issue we have is not Unicode related because the original russian
characters are ISO-1251. ISO-1251 is just using single byte characters not
Unicode double byte characters.
--
TIA
-PS
"PS" wrote:
> Hi Wei,
> Thanks for that info.
> ok then i will input fresh data and test it and will let you know.
> Thanks
> --
> TIA
> -PS
>
> "Wei Lu [MSFT]" wrote:
> > Hello PS,
> >
> > Changing the data type from Varchar to char will not convert it to right.
> > Since when you insert the Unicode characetors into a Varchar type column,
> > the information have corrupted yet. And changing the data type will not fix
> > those old data.
> >
> > You may need to contact your application vendor to re input the data.
> >
> > Hope this helps.
> >
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >|||Hello PS,
I would like to get the sample database data and your collation settings
for the table and database so that I can reproduce this issue.
Could you please get a simple database backup with only on issue table?
You could zip and send it to me.
To reach my real email, please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello PS,
Did you send your database yet? If anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report Builder: Display Hyperlink

Using the Report Builder, the users need to generate a report in which one of the columns should have a hyperlink that navigates to a particular aspx page.

Now, I am able to provide for a hyperlink enabled column from the static reports designed using the Report Server Project. I have used the Navigation --> Jump To URL property of TextBox for this.

But the users dont want to depend on static reports and need this to be available via Report Builder.

I tried to provide for the <a href="somepage.aspx">xxx</a> from the named query in the datasource view, but when I run the report, the Reporting Service HTMLEncodes the tags and displays everything as text.

Is there a way to generate a hyperlink using Report Builder.

I'd linke to know the answer to the same question: How can you display a hyperlink in a report built using the Report Builder (NOT the report designer). Even a simple textbox that embeds a single url would be nice.... how can this be done?

Report Builder: Display Hyperlink

Using the Report Builder, the users need to generate a report in which one of the columns should have a hyperlink that navigates to a particular aspx page.

Now, I am able to provide for a hyperlink enabled column from the static reports designed using the Report Server Project. I have used the Navigation --> Jump To URL property of TextBox for this.

But the users dont want to depend on static reports and need this to be available via Report Builder.

I tried to provide for the <a href="somepage.aspx">xxx</a> from the named query in the datasource view, but when I run the report, the Reporting Service HTMLEncodes the tags and displays everything as text.

Is there a way to generate a hyperlink using Report Builder.

I'd linke to know the answer to the same question: How can you display a hyperlink in a report built using the Report Builder (NOT the report designer). Even a simple textbox that embeds a single url would be nice.... how can this be done?sql

Report Builder Filter Newbie Question

Sorry for the newbie question.

I've just started building a report to display my IIS logs. I want to filter out all internal IP's, how would I do this?

Thanx

I've figured out NOT but how do I use a range of IP's?

Could I use a wild card

<>"192.168.1.*"

Or should I give it a range'

<>"192.168.1.1-192.168.1.254"

Thanx

|||

Try this

In Filter list

Use an expression instead of selecting the field/column itself like

if u have IPField

left(IPField,10) (this gives value - 192.168.1. (10 chars))

In Operator use != (Not equals)

In Value use an expression = "192.168.1."

Hope this helps u

Report Builder - Format Point Labels

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan

Report Builder - Format Chart Y Axis

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan

report as side by side records display

I want to generate a report for information related to different libraries. It is required to print two library information (two records) side by side in a page. I do not know how to do so.like

libraray name: abc libraray name: abc
address: abc address:abc
phone:30 phone:abc

best regards
kashifIf there is a link between these table, then u can use linking concept and retrieve data from any of the tables.

If not, try to look at the sub reports concept. May be helpful to you.

Report and Images on Interanet

Hi - I wonder if anyone has tried to display images from a intranet site? when I try to do it the images doesn't get render and ends up as [x]. And the same report executed in VS gives me the following error:

The value expression for the image ‘image1’ contains a URL reference, which is not supported.

Any ideas? IS it looking for a .com ... Limitation?

The URL is constructed as follow: http://servername/folder/imagefile

Thanks

Are you rendering the report with the webservice?

What are you exactly trying to do? I had the same problem and in my new article I solved it but I dont know if its what you are looking for, anyway when you read you can ask again or clear the question.

http://levalenciam.spaces.msn.com/

|||The issue was related to bad server/password. Thanks

Reporing Service and deploy permission

Dear all,

I use Window Vista+ Sql server 2005 with SP 2

When I deploy the report in Report designer, the following error message display

The permissions granted to user 'winVista\admin' are insufficient for performing this operation.

The user "admin" is a admininstor and I assign the following group to it

(1) administors

(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER

(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER

Which and Where I must assign the permissions to this account?

thanks you

If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?

Reporing Service and deploy permission

Dear all,

I use Window Vista+ Sql server 2005 with SP 2

When I deploy the report in Report designer, the following error message display

The permissions granted to user 'winVista\admin' are insufficient for performing this operation.

The user "admin" is a admininstor and I assign the following group to it

(1) administors

(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER

(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER

Which and Where I must assign the permissions to this account?

thanks you

If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?