| Author |
Topic |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2009-08-24 : 08:30:58
|
| We have a report with about 40 filters. The user has the opportunity (through a filter) to choose which columns must be visible. This report is based on one base table that is daily generated and has about 800.000 records and 80 columns.When I try to open the report after a few minutes I get a logon window where I must fill in my login and password. When I do tis I get the following window: "You are not authorized to view this page".When I query the table it returns 350.000 records. Is this too much to show within a report? I already changed the time-out setting to "Do not timeout report execution". But I still get the logon window. |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-08-24 : 09:32:12
|
| change your dataset to select top 1 records just to check if its a connection issue |
 |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2009-08-24 : 09:53:42
|
| I tried it with top 5000 and there was no problem so it is not a connection issue. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-24 : 09:57:00
|
I am so happy because I am not that person that has to look at a report with 350.000 records!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2009-08-24 : 10:30:07
|
| The report is used by an analyst who will take an extract to Excel and do some calculations on the data.I can easily make the extract myself and give it to him but thats extra work for me and I thought I could use reports instead for these purposes. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-24 : 10:34:30
|
| Dumb question... Are you trying to export directly to Excel (as apposed to CSV)? Possibly the dreaded 65,535 row limit?If yes, change to CSV and use Excel2007If no, sorry-no idea |
|
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2009-09-01 : 05:37:05
|
| The export to Excel is not the problem. I can't open the report itself. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-01 : 08:04:31
|
| OK-Dumb question(s) #2...Did this report work when there were much fewer records?Is the timeout happening before or after you start selection your column selection filters or after?Based upon your filter selection can you come up with a combination that returns much fewer records?John"The smoke monster is just the Others doing barbecue" |
|
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2009-09-02 : 10:09:35
|
| Hi JCirocco,The report works fine when I limit the number of records to 50.000. When I limit the number of records tot 200.000 then I get the message that I written before.The timeout happens before the selection because it autmatically begins to render my report.I also posted this question on another forum and there they told me that I should upgrade to SQL Server 2008 and perhaps also add more RAM to the server. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-02 : 10:12:39
|
| can you post url you used for accessing report? |
|
|
|
|
Problem opening report